- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 02:55 PM
A) When we update a record in one table we would like it to update in another table. For example when the outcome or status changes of a product we would also like the outcome or status to change in a linked record.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 03:44 PM
Hi Penny,
- When we update a record in one table we would like it to update in another table. For example when the outcome or status changes of a product we would also like the outcome or status to change in a linked record.
- Table 1 has a linked field to records in table 2
- Make sure you have a "lookup" field in table 1 that looks up the status field of the record in table 2 (call it status-2). You want to copy this value (status-2) to status-1
- Create an automation that monitors Table 1 status field from status-2. When status-2 changes copy the data to table 1 status-1.
Below is a copy of a similar automation that follows the same format.
- When we add a new record to one specific table we would like the record to be added to our all contacts table.
- I try to recommend against people copying data from one table to another. You can get the data into the other table by using a linked field. The advantage is you can only update the data in one place. your data stays consistent. If your source table really only is a temporary holding place for data before it is created in the final table, create your automation to copy all of the data from your temporary table into your permanent table.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 04:15 PM
Thanks Dan. So going back a step and giving you some more info. We have a check box that when we tick it to show the status has changed in one table we want an automation that will reflect that change and add the information to another table. Can you help with that please?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 06:18 PM
Hm, here's an automation setup which updates a linked record when you mark the checkbox of the primary record:
I'm not sure what your business case is, but you could potentially do this with just a lookup field instead maybe? Here's how it would look using a lookup only, allowing you to save on automation runs:
===
And here's an automation that'll create a record in a second table when a record is created in the first table
Both automations can be found in this base
