I’m running into issues where users are asked to enter a date into a User-Specific column. In my region, English is the primary language and French is secondary, but widely used as well. The issue arises when a French device enters the date into the User-Specific column. This column gets passed to a form submission as a Column value (the data is captured on the previous screen and brought into the form’s submission automatically as a “Column” value).
When an English user submits the form, the date value gets placed into the Glide Table for submissions properly. When a French user submits the form, the value is blank, but when I double click the cell in the Glide Table, the data is there and is printed out as the date written in plain text — the Glide Date column is not seeing it as a valid Date to use. See screenshots below where the top row is a French user, others are English.
Blank cell in Glide Table, causing computed columns (like the Template column beside it) to be blank as well.
After clicking into the cell (data is there, but is not seen as a Date):