Reply to comment

In HTML, you can create input tags, set the type to "checkbox", and indicate the name using either the field ID or field name. If you don’t want your users seeing the field on your form, use the optional parameter "fform" to set the type to be "hidden".

To check the checkbox upon submission, select "yes", "1", "true" or "on" as indicated by the API_AddRecord documentation. To specify that a checkbox is not checked, enter any string other than those listed here or leave it blank. If the checkbox field is required, and is not set to default to ‘checked’ you must enter some kind of data to create the record.

Example using an HTML form:

<input name="_fid_12" type="checkbox">
<input name="_fnm_preference" type="checkbox">
<input name="fform" value="1" type="hidden">

Example using a URL string:

&amp;_fid_12=yes
&amp;_fnm_preference=1
&amp;_fid_12=0

When querying your database, use the information outlined in the API_DoQuery documentation. Syntax examples include:

{'8'.EX.'1'}
{'8'.EX. 'false'}
{'8'.EX. 'yes'}

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit