This topic contains 5 replies, has 0 voices, and was last updated by Anonymous 9 years, 4 months ago.
- July 27, 2009 at 2:15 am #263
I’m reporting checkboxes result in a data list, and the results are either TRUE (checkbox is checked) or FALSE( checkbox is unchecked). Is there a way to convert the TRUE FALSE “computer language” into other words such as “Yes” and “No”?
Thanks!July 27, 2009 at 3:04 pm #4693
Add a new Text Input Object onto the form and use that to hold the values that you want to report on.
Use a behaviour like: If Checkbox is checked then value of TI Object = Yes, If Checkbox is un-checked then value of TI Object = No.
Then you can report on the value of the text input object in reporting rather than teh value of the Checkbox.
By the way, the option to modify the value of a checkbox is something that we have already identified as a useful enhancement so it should be included in a future release.July 30, 2009 at 11:54 pm #4698
Thanks for your input. The problem with your workaround is when user double click on the checkbox.
1 st click on the checkbox (Text Input Object = Yes),
2ns click on the checkbox, (which unchecks the checkbox), then Text Input Object is still = Yes.
In this scenario, I would be reporting incorrect information.
I think it id much easier to do a Find & Replace in Excel.July 31, 2009 at 9:26 am #4702
If the behavior is set-up correctly this will work.
If you can forward this question to firstname.lastname@example.org we can respond directly to you with an example form.
It is not possible to attach files to forum entries.August 24, 2009 at 9:20 am #4726
I had this same problem and the way that I got around this for my reports is to use a radio button and in the object properties, change both caption and value to Yes or No or whatever your response is and this then appears in your data results instead of True or False.November 10, 2009 at 12:40 pm #4911
In version 1.15 and beyond it is possible to show alternative results for the checkbox True and False by using the Boolean format option in Data List or Grid column.
Details can be found here:
Version 1.15 was released on 2nd November 2009
You must be logged in to reply to this topic.