Hello the community,
I am a little bit lost today with something I don’t understand. At this point I don’t know if it is me or an unreleased feature of Airtable…
In AUTOMATION, I want a specific item in Table 1 to be changed when something is modified in Table 2. I have the item ID of Table 1 thanks to a LINKTO field in Table 2.
But… I can’t use the value in LINKTO field and same if I use a LOOKUP field : the values are grayed.
Is it normal ? Did I miss something obvious ?
Thanks everybody :winking_face:
Hi @Charles-ed and welcome!
Can you share a little more information? Which action are you trying to edit in the screenshot above?
It seems like you would want to use the “Update Record” action, but it looks to me like you are showing a screenshot of a “Find Records” action. You don’t need a “Find Records” action since you already “found” the record because it is identified in the Linked Record field from Table 2.
So you can simply go straight to Update Record and input the Linked Record field as the RecordID
That said, even if you were using the Find Records actions, I’m not sure why the options to use data from the trigger step would be disable…
Hi @Nathaniel_Granor ,
Thanks for the answer
I want to check when a record in Table 2 check some conditions and then modify the record linked in Table 1. That’s why I have to find it in the other table so as to update it.
Is it more clear ?
I think so.
It seems like the “Find Records” step is unnecessary:
Your “When a record matches conditions” trigger is already checking the conditions and will identify a single record that (newly) matches the conditions you specified (from your screenshot: “Cloturee” is checked).
Now you can proceed directly to the Update Record step, using the data from the trigger step to select the Linked record:
My problem is that the trigger is on Table 2 : I am watching when Case_resolved = true in the Case table.
Table CASE :
In Table ORDER, I have all my orders and a checkbox ‘Has problem : true/false’
Table ORDER :
How can I change the value of Has_Problem field in the table ORDER when I check Case_Resolved in table CASE ?
Yes, absolutely possible within two tables in the same base. You just have to select the relevant table in each of the Actions.
Trigger: When a record matches conditions
Action: Update Record
table: 1 (ORDER)
Record ID: “Use data from…” the trigger step and select the Link field that points to the ORDER table
Fields: Has_Problem = 0 / unchecked
Thank you it works perfectly !
I was trying to use a linked field as a condition and I could not access the linked field value. I wrote to Airtable support and I share their response with you (I think you already knew that but maybe it can interest other people here).
It is not possible to pass a link field as a condition, because it is an array ! So you have to create a new formula field and refer to this field with the function ARRAYJOIN(YourField,“,”) and now this value is usable as a condition value