Cannot convert URL to type Date

AppSheet AppSheet Q&A
, ,
1

My users keep getting the following errors:

Unable to update row in table ‘Projects’. → Value ‘{“Url”:“”,“LinkText”:“”}’ in field ‘Urgent Approval’ cannot be converted to type ‘Yes/No’.

Unable to update row in table ‘Projects’. → Value ‘{“Url”:“”,“LinkText”:“”}’ in field ‘Kickoff Date’ cannot be converted to type ‘Date’.

Generally that users get the error fixed by discard pending changes, but this is happening very often, I would like some help to understand and fix this issue.

If it matters, the Projects table comes from a SmartSheet data source.

2

You should check the data stored in those two columns in SmartSheet.

A Yes/No column from another datasource must be Boolean of a Text column with one of these values - “”, “Y”, “N”, “YES”, “NO”, “TRUE” or “FALSE” - case does not matter. If there are any other values in the this column they will lead to the “cannot be converted” error.

Similarly, you KickoffDate column can only have blanks or valid date strings.

If all the data looks good, then I recommend contacting AppSheet Support.

1 Like
3

Thanks for your reply. The data stored is compatible with the data type. This was the first thing I checked.

4

I’m having a similar issue. I provided details here: Appsheet keeps trying to push Value '{\"Url\":\"\",\"LinkText\":\"\"}' to a column - #7 by scott192

@maxgonzaga Were you able to find a solution to this?