Dynamic field "search record" automation action

I’ll

I am trying to develop an automation action that does the following: if a record is updated in table A, check if the name of the field (or better yet, some field ID) is included in a text line field of a record in table B.

In practice, the idea is to have a table A with various fields that are either check boxes or drop down. In table B, there are three fields: a text field, the name of the field of table that the automation should ckeck, and a value.

Any ideas or workaround ?

The “Find Records” action lets you specify dynamic searches by clicking on the little gear icon to the right:

Yes, thanks, there’s unfortunatly no way to do what I need through that : I would need to have both side of this equation dynamic to look up if the content of a cell is equal to the name of a field.

Hm, the only way to grab field names would be via a script I reckon; should be doable. Hit me up with an example base and an example workflow or two and I’ll see what I can do for you

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.