General

Re: When a field contains data, I want to automatically tick a checkbox

warrtalon — Wed, 17 Dec 2008 00:46:28 GMT

Instead of using the word "true" or the number "1," use the function true() if it's available in 2003. I only use 2007, and this is what you use there - true() or false() - but I'm not sure about 2003. I used to try to put in the text, and it would only work if I got the exact syntax correct (it's case-sensitive), but then I learned about those functions that truly set it to true or false instead of the text.

Re: When a field contains data, I want to automatically tick a checkbox

ErnestoM — Thu, 11 Dec 2008 21:33:40 GMT

Reattaching as 2003 compatible. :)

Re: When a field contains data, I want to automatically tick a checkbox

shivajidatta — Thu, 11 Dec 2008 21:30:14 GMT

Hi Ernesto!

Thanks for your reply. However, I couldnt open the file as I am running Infopath 2003. Can you send me a compatible version for Infopath 2003?

Thanks!

Re: When a field contains data, I want to automatically tick a checkbox

ErnestoM — Thu, 11 Dec 2008 21:25:15 GMT

Hello,

I am attaching a sample with a simple example of what I think you are trying to accomplish. I use the functions false() and true() when setting Boolean fields. Please look at the attachment and let me know if I can clarify anything else.

When a field contains data, I want to automatically tick a checkbox

shivajidatta — Thu, 11 Dec 2008 20:25:01 GMT

I have a form that is used to submit data to an SQL database. The same fields are used to show the data of a form already saved in the database. Now, what I am trying to do is, when I retrieve data for a certain form, I want to automatically check (tick) a checkbox if a certain field is not blank. I have set the conditions and rules to set a field's value (the checkbox's value) to TRUE (as well as 1) but the checkbox does not automatically get ticked. The data type of the check box is Boolean. What I observed however was that if the field that I am checking is not blank and if I check the checkbox, I cannot uncheck it (which probably means that the rule is working fine - althouh some action from my part is needed to trigger it off) I would really appreciate any help to resolve this.