Jun 12, 2024 01:04 PM
I have a table of pricing data for products. It has several hundred products. Without too much modification to that table and its data, I want to add a field with a checkbox so that if Check/Uncheck it will Copy or Remove the data to another table. On this other table, there will be additional fields added. Really a newbie to Automations but I started with the Trigger when the Checkbox is updated and that seems right, but I can't seem to figure out the Action part. Would that be an if/else statement?
Jun 12, 2024 01:12 PM
Sounds like you want to create a link to the other table and use lookup fields to pull that data into the other table.
Jun 12, 2024 01:26 PM
But would the link and data go away if I uncheck the box in the originating table?
Jun 12, 2024 01:37 PM
No. So essentially, you want a processing queue? Data comes into table 1, search for the item in table 2. If found updated record, if not found create record. When complete delete data from table 1?
I would do this with 2 automations. 1 does everything but the delete. In the update/create step set a flag in Table 1 that marks is as "processed". Then your second automation that says when a record in table 1 is "processed" run a script to delete the record. You can only delete records in a script.
Jun 12, 2024 01:57 PM
If I'm understanding correctly, you started off the automation with the correct trigger, but you'll need to use conditional actions if you want everything in one automation. You'd set the condition to if the box is checked and then add an create a record action with what you want it to put in the other table. And another set of conditional actions for if the box is unchecked, with a find records action and run a script action to delete the record.