What i need to happen, is when one of the yes/no boxes gets checked, i need the (NO TITLE) COLUMN UP TOP to show the selection made as the title. Thanks
Solved! Go to Solution.
You can achieve this using calculated values. I've assumed you have the following in place:
Question for you to consider - are these choices mutually exclusive? i.e. can the user select just one of the options or can they select multiple options? If they can only select one option then I'd recommend changing this to a radio button or drop down list. If they can select multiple options keep in mind your title field could look a bit strange as it's going to concatenate the choices the person made.
In the form:
So what's going on there? The first calculated field is just building up a string of your selections. Let's say the user ticked MyAccess and PlanView. If you display this field you'll see it looks something like this:
The second calculated field simply removes the brackets from the text and more importantly, saves the result back to the Title column. I would have expected to achieve this using a single calculated value instead of two but it didn't work. If anyone can shed light on why this formula doesn't work, I'd be interested:
substring(Request Type, 1, length(Request Type)-2) <-- Request Type being the form control.
Looks like you're missing the substring bit in the second formula. Also, for debugging purposes don't hide that first calculated value. When you click on the check box, you should see that calcualated value change. One more question for good luck - what column type is Hardware/software request from? Is it a choice field?
yes its a choice filed but also i have a yes/no field. i pretty much want whatever selection that is made, on the form to appear as the title
Tolu - Do you have a separate Yes/No column for each of the checkbox controls on your form (Hardware/Software Request, MyAccess, PlanView, ITRA/WorkOrder)?
It looks like's Chris' solution assumes that you have a just one choice column (Request Type) with checkboxes for each option, but stored in a single field. If you don't require separate columns for each option, then Chris' solution would work although as Chris Ben suggested it would be best to use a drop down list and only allow one option. If you do want to have separate columns, then it would be helpful to know how you wish the title to be formatted when more than one checkbox is selected.
Chris - For what its worth, I had the same problem when using only one calculated value, and had to create a 2nd one just as you did. No idea why though.