Currently running v11.8.4.
We’re developing a Self-Service form for managers to complete when new staff are due to start. To all intents and purposes it’s complete, but there’s one thing that is niggling me. The form pre-populates a field with the section value from the affected user (using the Section lookup), but as there is no system lookup for Department or Section-Department we’ve had to leave that as a free-text field.
I’ve been working on an idea of having a custom lookup generated from the Section/Department combinations that is then linked to the field that will hold the department value on the form. What I want it to be able to have this field be single-select with the available list populated with only the values relating to the selected section value.
The lookup table records, the combined section-department names is the shortcode and the department name is the name. Here’s an example:
On the form, the section field is configured like this:
I thought I could use a lookup filter to restrict the returned lookup values based on the section name, but nothing is returned:
Whatever LookupData and section field combination of shortcode and name I use in the expression, nothing is returned.
Is there something basic that I’m missing out, or am I trying for something that just won’t work?
If it’s not possible then we’ll have to stay with the free-text department field, whilst hoping and praying that someone will see the light and include the department and section-department system lookups.
Thanks, Steven