May 16, 2022 06:16 PM
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 ?
May 16, 2022 06:22 PM
The “Find Records” action lets you specify dynamic searches by clicking on the little gear icon to the right:
May 16, 2022 06:35 PM
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.
May 16, 2022 09:29 PM
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