Update Record Received Invalid Inputs Record ID but the record ID is there and correct.

Hello back, 
 

I found why !!!

SOLUTION
Clean the record_id with formula :
REGEX_EXTRACT({RECORD_ID}, "rec[a-zA-Z0-9]{14}")

PROBLEM FOUND
While I don’t understand where these white special characters may come from, I found that the text from the form is not clean (while it is invisible to eye)…

I don’t really understand where this might come from as I prefill the field with record_id only and hide it so it’s untouchable : 
https://airtable.com/appNAdRxx7AIxxXXX/pagXXXPM3BbOCrTsN/form?prefill_RECORD_ID={Record_ID}&Type=Devis+sign%C3%A9&hide_RECORD_ID=true&hide_Type=true 
 

If someone find the answer, I welcome it ! :)

 

​@Dodelita 

Just an FYI:

The much easier & more bulletproof way to update records from a form is to use Fillout’s advanced forms for Airtable, because:

• it doesn’t require creating any complicated prefill links
• it doesn’t require any complex automations
• it doesn’t require continually sending out a new prefill link, and
• it doesn’t require collecting extraneous records in an extraneous table.

Fillout is 100% free and you can learn more about this feature here: 

• update Airtable records using a form

Fillout also offers hundreds of other features that Airtable’s native forms don’t offer, including the ability to:

• create custom PDF files from a form submission
• accept payments on forms
• pre-fetch dynamic data from an Airtable record
• customize the style and branding of your form
• customize a theme for your form
• display Airtable lookup fields on forms
• create multi-page forms with conditional paths
• create new linked records on a form
• add a login page to your form
• perform math or other live calculations on your forms
• collect signatures on a form
• connect a single form to dozens of external apps simultaneously
• add CAPTCHAs to your form
• and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Yes, thanks a lot ​@ScottWorld :)

The person I work with still prefer to use only one tool even though going through with Fillout would be a whole lot easier… 😶

Thanks for your answer and advice, reminding me to push the subject once again 😊

You’re welcome! Glad I could help! :)

- ScottWorld, Best Airtable Consultant