Help

Checkbox in Table 1 add or remove data to Table 2?

Topic Labels: Automations
881 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramsey_Stonebur
6 - Interface Innovator
6 - Interface Innovator

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?

Help me fight a corrupt mortgage company - https://gofund.me/7542ee8b
4 Replies 4
Dan_Montoya
Community Manager
Community Manager

Sounds 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?

Help me fight a corrupt mortgage company - https://gofund.me/7542ee8b
Dan_Montoya
Community Manager
Community Manager

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.

Kyrstin_Graves
7 - App Architect
7 - App Architect

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.