Hello all, I’m trying to use a webhook to input data from Jotform → Google Sheets. It’s a simple 2 step task and there’s clearly something I don’t understand. I can’t get the date to correctly end up in Google Sheet. Do I need to convert the data to a string or something?
Hello @Andrew77 and Welcome to the Make Community!
From your screenshots, “Date” is a collection, but Google Sheets is expecting a String/Text.
You could simply build your string in that Date field (whatever column B is), by mapping each part of the date and using hyphens or forward slashes.
For example, instead of 1. Request: Date:, you would have something like this:
1. Request: Date: Month/1. Request: Date: Day/1. Request: Date: Year
Depending on how the cell is formatted in Google Sheets, Google will either store the text as-is or determine it’s a date and store it as a date (large number), but still display it as a date.
I had tried this before, but I wanted to show you what it returns.
Above is the google sheet. It’s as if those fields are empty, so all that is showing up is the slashes.
The data that is correct in the Google sheet was manually entered.
For the record, I know for a fact that there is a date coming from Jotform.
Do you think this is relevant in this case?
[Linking Jotform timesheet to Google Sheets - #4 by Alifar]
Interesting… you can check the Input and Output of the Google Sheets module to see what it is submitting to the Google API.
Is it possible the date is just blank in some cases?