[Solved] Initial value for date not automatic

Creating and using forms
Post Reply
wienerschnitzel
Posts: 25
Joined: Sat Jan 17, 2009 7:48 am

[Solved] Initial value for date not automatic

Post by wienerschnitzel »

I have a simple form that shows a grid of a table with 3 columns.

table view:
table.JPG
form view:
form.JPG
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?
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
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: initial value for date not automatic

Post by Villeroy »

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.
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
wienerschnitzel
Posts: 25
Joined: Sat Jan 17, 2009 7:48 am

Re: initial value for date not automatic

Post by wienerschnitzel »

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.
Thanks! That did the trick. Now why couldn't I figure something simple like this out by myself?
OOo 3.0.X on Ms Windows XP + linux
Post Reply