I have a simple form that shows a grid of a table with 3 columns.
table view:
form view:
In Table view, I can create a new row by entering something into the 'thenote' field and when I press enter, it automatically enters the current date into 'thedate' field.
Not so in Form view, if I try to create a new row by typing something into 'thenote' field, it always prompts:
"Error writing data to database - Input required in field 'thedate'. Please enter a value"
What am I missing? Do I have to start fiddling with macros to get the expected behaviour?
[Solved] Initial value for date not automatic
-
- Posts: 25
- Joined: Sat Jan 17, 2009 7:48 am
[Solved] Initial value for date not automatic
Last edited by wienerschnitzel on Sun Feb 01, 2009 6:07 am, edited 1 time in total.
OOo 3.0.X on Ms Windows XP + linux
Re: initial value for date not automatic
I use to add a label such as "Date (leave blank for today's date)" to inform the user to do nothing or put another date than today.
Turn OFF option menu:Edit>Database>Advanced..."Form checks for required fields" if the field is not a nullable one.
Turn OFF option menu:Edit>Database>Advanced..."Form checks for required fields" if the field is not a nullable one.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 25
- Joined: Sat Jan 17, 2009 7:48 am
Re: initial value for date not automatic
Thanks! That did the trick. Now why couldn't I figure something simple like this out by myself?Villeroy wrote:I use to add a label such as "Date (leave blank for today's date)" to inform the user to do nothing or put another date than today.
Turn OFF option menu:Edit>Database>Advanced..."Form checks for required fields" if the field is not a nullable one.
OOo 3.0.X on Ms Windows XP + linux