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.
Maybe go into the spreadsheet itself, and check that the column in the spreadsheet is formatted as Textโit could be the spreadsheet doing this to you. (?)
Thank you for your reply. No, the data recorded in the spreadsheet is correct. In the example above, itโs โ1/4/2014โ in the spreadsheet. Itโs AppSheet thatโs converting this into a date code.
Apologies. I did not understand at first what you were trying to say. I thought you wanted me to check if the spreadsheet was recording date codes.
You were right - when I converted the data type from automatic to โplain textโ, the display in AppSheet worked.
Thank you!
Awesome! I have battled similar things in my apps.
Thank you again!
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |