Hmm not sure. Is it just those two fields not working? Or is the input itself not working?
To me, it looks like Airtable can't locate the record to start the update step.
Common causes are:
- Too many RecordIDs in the input
- Wrong Table
- RecordID displayed as Name instead of ID
Not sure if this helps. If not, maybe a bit more clarification on what the issue is. Happy to help in anyway!
Hm, could you provide some screenshots of your table setups and automation setup? I tried testing it and it seemed to work fine for me when I set it up like this, so my set up must be different from yours somehow:
Link to base
Hey there, here are annotated screenshots that I hope explains what I want to do, and reveals what I'm doing wrong.
Here are the pertinent fields in the Assets table, where the automation updates take place:
Note that the Status TEST field is displaying the value "In Progress", which is a result of the automation executing correctly - almost.
Here's the automation configuration:
Here's the record that was created in the Updated Assets LMSC table:
Note that "in Progress" has been added to the Updated Asset Status field.
But, I want to update the Status field in the Assets table. Here's that configuration:
Note that I'm being prompted to select a value from the item selection that's in the Status field, when I really want to specify the Updated Asset Status field.
How do I get this to work?
Also, the Record ID is specified in the Original Asset Rec ID field of the Updated Assets LMSC table:
Let me know if this is helpful and what else I can provide that would help you figure out what's wrong.
Hey there, here are annotated screenshots that I hope explains what I want to do, and reveals what I'm doing wrong.
Here are the pertinent fields in the Assets table, where the automation updates take place:
Note that the Status TEST field is displaying the value "In Progress", which is a result of the automation executing correctly - almost.
Here's the automation configuration:
Here's the record that was created in the Updated Assets LMSC table:
Note that "in Progress" has been added to the Updated Asset Status field.
But, I want to update the Status field in the Assets table. Here's that configuration:
Note that I'm being prompted to select a value from the item selection that's in the Status field, when I really want to specify the Updated Asset Status field.
How do I get this to work?
Also, the Record ID is specified in the Original Asset Rec ID field of the Updated Assets LMSC table:
Let me know if this is helpful and what else I can provide that would help you figure out what's wrong.
Hmm, so you want whatever text value is submitted by the user in the form to appear in the "Status" field in the "Assets" table? This works for me:
If you could duplicate your base without any data in it and DM me an invite I can troubleshoot this for you real quick. I have a feeling there's something I'm not understanding about your setup and that it'll save us a lot of time if I can just troubleshoot it directly!
Hmm, so you want whatever text value is submitted by the user in the form to appear in the "Status" field in the "Assets" table? This works for me:
If you could duplicate your base without any data in it and DM me an invite I can troubleshoot this for you real quick. I have a feeling there's something I'm not understanding about your setup and that it'll save us a lot of time if I can just troubleshoot it directly!
Hey Adam, thanks! That would be really helpful. Let me coordinate with my Airtable Admin to arrange for your accessing an empty copy of the base.
Best way to DM you?
Hey Adam, thanks! That would be really helpful. Let me coordinate with my Airtable Admin to arrange for your accessing an empty copy of the base.
Best way to DM you?
Just a private message via the forums works fine!
