Help

Re: Automation to update linked field

Solved
Jump to Solution
785 0
cancel
Showing results for 
Search instead for 
Did you mean: 
calvinscm
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I'm trying to automatically update a linked field with the data that auto populates in the "Auto" number field when a new record/line is created. I can get the data to return but it's all in one field.  I tried to use the "Update Record" option but continued to get errors

calvinscm_0-1713135887833.png

 

Thank you

 

1 Solution

Accepted Solutions
calvinscm
5 - Automation Enthusiast
5 - Automation Enthusiast

Never mind... I figured it out... I should have used "When a record meets a condition"

calvinscm_0-1713139293950.png

 

 

See Solution in Thread

3 Replies 3

Hiya. Is what you're looking for?

 

The trigger is set to "When a Record is created" in "Table with the Auto number"

Action 1: Create Record.
Create a new record in the "TMS" table using the data from the "Table with the Auto number". Making sure that the main title of the record is the auto number.

Action 2: Update record
Update the original triggering record to have this new created record in the link field

 

Let me know is this makes sense 🙂


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
calvinscm
5 - Automation Enthusiast
5 - Automation Enthusiast

Never mind... I figured it out... I should have used "When a record meets a condition"

calvinscm_0-1713139293950.png

 

 

Thank you Sistema and yes, makes sense.

Also, found another solution using when a record meets a condition.

Again, thank you Sistema.