We have an automation through Make.com which uses an API call to import data into Airtable. This has run for 18 months without issue.
We are recently getting an error 'Field cannot accept the provided value'
The data is a text string which begins with a hash e.g. '# 100'. The field is not a computed or linked field, it is a single line text field.
I cannot see what has changed that this data cannot be accepted now. Any help?
Update: changing the field type to a Long text field has allowed the values to be accepted BUT they now display with square brackets and quotations marks, so ["# 100"] instead of # 100.
Any way to fix this?
Update: changing the field type to a Long text field has allowed the values to be accepted BUT they now display with square brackets and quotations marks, so ["# 100"] instead of # 100.
Any way to fix this?
Weird. It kinda sounds like your data source is passing you an array instead of text suddenly. Any chance you could provide a screenshot of the make run history to see what data you're trying to put into that text field?
@Hello_OFN You can try fixing it on Make.com and Airtable. Airtable way to fix this -
- Store the value in a separate field, e.g. _name
- Update the field type to be Formula and apply regex as the formula:
REGEX_REPLACE(_value, '["\\]\\[]', "")
# This will translate ["# 100"] => # 100
I hope this is helpful!
A way to work around something like this in Airtable without writing scripts would be
Create a 2nd field that has a formula to remove the [] similar to what rk4bir says above. Then create a field that compares your Target field with the formula field. If they don't match set a flag in that field. Then have an automation that overwrites the target with the formula field when the flag is set.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.