When I use a month (eg Sept 2018) as a label ...

(Peter Teo) #1

When I use a month (eg Sept 2018) as a label in a column, Appsheet converts it into a number 43344 when the table is updated. I can manually edit the column header in AppSheet to say Sept '18 so that is what is displayed but it creates an error when I try to deploy the app. Can date headers be seen by Appsheet in a date format rather than a number?

(Suvrutt Gurjar) #2

Hi @Peter_Teo Could you please add a bit more about the condition?Have you named the column header as “Sept 2018” in back end spreadsheet?

When you mention “Label” are you referring to AppSheet column definition “Label” that you can set?

What is the column type in AppSheet and what kind of data you will have in this column?

(GreenFluxLLC) #3

try setting the column type as text, and set the formula to

TEXT([date_column])

(Peter Teo) #4

Thanks Joseph. I am not sure I understand the recommendation. Perhaps some background will help we run a free meal program for the needy and I am trying to use app sheet to track usage. Each client is given a card which has a barcode that identifies the individual. The card has to be renewed monthly. We do this to update our records on the status of the client. So the columns are used to tell us if the meal program is active in a particular month for a client and also used to let us know if the client has had his status updated before he/she picks up a meal.

(Peter Teo) #5

Hi Suvrutt.

I am using google sheets and the column header is a date “18/09/2018” It is displayed as Sept, 2018. In Appsheet Data-> Columns if I look at the column name, it shows up as a number. I can edit the number and replace it with Sept '18 but then I get the deployment error.

(Peter Teo) #6

Joseph. I need the column type to be Yes/No.

(Suvrutt Gurjar) #7

Hi @Peter_Teo May be you wish to name the column as say M09Y18 or something similar in Google sheet and in the AppSheet you can define the display name of the column as “Sept 2018”

(Peter Teo) #8

The display name is September 2018 so it does display OK in the app. Its just hard to read under column type. I need to make sure I have the edit the column. I’ll probably set the columns as text in google sheets. I have 12 “date” columns so using date allows me to" fill columns" and saved me time. I did not know it would not work till I tried to check deployment.

(Peter Teo) #9

I mean I need to make sure I have the right column when I edit it.

(GreenFluxLLC) #10

@Peter_Teo I think I misunderstood your question at first. Are you saying that the column’s actual name is a date, and the row values are yes/no? In other words, are you tracking if something happened on that date?

If that’s the case, then it sounds like AppSheet is interpreting the column name as a number. Try entering the date wrapped in quotes.

Do you have other columns named for different dates?

(Peter Teo) #11

Yes about a year of months. You are correct, the column’s actual name is a date and the row values are yes/no. I am tracking something that is happening on that date. The same problem occurs with all the other columns with date. Looks like the way out is to enter the date as text. I’ll do that. Thanks

(GreenFluxLLC) #12

@Peter_Teo Ok, I understand now. It does sound like AppSheet has a problem interpreting a column name that contains a date, but I wouldn’t worry about it. You shouldn’t be adding new columns for each date.

I would consider restructuring your data. You should be adding new ROWS of dates as new records, not adding new COLUMNS and changing the structure of your database to add new dates.

See if this helps: help.appsheet.com - The “Item-Detail” Data Pattern

The “Item-Detail” Data Pattern help.appsheet.com