I added several new collumns to an existing table with data in it. At creation I marked these collumns: ‘input required: no’ because I don’t know the correct content of these new collumns for the existing data, so these new collumns should remain empty for the already existing data.
However, for newly added data I want these new collumns to be mandatory for record creation. I imagined a solution to this exeption as follows: I have a form for new record creation only. Through the control dialog of the new collumns and then the data tab, I marked ‘entry required’ as ‘yes’. I imagined that this configuration would prompt an error if the user tried to save a new record while the form controls of the new collumns were still empty.
Sadly enough, it does not work. With the above described strategy I can create new records without filling out the new collumn form controls. I tried it with ‘Empty string is NULL’ both ‘yes’ and ‘no’.
I am using LO Base 188.8.131.52 Build ID: 1:6.0.3-0ubuntu1 connected to an online MySQL database through driver: mysql-connector-java-5.1.45 on Xubuntu 18.04
My question is: how can I tackle this ‘input required’ exception through a form?