Unusual Numbers Appearing in Place of Name

[tvinci]

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:

[Jonathan_S · Accepted solution]

Change the format of the column in your sheet to plain text

[tvinci]

This didn’t make a difference

[tvinci]

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.

[Jonathan_S]

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.

[tvinci]

Okay I first I thought you meant in the app. I changed it within the spreadsheet and the problem is fixed. Thank you.

[Jonathan_S]

Great to hear.
Please mark this question as completed

[Bahbus]

Especially if your using Google Sheets, I found that, unlike Excel, it likes to autoformat certain datatypes weirdly if you don’t specify.