“Unable to add/edit/delete row in table ‘Underground Agreement Form’. → Value is not supported for this column type. Use objectValue instead. → Error 1235 in SmartsheetProvider retry: Value is not supported for this column type. Use objectValue instead… → Error updating row(s) in Smartsheet:”
[Unable to add/edit/delete row in table 'Regis...](https://community.appsheet.com/t/unable-to-add-edit-delete-row-in-table-regis/1540) Questions
Unable to add/edit/delete row in table ‘Registratie’. → The _RowNumber column is not a valid key column as it does not exist in AirTable. What do I have to do to be able to add or change a record in AppSheet using Airtable? First a view of the table in Airtable. And the second picture of the fields in Appsheet.
The checkbox was selected.
I unchecked it and still got the same error.
I then changed all the dropdown columns in Smartsheet into just text columns.
And made those same text columns “enum” types and still got the same error.
So the question is, can a column be labeled a “dropdown” or “text” in smartsheet, but labeled “enum” in appsheet?
This column is tied to a workflow. When the user selects one of the options given (Email or Both), the workflow automatically sends an email.
I disabled the workflow and still getting the same error however.
But with that said, when I create rows and skip that email confirm column, the error is gone.
Any ideas?
EDIT:
Ok looks like I got it resolved. @Cesar_Hernandez was on to something.
The issue was In Smartsheet I had the “Email Confirm” column set as a drop-down with values in it.
In Appsheet I had that same column set up as an “Enum” column with values in it.
I changed the drop-down to text and the error went away.
Had the same issue.
I also have a column in Smartsheet “Email” but the column type is “Contact List”.
I unchecked “Allow multiple contacts per cell” and problem was solved.
Remember to regenerate the column structure after doing this.
