New Bug Encountered: Dates turning invalid in enum list dropdown field

[Victor_Medina]

I am building an ordering system, with a selection box for product picks by date.

Whenever I add a single date, the field seems to update itself, inserting the serial number as the year, leading to an invalid date error (See pick date field in screen clip below). I have checked the underlying data in the spreadsheet, and it is correct.

Can someone tell me if this is something I am doing, or if it is a bug?

Thanks,

Vic

[Steve]

What are the app formula and initial value expressions for Pick Date?

[Victor_Medina]

Both are blank. The valid_if formula is a reference to a field in another table, (picks[pick date]).

The field acts as a definition to call up a list of picks to pull through to a delivery note.

It works perfectly until the form saves and updates.

[Steve]

Is there a spreadsheet formula in the Pick Date spreadsheet column?

Are there any actions attached to the form?

Are there any workflows for the table?

[Victor_Medina]

No spreadsheet formula, no actions, but I am building a workflow.

The workflow outputs a report when the delivery note is marked as ready to send.

[Steve]

And the value written to the spreadsheet is correct?

Victor_Medina:

[…] the field seems to update itself, inserting the serial number as the year […]

What serial number?

[Victor_Medina]

Yes, the value written to the spreadsheet is correct.

Steve:

What serial number?

The spreadsheet translates all dates to a 5-digit serial number. In the screenshot above, the intended date is 09/July/2019, which is stored in excel, google sheets, etc, as the serial number “43655”.

Pick date column should read 09/07/2019, but instead, appsheet seems to be taking the date serial number and reading it as a Year - outputting 01/Jan/43655.

Below is a view of the current data in the sheet, as seen in AppSheet. As you can see, the issue doesn’t come up if there is more than one date selected.

Victor

[Steve]

Ah, so you have a type mismatch. Change the spreadsheet column type for the Pick Date column to date.

[Victor_Medina]

Tried that:

• spreadsheet column is “Date”
• Appsheet column type is “Enum List”, base type “Date”

Still getting the same issue.

[Steve]

Well, I’m at a loss! @Aleksi, can you look into this further?

[Victor_Medina]

Lol. Glad it’s not just me! I’ve been scratching my head on this for about 3 hours! Thanks for trying @Steve

[Steve]

Once you guys figure it out, please let me know what it was.

[Victor_Medina]

Steve - As it turns out - We needed to set the gSheet column type to Text, rather than date.

All fixed now.

[Aleksi]

@Victor_Medina May I ask what is your account ID number and app name if I check your app? Also can you temporary share that gSheet as well with aleksi@appsheet.com?

[Victor_Medina]

Sent via DM.

Victor

[Aleksi]

How about the ID and app name so I could check the app as well?

[Victor_Medina]

I sent it to you on the message. Don’t want to disclose on a public forum…

[Aleksi · Accepted solution]

The column type in gSheet was a date and because the column type is EnumList, it needs to be Text type field.

[Steve]

Thanks, @Aleksi!