Aug 10, 2021 11:59 PM
I have a trigger when a record is updated.
Then, I want to find record depending of a dynamic field from the trigger step.
When I want to add the field, I can’t “insert” it. I can only insert the first one “airtable record ID”.
All other field, there is a ‘continue’ button and nothing afterwards.
Do you know why ?
Aug 11, 2021 12:26 AM
Aug 11, 2021 02:29 AM
Yes (of course). It could have been something like this though.
I can press “continue”. There is the lengh and that’s it. I can’t insert anything. The field is a formula. A basic concatenate formula.
Aug 11, 2021 06:03 AM
You’d be surprised how many times that question solved someones problem :slightly_smiling_face:
And so you’re also sure that the formula field is filled in, in your trigger data? That question also solved a lot of issues believe it or not :slightly_smiling_face:
Normally it should work. Some users on this forum said it helped to remove and rebuild that step. @kuovonne helped some of them, so maybe she knows more?
Aug 11, 2021 12:56 PM
thank you for your reply.
I did it all before. Same. Here are the screenshots:
I am looking to the formula field “Code tarif” with data “8 Excursion à Sian kaan en bateau”.
Then this is the only field I can insert for the action and condition
When I scroll down to the field I am looking for the right field, I can “continue”
Then nothing after :
Do you know why its doing this ?
Aug 15, 2021 04:03 PM
If you duplicate your formula field and turn it to text, you can add text value in dynamic filter.
But you ca’t use formula field in filter (unless it’s primary, i guess, but not sure)
“At the moment, it is only possible to use a date or single-line text field when using the dynamic conditions option”.
that’s quite strange, i’m using simple automations to maintain links between tables in large bases, and often encounter such ‘limits of input data type’
you can use workarounds:
then you can use this ‘anyLabel’ as input data for next step
I don’t know which is better, second lets you to avoid redundant field, but usually I’m trying to act without scripting, where it’s possible.
Well, i hope they’ll fix it soon.