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
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.
I tried it and nothing changed, here is a screenshot, maybe i am missing something
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
What sub string bit am i missing in the formula for the second form?
substring(RequestType, 1, length(RequestType)-2)
Thanks for the update, tried it and i got this value
just wondering if i am missing anything?
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.
Good to know I wasn't going bonkers Tom! ;-)
My end goal is that whenever any one of those boxes gets checked, i want it to show on a sharepoint field Name "request type" as showed below so when anyone opens the list they can see what the request was for without having to open the form. i want all the boxes connect to the request type column.
What happens if the user ticks more than one box? How do you want the title field formatted?
From what we've discussed so far, my thoughts are that you should stick with a single choice field rendered as tick boxes if you want the user to select multiple items or rendered as radio buttons/drop downs if you only want the user to select a single item.
i want it to be separated by a comma but i just want to know how to link all this together without it breaking.
Cool. In that case, all you need to do is combine all your tick box columns into a single column. The original formula I gave you will work and does not need to change.
i.e. let's say you have 4 separate yes/no columns (Hardware/Software Request, MyAccess, PlanView, ITRA/WorkOrder). Delete all of these and create a new column. Make it a choice column and for the choices, list those 4 options, each on a single line. Change the display option to use check boxes. Then you're done!
If the user selects multiple values, they will be separated by a comma by default - no need for you to do any string manipulation.
Thanks Chris, i went back to the previous formula, and tried it, i feel like i am lost. do you mind doing a walk through for me. what am i doing with this new column that i am creating to combine all the choices.
OK, let's try with a more simple example:
Save all of that and you're done!
This is what the form should look like afterwards. NB I also deleted the attachment stuff because it wasn't required but makes no difference to what you're trying to achieve.
Thanks for the reply, that worked, what if it is more than 1 choice field Chris Ben, and i wanted them to al connect to one field.
Hi, tolu okundaye! If you get a solution, please select a "correct answer" from the thread, as it's helpful to the community members using the search tool for answers to questions like yours. Feel free to continue working, tho. I am enjoying the give-and-take in this thread.
Your community manager
Hi tolu okundaye. I believe your original question has been answered. Could you mark it correct please which assists others who are looking for similar solutions.
Retrieving data ...