Bug 120712 - Unable to save new or modified records in forms as controls "input required" field is set to "yes"
Summary: Unable to save new or modified records in forms as controls "input required" ...
Status: RESOLVED DUPLICATE of bug 121188
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-19 17:20 UTC by Silvain Dupertuis
Modified: 2018-11-06 16:34 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Silvain Dupertuis 2018-10-19 17:20:57 UTC
Description:
Since version 6.1, a new feature appeared in Base forms. One needs to change the "Input required" to "No" in all controls of a form in order to be able to save any changes or a new record, otherwise one gets a message saying
Error writing data to database
Input required in field '<Name-of-field>'. Please enter a value
Until version 6.0, although the controls "Input required" field was set always set to "Yes" by default, as long as the table field "Entry required" was set to "No", it did not matter.
It is very annoying if we have to correct all the controls in the all the forms of all the databases... !

Steps to Reproduce:
1.Open a form
2.Modify a field or enter new record
3.Save

Actual Results:
Impossible to save
Error message : "Error writing to Database, Input required in field '<Name-of-field>'. Please enter a value"

Expected Results:
Saving changes or new record


Reproducible: Always


User Profile Reset: No



Additional Info:
I have tested it both on Ubuntu (16.3) and Windows X.
I usually use Ubuntu and dit not hae a previous version at hand.
I went in my Windows installation, everything was working normally with LO version 6.0.4.2, I upgraded to 6.1.2 and I had the same problem as in Ubuntu
Comment 1 Alex Thurgood 2018-10-21 08:11:02 UTC

*** This bug has been marked as a duplicate of bug 120245 ***
Comment 2 Silvain Dupertuis 2018-10-25 08:11:37 UTC
I wrote a macro which browses all the crontrols in a form and disabled on demand the InputRequired field on the the controls which have this property, so that I can use the forms to edit or add data.
Comment 3 Lionel Elie Mamane 2018-11-06 16:34:46 UTC

*** This bug has been marked as a duplicate of bug 121188 ***