I feel like this has got to be a simple fix but I cannot for the life of me figure out how to make this work after looking through countless other topics on similar issues people have had. I have a Daily Fieldwork form that gets filled out when an employee does a task (there are several tasks to choose from). When that task is a “new install”, an automation creates a new record into another table (Table 2) that keeps track of all of our equipment ID numbers. That automation works great, it copies all of the fields into the new table without issue.
I’m now trying to create a new automation to update specific records in Table 2 when another task (not new install) is selected in the Daily Fieldwork form or when a record is updated in the Daily Fieldwork Table where the form data gets inputted. It doesn’t matter to me which way to create the automation, I haven’t gotten it to work either way. Here’s a look at how I’ve been attempting to create this:
I keep getting the error that either the “record doesn’t exist” or “Received invalid inputs”. I’ve been currently just trying to get the “Notes” field updated from the form to the “Notes” field in Table 2. Any ideas as to what I’m doing wrong?
Well in your screenshot you didn’t tell which record to update (the Record ID field is blank). Use the result of the Find record step (Find Records > Make new list of > Airtable Record IDs)
You will still run into errors if the step finds no matching records, or finds more than one. So you could move your Update Record step to a conditional action group that only fires when Find Records > List Properties > Length = 1