Hi guys, hope you all doing well.
This is the error message:
Try finding any columns with DateTime column type and go to Data -> Table -> View Data/View Source and check if it's showing the correct data
Thank you for the reply. I have tried what you suggested and find that some tables give that error message when I choose the <View Data> option. So it doesn't show the data but just that same error. I made sure that these tables have a good source and I regenerated there structure. But no luck, still getting that error. Please help?
Check the format of the DateTime in your Source.
Thank you June, I went through all tables and source files and set all datetime field to the correct format. I found in one datetime column of the source file some none date taxt and removed it and thought that was it but nope, still same problem.
There is about 5 tables that give that error when I want to do a "View Data". All I get is this:
Error: String was not recognized as a valid DateTime. ?
Please don't give up on me, I do not want to rebuild this whole app.
Have you tried regenerating the tables after you check the data in your source file?
Please post a screenshot of the error message.
Does the app editor itself display any error messages? if so, please post a screenshot of them as well.
I suspect you're going to end up having to engage Support for help with this. The error message suggests an internal problem.
Hi Guys, thanks for looking into this.
Yes, June, I regenerated all the tables giving the error when doing a View Data.
Thanks Steve, here the screenshots.
And this is when doing a View Data on some of the tables. About 5 tables give this error while the others are fine.
I will also contact support.
I've encountered this problem before. If I remember it correctly, I've cleared the data in all of the DateTime columns, refresh the app, and it ran successfully. I found out that there's something wrong in the format of the data in my source and DateTime is saved as Longtext not mm/dd/yyyy.
What is your source please? Is it Google Sheets?
Yes, Google Sheets
Here's a trick to sanitize your google sheet, looking for invalid and blank date or dateTime values that might be causing this error, and make them easily identifiable:
This formula will return a result that is either TRUE if the corresponding cell contains a valid date or dateTime value, or FALSE if it contains an invalid or a blank value.
You can then use the sheet filtering and/or conditional formatting to show only/highlight rows with FALSE values, which will enable you to easily locate and correct the corresponding values accordingly.
Then, remove this temporary column from your sheet and try again with AppSheet.
I think @JuneCorpuz is on the right track.
Make sure the date-time values in your data source are formatted properly as valid date-time values. There should be no non-blank, non-date-time values in that column at all.
Delete all blank rows and columns in your worksheet. Delete, don't just clear.
Explicitly clear all seemingly-blank cells in the column of the worksheet, to ensure any formulas and hidden characters are removed.
Highlight the entire date-time column and set the entire column's format to plain text. Inspect every value of the column to ensure it matches the required date-time value format: MM/DD/YYYY HH:MM:SS. Note very carefully that the month number (MM) comes before the day number (DD). If reversed, the value may not be a valid date-time.
Thanks June and Steve, I did this already but will double check.
I did this again now, no luck. Lets see if support can have any suggestions. Thank you
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |