Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have the following question:
Is there any way to automatically select a value from a field if I select another value from another field?
For example: I have fields like Zone and Office. 1 Zone has N Offices.
I want that if I select a particular Office, it automatically select the corresponding Zone.
I'm using the function ONLY (Zone) to get the corresponding Zone.
But I need to know if there's any way to select that Zone with a function...?
Thank you!!!
Are you using a trigger to do this ?
=Concat(distinct Zone,',') will give you all Zones related selected offices
If your data model correctly associates the Zone and Office fields then there is nothing more to do.
Just add a listbox for Zone and another listbox for Office
Selecting an office will automatically indicate the associated zone via the green/white/grey logic.
Green shows the selected values and any associated values are white, unrelated data is grey.
you can use field event trigger; you find it in
menu --> settings --> document properties --> triggers
and then
field events trigger --> on select --> add action --> select in field --> ......
but I think Albert solution is better