Good morning everyone.
I am having this problem in this app where a user can choose a number of DEC needed. DECs are people, tied to single-choice People picker fields (comboboxes) .
Basically I would like that, once I have chosen the number of DEC needed (via the How Many field), the program automatically EMPTIES the unnecessary fields.
So if I select 4 dec, but then decide that I only need 2, the program should empty the fields related to dec3 and dec4.
I used the reset formulas in the OnChange event of the How Many field and the Default and DefaultSelectedItems formulas in the various fields related to DEC (percentage is a simple text field).
Everything seems to work: when I change the number of dec needed, the fields are emptied and when I save everything is ok in field's values.
The problem arises when I then reopen a saved record: the fields are ALWAYS empty!
I guess it's due to the DefaultSelectedItems and Default formulas: how should I set them?
Thank you