Help

Re: 'Field cannot accept the provided value for a single line text field

405 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Hello_OFN
4 - Data Explorer
4 - Data Explorer

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?

4 Replies 4
Hello_OFN
4 - Data Explorer
4 - Data Explorer

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?

rk4bir
4 - Data Explorer
4 - Data Explorer

@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!

Dan_Montoya
Community Manager
Community Manager

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.