You are viewing limited content. For full access, please sign in.

Question

Question

Collections VS Field Rules for Fields outside the collection

asked on May 11, 2022

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?

0 0

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.

Sign in to reply to this post.