Hello, I have a field that asks when an event happened, but since it is based on the user’s memory, I made it a Text column so they can write ‘relative’ dates like “6 months ago”. This is so the values will be recorded and displayed ‘as-is’.
However, some of them entered actual dates to the format “mm/dd/yyyy” which made AppSheet display the values as code equivalents (like 1/4/2014 is being displayed as 14610 or something); is there a way to stop this from happening?
P.S. The values stored are still correct - the display is what’s behaving erratically here. It’s making it hard for the users to check their own data.