Hoping someone can help with this. I'm looking for a way to capture the current selection of a drop down box (populated with field names) to feed into a listbox which will display all the available values within that field. In my mind this should be possible although when I specify the listbox field as an expression (=GetFieldSelections(<FieldName>)) the listbox only displays the name of the field and not the values.
Can anyone help?
You can create a list box using system field $Field and a second list box with a calculated field (<expression>):
You can use your variable instead of $Field, that should also be possible
Thanks for your reply, although I think I need to clarify what I looking for. I want to be able to make a selection from a drop down box (which contains a list of fields - contained with a user created field and not the system $Field) and then when the user selects a field, a separate list box displays the values within that field.Does this make sense?
Hi Matt, and your drop down box is built on an input box to change a variable? Assuming the variable is called vVar, then just use a field <expression> in your list box like
The trick is to use a dollar sign expansion to replace the expansion with the field name, before the expression gets evaluated.
I'm not sure what the problem is. The field names are stated in an inline table in the script and loaded into the drop down menu (the field name values are contained within the 'NewFields' field. The textbox confirm that its storing the currently selected drop down box value, whilst the listbox remains blank rather than displaying the field values.
The field names are visible for me.
No, I mean I can't see all the fields you can select from the drop down in your data model (table view).
Age of August
I can only see one table, FieldMapping, with two fields.
to see the values of all the fields you can select, these need to be part of your model.