Dynamic field "search record" automation action

[christopherl]

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 ?

[ScottWorld]

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

[christopherl]

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.

[TheTimeSavingCo]

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