Auto fill form?

Frankyy

New member
Local time
Today, 02:42
Joined
Mar 26, 2009
Messages
2
Hello, Ive got a form that I want to be autofilled.
View attachment 26362

First of all I want the form to be cleared when It opens, the values that are showing now is one of the all ready registered items.

Leiedato: In this field I want todays date.
Innleveringsdato: In this field I want tomorrows date.
Pris: And in this field I want a value.

The dates I want in yyyy-mm-dd form, so I have a little problem with the Date() command.

Thanks for any help :)
 
For Leiedato you can put this in the default value of your field:

Code:
=Format(Date();"yyyy-mm-dd")

And for Innlevering:

Code:
=Format(Date()+1;"yyyy-mm-dd")

If you get a syntax error replace ; with ,

JR
 
That worked great!
Many thanks :)
 

Users who are viewing this thread

Back
Top Bottom