Using a check box to copy fields

[Larry T]

I am trying to copy a field from one table to another using a check box. If the box is checked, the value should be the same, if not it should be blank
After several hours, what seems like it should be a simple procedure leaves me with no answer.
My next thought was to build a simple table Field_1, Field_2 and the checkbox Cb.
In form edit mode, using the x basic genie for an 'On push" event for the check box, "Fields -> Set field value"
I end up with the xbasic code below based on using an expression.

'Set 'Value' property of 'Field_2' in Form 'form_table1' .
DIM form_name as c
if is_object(topparent.this) then
form_name = topparent.name()+".this"
else
form_name = ""
end if

DELETE expression_result
expression_result = eval("if(cb,field_1,' ')",form_name)
parentform:Field_2.value = expression_result

Any thoughts on why this does not work would be appreciated.

Larry

[Ted Giles]

Re: Using a check box to copy fields

I downloaded the sample and got little content. It's a PITA to have to create a Db and add the table when a Zipped Db is so much easier to handle. [Tools/Zip]
Suggest you try a Conditional Post. [Field Rules/Post/Condition]
You won't have to use a CheckBox if you don't want to and can automate the process.

[Larry T]

Re: Using a check box to copy fields

Looks like I was not paying attention to what was zipped up. I have corrected it. Now I also know what PITA is.

I thought the check box would be the simplest way to accomplish the field copy as I have about seven fields on the form that I want to copy to seven different tables. The number of fields that gets copied is random so checking off the ones seemed to be the way to go.

Larry

[Stan Mathews]

Re: Using a check box to copy fields

I didn't realize the checkbox control had an onpush event because I've never tried it. Put the same code as the object's onchange event code and it should do what you want.

[Larry T]

Re: Using a check box to copy fields

Stan, I added a button to the form and added the script to the button and now if the check box is checked, this seems to work however it is a two step process and if you forget to press the button you have an error. I could probably figure out how to add a color to check box to indicate pushing of the copy button had occured.

I did not understand your comment "the object's onchange event code". what is the object that you refer to?

Perhaps the code on the check box will not function.

Larry

[Larry T]

Re: Using a check box to copy fields

Well, a little snooze time and more trials and then I stumbled onto Stan's solution of the "on change".

Thanks for the help; now to get it to work with the set relationships.

[Ted Giles]

Re: Using a check box to copy fields

"I did not understand your comment "the object's onchange event code". what is the object that you refer to?"
See attachment.
Right click Object (just the data field not the label as well)
Events
OnChange.

Fires when the data has been changed.

[Stan Mathews]

Re: Using a check box to copy fields

Larry,

Glad you have it working. If you think about it, does it make sense for a checkbox to have an onpush event? To diagnose what was happening I added 1 line to your existing onpush code.

debug(1)

This line opens the debugger window when it is encountered.

"Pushing" your checkbox did not trigger the opening of the debugger indicating that the onpush event was not firing. The likely explanation is that there is no onpush event for a checkbox. The code behind the scenes displaying the event choices is likely generic and the onpush should have been removed in this situation.

[Tim Kiebert]

Re: Using a check box to copy fields

Stan, and Larry and Ted,
the OnPush event for form objects other than buttons is a recent addition. I can't remember if it arrived in v9 or v10. Ok, found it in 'what's new in v9'. http://support.alphasoftware.com/Wha...Smart%20Fields

The Onpush event for fields is related to the 'User Defined Smart Field' feature. In order to make use of this event you need to define an icon in the properties setup tab and enable it. It is the bottom control on the setup tab. The smart field icon appears when the field (in this case a checkbox) has focus. See attached images.

[Stan Mathews]

Re: Using a check box to copy fields

Tim,

Thanks. Have you used the event? I really don't see the purpose.

[Tim Kiebert]

Re: Using a check box to copy fields

Tim,

Thanks. Have you used the event? I really don't see the purpose.

Not to any great degree. I used it once as a mechanism to fire an xdialog that was a customised lookup and another time as a help icon that launched a PDF help page. Nothing that couldn't be done some other way. I just used it 'cause it was there and figured I would see how it works.

[Larry T]

Re: Using a check box to copy fields

Thanks guys for the input on this. I will try experimenting a bit more this weekend, probably the morning that Santa comes.
My revisions did not work as well as I had hoped; looks like I put the check box in the wrong table. Easy enough to fix just makes me wonder what I was thinking when I picked the wrong table. Also wonder why I could not see the "on change" option. I must have spent 20 hours trying to overcome the "on push" and if I had only gazed down a bit and looked at the other options. It sure felt good when it started doing what I was expecting of it.

[Ted Giles]

Re: Using a check box to copy fields

Same thing happened to me with the Security settings a few years back.
Coded far more than I needed to as I hadn't looked at the Table Sec Settings!
The Smart Field seems to need 2 clicks to activate the action. Is this supposed to happen?

[Larry Ternowski]

Re: Using a check box to copy fields

Ted, I tried the setup as Tim mentioned and it seems to function for me on one click.
The icon is there when you have focus and disappears when you move off. As Stan mentioned, it does not seem to serve any purpose on the form.

A test today of the fix for the check box in the wrong table appears to be working although it brought up another issue on a report.
I was using a character field previously (manual insertion of an "x" if selected) in place of the check box for indication that the field was selected. Now I get either a yes/no or T/F depending upon the check box format. Need to figure out how to insert either the X or a check mark and a blank space if not selected. Since the check box is a logical field, there does not appear to be much that you can do with an equation type setup.
Seems like this should have been a selection for the "Format style" in the check box properties when in the report builder mode as I would think it could be used quite frequently.

[Ted Giles]

Re: Using a check box to copy fields

My click through was firing an Action Script. Maybe that's why 2 clicks were necessary.
Must it be an [X]? wouldn't a [Tick] do the job?