Jump to content

Populate field via checkbox [simple newb ?]


This topic is 5721 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have an invoice db, in which I have a checkbox for whether or not the invoice has been paid. Upon checking the box, I would like my 'date paid' field to be populated with today's date.

I have this script on the date field, but am not able to get it to work:

If ( paid checkbox = "yes" ; Get ( CurrentDate ))

Can someone help?

-Adam

Edited by Guest
Link to comment
Share on other sites

.. Firstly... your checkbox should just be attached to a value list with one value... that value being yes... secondly your date field should be set to auto enter... ... your if statement seems to be missing something...i.e. it should look like this...: If(paid checkbox = "yes"; Get(CurrentDate); "")

Hope this helped, i cant see much else that could be causing the problem

Genx

Genx

Link to comment
Share on other sites

Thanks, I fixed the script. I've attached the checkbox to a value list containing only 'yes', but now I get the following error when clicking the checkbox:

"checkbox" is defined to contain only specific values. You must enter a valid value.

- Adam

Link to comment
Share on other sites

... thats cause you've set the validation to something funny... goto define database, goto the check box field, click options and turn off any validation because you wont need it anyway...

Genx

Link to comment
Share on other sites

I don't understand, what extra validation? All I've done is link the checkbox to the value list containing only 'yes'. If I don't connect it to the value list I no longer get the error, but the date field is not populated.

Is it possible for you to post or email me a working example?

Link to comment
Share on other sites

This topic is 5721 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.