Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 02, 2021 06:35 PM
Hey everyone!
Today we had an issue where a few of our automations started failing due to all of our “Link to _” fields breaking. We have been using these fields as a main link between tables, and they have all started failing with the same error:
Field “_ ID” cannot accept the provided value: Cannot modify a computed field.
Does anybody have any idea what might have happened? This all started happening around 1:30pm EDT today, and it is not just one table, but at least 4 or 5 tables. Any insight into what might have happened would be very much appreciated. It is a very big workflow issue for our company as this drives a lot of what we work on a daily basis. Thank you!
Solved! Go to Solution.
Aug 03, 2021 07:02 AM
Hey @kuovonne , I’m the product lead on this project.
The problem is that this automation was working, 100% correctly, for 3+ months. So all of your debugging questions, which we appreciate, will be answered in the negative. The automation worked according to spec for several months.
Specifically in response to your suggestion for debugging - the value already exists as value for one record only in linked table. That’s how the automation was able to work flawlessly for several months.
At the time of failure, no user was logged into Airtable and using the system. No new automations or changes were made. No limitations under our Pro Plan were reached. No erroneous record was introduced.
Yet this core automation broke, and our business can not function without it.
In order to debug, Jack, as he mentioned, changed the type of field from ‘Link to [table]’ to ‘single line text’, and this causes the automation to work. But then we can no longer do necessary operations in our workflow - we need to have the field remain a ‘Link to [table]’. So switching permanently to ‘single line text’ is not an option.
So the question is: what could possible cause a long-running automation to suddenly fail at a time when no users were logged into Airtable, no changes were made, and no limits were exceeded?
This is urgent as our business can not run.
Aug 03, 2021 07:32 AM
I’m sorry, but I do not know what could cause a long-running automation to suddenly fail as described in this thread. As I suggested in my first post, I recommend you contact Airtable customer support.
This is a community forum where that vast majority of users are other Airtable customers (myself included). Airtable support will have access to inside information, such as whether or not Airtable changed anything behind the scenes (which it occasionally does without announcement).
When you contact Airtable support, you can include the URL for the automation in question. This support article describes the information that Airtable recommends including in your support request.
Aug 03, 2021 07:57 AM
In the meantime, you can try changing the automation so that the “Create record” action for [Table B] will use the record ID of the triggering record in [Table A] in the {table A ID} field.
Aug 03, 2021 08:22 AM
This seemingly fixed it!
Using the Airtable Record ID is working. We were originally using the autonumber type primary key in the “Link to record” fieldm, but now using the Airtable Record ID is working, and showing the primary key in the field. I believe in the past it would have shown the Record ID itself, the long string starting with rec____
, but it doesn’t seem to be anymore.
Thank you @kuovonne so much for the help! You are amazing!
I will keep in contact with the Airtable support to see whether they have changed something in how the automations work. This is a pretty big breaking change to our automations and I am surprised if we are the only case of it happening.
Aug 03, 2021 03:44 PM
I’m having the same issue (my automation was previously working, then this problem occurred) but I can’t use this solution.
I currently have an automation that pulls in data from a google form, which then creates a new record in Table B. One column is the Primary key to Table A (i.e., one of the google form inputs is the primary key) , which was how I was linking Table B to Table A.
I’m doing something similar in another table to the same effect - now broken after having worked for months. Any possible fix here or update from Airtable Support?
Aug 03, 2021 05:24 PM
I recommend that you contact Airtable support directly.
Can you explain why you cannot use the record ID in the automation? Note that I am not saying to change the primary field in the [Table A]. I am suggesting that you change which value you select in the automation configuration.
Aug 03, 2021 08:49 PM
So my automation flow is:
Trigger: Google sheets row is created
Actions: Create record (in Table B); the record fields are (all pulled from the new google sheets row):
The current error is ‘Field “Applicant ID” cannot accept the provided value: Cannot modify a computed field’
I’m not sure where I would use record ID here, could you clarify?
Aug 03, 2021 10:46 PM
Can you include screen captures of your data and your automation configuration?
Aug 03, 2021 11:17 PM
Intro call table, which is linking to the Enrollment data table:
Enrollment data table:
Automation:
Aug 03, 2021 11:27 PM
Thank you for the screen captures. It looks like your trigger is a new record in Google Sheets, not a new record in Airtable, so you do not have a record ID of a triggering record.
This scenario is a bit more complex than I can volunteer to troubleshoot over the forum right now. Hopefully Airtable support can give you some feedback on why the automations are no longer converting field data properly any more. It may be in part because the value is a number and not a string.