Hi there :slightly_smiling_face:
I’m new to coding and Airtable and I need some assistance.
My script is to update a record with user input. The issue I’m running into is in line 7. The script runs but I’m assuming it is this error that stops it from actually updating the cell. I understand the error but I’m just not sure how to remedy it. I’d also like to know how to output the new_date variable within the text output line above it.
Solved
'record' parameter type in updateRecordAsync() not compatible with input.recordAsync()
+5Best answer by kuovonne
You are getting the squiggly red underline that says “record is possibly null” because it will be null if the user closes the record picker without selecting a record.
Your other issue is that a date field need to be set to an ISO date string. You cannot use Airtable formulas to parse the date. You need to use JavaScript to parse the date and then convert the date to an ISO string.
+16Hi @Sarah_Viljoen
Your variable record should return two items, id and name. I think you need to pass the id into the update. So record.id
+5Hi @Vivid-Squid
I tried that but then it says “Object is possibly null” and it doesn’t work. I also then have the issue (I think this is the issue) where the string passed into new_date by the user needs to be a date variable, not string. I’ve tried using DATETIME_PARSE() to convert it to a date but it isn’t recognizing the argument at all.
+29You are getting the squiggly red underline that says “record is possibly null” because it will be null if the user closes the record picker without selecting a record.
Your other issue is that a date field need to be set to an ISO date string. You cannot use Airtable formulas to parse the date. You need to use JavaScript to parse the date and then convert the date to an ISO string.
+5You are getting the squiggly red underline that says “record is possibly null” because it will be null if the user closes the record picker without selecting a record.
Your other issue is that a date field need to be set to an ISO date string. You cannot use Airtable formulas to parse the date. You need to use JavaScript to parse the date and then convert the date to an ISO string.
Thank you so much ! I will go check out how to use JavaScript to do that and I’ll come back with any questions if I’m still having issues.
+5This is probably a very simple issue but I can’t seem to get it right. I’m still having trouble with converting a string variable to a date. My ESC DATE field is a date field and it’s where the user input will go. I just need to convert what the user inputs (they are prompted to type it as ‘Month Day, Year’) to a variable type that will be compatible with my date field. I checked out the links you kindly provided me with but I’m still confused.
+5@kuovonne I got it working ! I played around using the links you provided. Thanks so much for all the help ! @Vivid-Squid, the ‘record.id’ does work, I just thought it didn’t because of the red squiggly line. Thanks for helping me !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.