Two fields the if CheckBox= True

[Keith Hubert]

Hi,

Just a small part of a bigger project.

I have two date fields and a checkbox for a logical field in a grid.

Very simply I would like Date two to be filled the same value as date Date one if the checkbox is checked.

Suggestions please.

[gobbligook]

Re: Two fields the if CheckBox= True

Try something like this (syntax will need to be verified) in your on insert/update events for the grid.

if ((datasubmitted.date1 <> "") .and. (datasubmitted.checkbox1 = .t.)) then
datasubmitted.date2 = datasubmitted.date1
end if

[Keith Hubert]

Re: Two fields the if CheckBox= True

Hi Wesley,

Thanks for getting back to me on this.

I would like the second date to be filled before submitting.

I'm now thinking, AJAX. What do you think?

[Rich Hartnett]

Re: Two fields the if CheckBox= True

Keith I don't have an answer for you, but I am very interested in the responses. I too, have a similar situation, and if it will work with your date fields, it will work with my name, address, and phone number fields.

Let's hope someone has good news.

[gobbligook]

Re: Two fields the if CheckBox= True

Is this because you need to have the user see the fields before submitting? If this is a yes, then you'll need to use java. You may want to think about why this is a requirement.

If it is acceptable for the user to see the field after they've submitted, then the solution I suggested will work for you.

[Steve Wood]

Re: Two fields the if CheckBox= True

You probably could figure it out with Javascript, but here's maybe one reason that would be difficult and why grids don't generally do this, and dialogs do.

Your client is looking at a dialog and you want that date2 field to fill in when they select some checkbox. The field name and ID for that date2 field is...."DATE2". So its pretty easy to fashion some code to affect its value.

Same situation on a grid, that date2 field is named....you don't know what it is named. Maybe its V.R1.DATE2, maybe its V.R14.DATE2 (different for each row). So I think the logic would have to be written in to the Grid to make it possible. YOU are not going to be able to determine what the ID or Name is. The Grid should be able to know if it had built in logic, and if it did, then I would suspect the same sort of logic that works on a dialog would work on a grid. But the grid does not contain this intellegence.

This is a guess on my part.

[Keith Hubert]

Re: Two fields same if CheckBox = True

Hi Steve,

Thanks for your input on this.

The idea is that a user is filling in a form and for convenience, to just check the box and the second date would autofill instantly.

In one of my desktop applications, I have a button that copies the values from one field to another when pressed.

If you think the dialog route would be easier to implement could you advise how this could be done.