Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to disable values in a Multiple Selector object?
For example, I have a field Category with values A, B y C.
I want to select values A and B by default when I open the App.
Is there any way to disable the value C, so that I couldn't select it?
Thank you!!!!
Hi,
Yes make a trigger for selection fields.
Thanks & Regards
It depends on what you want...
If you don't ever to have value C, filter it out in the script.
If you want to have it but not in filter, create an additional field, same as Category but doesn't include value C.
If you want all three values in filter but C not available for selection, select A and B by trigger, as Anand Chauhan suggests, and lock the field.
Hi,
Right click on the sheet properties and select triggers option and in sheet event triggers click add action
select there select in field option and click ok then in field option select field and in search string type your field.
Thanks & Regards
You can create expression in the list box as follows:
aggr(only({<Field={'A','B'}>}Field),Field)
so it will show A and B only with option to select one of them or both
Thanks!