Error details from database provider: Column 'propertyID' cannot be null

[San_Tou]

I have a problem when inputting a new record on a View.

When sync, it displays as:
Unable to add/edit/delete row in table ‘tbl_function’. → One or more SQL errors has been encountered: A column in your MySQL table cannot be null. Please make sure that you provide a value for this column. (error details from database provider: Column ‘propertyID’ cannot be null)

However, the column propertyID is NOT required in the Column settings,
I have checked using other front end and phpmyadmin to add a record in the table and leaving the proeprtyID blank, no issues.
what else can be the problem?

Your help would be much appreciated.

[stilllifemuseum]

Hi! Please share a screenshot of your table setup. I think you missed a UNIQUEID() formula in the “Initial value” of the propertyID column.

[San_Tou · Accepted solution]

I think I have figured out what the problem was
in the Mysql backend I have set it up as Null (which i think makes it a required field)
i have now fixed it, thanks.