I'm using a MS SQL database with the AppSheet app. The table has some non-null columns, which are imported into AppSheets as required columns. The initial value is set to ('') by the app. which makes sense, if I was using java to write to SQL, I'd set the non-null column values to 'value' or '' for blanks. However, when I try to add a row, the operations fails, with a error message that says:
Unable to add row to table 'Xxxxxxx'. → Cannot insert the value NULL into column 'yyyy', table 'SANDBOX.zzzzzzzzz'; column does not allow nulls. INSERT fails.
Changing the database to allow null values is not an option.
Any ideas?
LinkedIn
Twitter
