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?
Checkbox in Table 1 add or remove data to Table 2?
+7
+17- Employee
Sounds like you want to create a link to the other table and use lookup fields to pull that data into the other table.
+7Sounds like you want to create a link to the other table and use lookup fields to pull that data into the other table.
But would the link and data go away if I uncheck the box in the originating table?
+17- Employee
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.
+11If 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.