Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I've a condition to establish.
If one or more fields from a specific table is selected -> value A else value B.
I try to avoid all fields from a calendar table. Any way to ignore those fields without set analysis ?
You could do something like this to avoid listing the field values manually:
=if(
$(=concat({<[$Table] = {'MasterCalendar'}>}'getSelectedCount(['& $Field &'])', '+')) > 0,
'Value A (One or more calendar field is selected)',
'Value B (No Calendar field values are selected)'
)
You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount() .
You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount().
I was going to use getSelectedCount() and yes that's a good way for a few fields.
But how about more than 20 fields?
May be this is one of the options you can try
Ignore all selections except some specific fields using Set Analysis
You could do something like this to avoid listing the field values manually:
=if(
$(=concat({<[$Table] = {'MasterCalendar'}>}'getSelectedCount(['& $Field &'])', '+')) > 0,
'Value A (One or more calendar field is selected)',
'Value B (No Calendar field values are selected)'
)
That's what I'm looking for.
Thanks a lot @Vegar