Insert Data

[JanineB]

I have a simple table with "ID numbers" for the City of a specific Country. I have my main data table that includes a "ID number" field. How can I update all of the records in the main table with the matching ID number? I want to match up the ID numbers in each table in order to do insert of data on an empty field. Thank you!

[Kurumi]

Hi! You can actually do this using Tasks. Tasks are very similar to Triggered Actions. The main difference is what triggers them. For more information about Tasks, you can check it here: https://howto.caspio.com/tasks/

I hope it helps!

[BaySunshine]

Hi @JanineB,

Tasks can be set to run at specific intervals during  the day, week or a month etc.  However, if you are looking for updating the empty values as soon as they are inserted, you can use a trigger. For this, create a triggered action on the main table based on an insert action on the table.  Then add a update trigger to update the inserted table field. Add a join to join the inserted table with the city table based on their ids.

Hope that helps.

[imJihyo]

Hi there @JanineB, a bit late here but I wanted to do the same and came up with this Task. You may use this for your reference if you haven't created yours yet 

 

 

I hope this helps!

 

- Jihyo ♥

[RuisiHansamu]

Hey there, I believe this forum post could be useful as well in regards to your questions: