Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Script to convert google form date to AT-compatible format

Topic Labels: Automations
1393 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Noah_Coleman
6 - Interface Innovator
6 - Interface Innovator

I’m making an automation that edits an Airtable record with a date pulled from a Google Forms submission. I know from this post that the formats are incompatible, but I didn’t know if there’s a way to convert the date in a script to a format that Airtable finds more palatable? Is there something like DATETIME_PARSE() for scripting?
I could create a column for the incoming date and a column for the DATETIME_PARSE() formula, but I’d prefer to do it in a script and avoid cluttering my base.

2 Replies 2

Yes, there are many ways to manipulate the dates using javascript date functions.

Noah_Coleman
6 - Interface Innovator
6 - Interface Innovator

Update:
I think I was able to correctly parse the date. I’m no longer getting the error “Field “x” cannot accept the provided value: Could not convert string to date”. So, I assume it is in the right format. I am now getting an “Updating the record failed due to insufficient permissions” error.

Script code:

let inputConfig = input.config(); // pulls in inputs
// console.log(`The value of gsTimestamp is ${inputConfig.gsTimestamp}`);
var toFormat = new Date(inputConfig.gsTimestamp); // create a variable with the input as a Date
var atTimestamp = toFormat.toJSON(); // convert the date format to JSON
// console.log(atTimestamp);
output.set('atTimestamp', atTimestamp); // output in correct format

So, I think it worked, but it is still not updating my record.