I've noticed that field rules only apply against the first row of a collection. Whereas, I'm looking at a field rule to apply against if it sees a match in any row of the variable in the collection. Anything I'm doing wrong or am I subjugated to using JS to update extra hidden variables to manage this?
Question
Question
Replies
replied on May 11, 2022
It depends on what you're doing.
If your comparison field is within the collection, then by default any field rules set for a collection field will only apply based on the value within that set.
If you want a "global" value for the field rule, then you need to use something outside of the collection.
So, if you want to check if "any" of the collection sets have a specific value in a particular field, your best option is probably to use Calculations/Formulas to create a field specifically for the field rule.
For example, you could do something like
=COUNTIF(Collection.Field,"Target Value")
Then set the field rule to show/hide based on whether or not that new field is greater than 0
0
0
You are not allowed to follow up in this post.