I am creating a driver/dispatch app. When I create a route named โMay 14โ, the route name appears as numbers, although in the backend it appears correct:
Frontend:
Backend:
Solved! Go to Solution.
Change the format of the column in your sheet to plain text
Change the format of the column in your sheet to plain text
This didnโt make a difference
Okay for some reason I noticed this only happens when I try to set a date as the name. I just tried again with โtest route 14โ and everything went smoothly.
From my past experiance this has always been a sheet based problem. Ive ussually only had to set the column as plain text and everything worked fine. Sorry I cant help out in any other way.
Okay I first I thought you meant in the app. I changed it within the spreadsheet and the problem is fixed. Thank you.
Great to hear.
Please mark this question as completed
Especially if your using Google Sheets, I found that, unlike Excel, it likes to autoformat certain datatypes weirdly if you donโt specify.
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |