Jan 26, 2021 09:39 AM
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.
Jan 26, 2021 10:28 AM
Yes, there are many ways to manipulate the dates using javascript date functions.
Jan 26, 2021 10:28 AM
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.