-
CEOGlobalAsked on December 19, 2018 at 7:55 PM
I have a date field entry in my form. The user enters it in month, day, year format.
After the user enters the date, I need to have a field that uses the month, day, year entry and changes it to year, month, day format.
Eventually, I will hide that field in the form but then it will show in my google sheet integration.
Any ideas?
-
Richie JotForm SupportReplied on December 20, 2018 at 12:18 AM
You can add two date picker fields. One for the MM/DD/YYYY Format and the other for the YYYY/MM/DD. Then you use the Update/Calculate Field condition to copy the fields value of Date1(MM/DD/YYYY) to Date2(YYYY/MM/DD).
This condition will convert the dates to the correct format automatically.
You then make sure the "Clear Hidden Fields Values" is set to Don't clear in your Form Settings.
You can now hide your date 2 and integrate your Form with Google Sheet.
https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets
Sample screenshot:
Sample Form:https://form.jotform.com/83530499759978
Please give it a try and let us know if you have further questions.