Search constraint comparing fields in same record. Possible?

I want to present a repeating group with records that have not changed since they were added (along with some other criteria.)

Essentially, I want the criterion to be Modified Date <> the record’s Created Date. Unfortunately, the list of available options doesn’t seem to provide any fields from the data type being searched.

Is there any way to do this?

You’d have to use an advanced filter. Something like this:

Another option is to have a yes/no field under the Thing called “updated” or something and any workflow that makes a change would also set this value to “yes.” That way you can leverage that field on the server side (and not in an advanced field)… Search for Things where Updated = no.


Gaby at Coaching No Code Apps (formerly Coaching Bubble)

Courses & Products, Tutorials, Private Coaching, and High-level Development

Start Learning Today :mortar_board:

3 Likes

That seems to have done the trick. Thanks! :slightly_smiling_face:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.