i’ve a very simple app to manage date inputs and record on spreadsheet, but i’ve a lot of problems:
- i set google spreadsheet in US formatting
- I select the column and give the date format yyyy/mm/dd on the 3 columns that i need to record.
- try from the app to insert the date (in tree different fields).
- and the spreadscheet record DATE TIME (with hours) data…
when I put a new element i’ve 5 second delay to record
- if I invert the process:
- insert BEFORE data from app THAN change the date format in yyyy/mm/dd it works
- delay is 5 second anywhere
This is the editable app
it doesn’t work with empty spreadsheet!
I’m italian but I switched the propreties in the spreadsheet