I’m having some trouble using UpdateRow and/or UpdateNumRow with airtable and I’d be grateful if someone can let me know what I’m doing wrong.
First I create the row in screen A (indirectly, by creating a row in another spreadsheet with a lookup to my main spreadsheet):
This creates the following in my AirTable:
(Extra rows cropped for simplicity)
Then navigate to screen B and update the row:
This prompts the following error:
Using UpdateRowNum creates the same error message, but giving a different field name (which is also valid)
If I use CreateRow here then the row is created successfully, so it’s not an issue with the data or with the AirTable setup, but it means I wind up with two rows where I need one.
I think I may be able to get around this by creating the record at a different stage in the process, but it’ll make the code a lot messier, so I’d be grateful if someone can spot my error.
ETA: It appears the issue is that the block is trying to update the wrong _id - I’m passing it the correct _id (see label above the error message below) but then the error message gives me a different one which doesn’t appear to correspond to any records in my airtable. Is this an artefact of the update process?
Updated images above to show this more clearly.