Help

Automation not identifying record ID

Topic Labels: Automations
Solved
Jump to Solution
1665 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Andres_Hidalgo
5 - Automation Enthusiast
5 - Automation Enthusiast

Record ID is not being detected by the automation tool.

I need to change a status of a record when another record is created.
But when I link them together it does not detect the ID and the error says the field is invalid.
I have other automations done the same way.

I am using “copy” tables so I don’t mess with my current data

Flow wanted:

The table that is going to be updated is “Control Modulos”

Control Modulo

When record is created in Cosecha → Change status of linked record to “Disponible”

and then

When record is created in Paso Modulo → Change status of linked record to “En operacion”

ID not showing

InvalidInput

Cosecha

1 Solution

Accepted Solutions

If I’m reading you correctly, the form creates the new record, but you add the link to that record manually. Is that correct? If so, that explains why it’s not working. An automation using the “When record created” trigger will run at the very moment the record is created, when that link doesn’t yet exist. By the time you edit the record to make the link, the automation has already run.

To make this work, you’ll need to modify your trigger logic. Instead of “When record created,” you might consider using “When record matches conditions”, with one of the conditions being that the link field isn’t empty.

See Solution in Thread

4 Replies 4

Welcome to the community, @Andres_Hidalgo! :grinning_face_with_big_eyes:

How is the link created? Manually, or is the link chosen via a form and applied when the record is created?

On a related note…

How are these new records created? Manually, or via a form?

The link is created by the link field imagen

The records are created by a form imagen

(Lote Grillo is a link to a Table and No Modulo is a link to the table that is giving me conflict)

If I’m reading you correctly, the form creates the new record, but you add the link to that record manually. Is that correct? If so, that explains why it’s not working. An automation using the “When record created” trigger will run at the very moment the record is created, when that link doesn’t yet exist. By the time you edit the record to make the link, the automation has already run.

To make this work, you’ll need to modify your trigger logic. Instead of “When record created,” you might consider using “When record matches conditions”, with one of the conditions being that the link field isn’t empty.

Thanks for your help Justin, that was the issue!
¡Pura Vida! :v:t3: