Hi! I have a base with multiple tables in it. I have created a multi-step automation that should work like this:
A record is update in Table 1 (Called ‘Complete Data View’)
That triggers a duplicate record being created in Table 2 (Called ‘Archived Grant Projects’)
Once the record in Table 2 (‘Archived Grant Projects’) is created, that should trigger (via script) the original record in Table 1 (‘Complete DataView’) to be deleted
The automation passes all tests and it DOES successfully duplicate the record in the Archived Grant Projects table. However, it does NOT actually delete the original record in the Complete Data View table. I have tried a bunch of tweaking to get it to work and I’m just lost now.
Here are some screenshots of each step in the automation. Can someone tell me what I’m doing wrong?
I actually got this script from another response on these forums, although I clearly didn’t get it right.
But when you say “You need to have the script get the record id from the input variable by using input.config(). And you don’t need to run the query in the script.” I genuinely have no idea how to implement that. I’m a novice at scripts.