There are 2 tables:
one is a table that I use to create reports on the status of our Lights:
each location has an ID, say 1234 and associated barcodes like a light #, a controller # and a pole #
The other is a table of the entries from the tech team doing maintenance in the field.
they report what ID they worked on and if there were changes in the light #, controller # and pole #
Often the tech crew mistypes stuff and I need to review their submissions before changing our table thus not to corrupt our internal database.
So I synch the Tech’s table in my base and added a few columns like Pole # fix which copies their input as a text so I edit it if needed and I can have a comparison between what the tech inputted and what I edited it to.
I then made a checkmark which is the trigger of the automation, essentially saying that everything is good and to update the light #, the pole # and controller # in our table of the ID that they worked on.
I keep getting “received invalid inputs” error when running a test. It does not seem very complicated thing to do. if check mark, look for ID in this table, if found edit these fields.