Time (and date) Format user locale: submitting different time formats to spreadsheet invalid display

[cd_1]

Hi,

My app is used by users of many different nationalities who have different locale settings on their devices. ie American time format 8:00 am and indonesian time format 8.00 am (also military time too).
In my spreadsheet the time (and date) field is being filled with a mixture of these time formats (8:00 and 8.00). the time field value displays ‘invalid date’ when viewing some of these values from users who use a different time local. appsheet does same with the date field, but it does appear to reformat the date correctly and display it in appsheet view using the users local.

on closer inspection in the spreadsheet. the times being saved in 8.00 format are not being read as a valid time in the spreadsheet (when using =timevalue() to check).

So how to submit valid time value using various formats in appsheet form view so it saves as a valid time in the spreadsheet irrespective of the spreadsheet locale? or how to force my users to use one time format?