I've used Sharepoint and Infopath to create a form for users to add items to a list.
I've managed to create a Choice (allow multiple selections) field in Infopath, which is part of a group, and turn as it's part of a group turn that into a repeating section. Then, I was able to turn the control for that field from a Choice box to a Text Box. I say I've managed to do this, but all of this only functions on the Infopath form. From a Sharepoint point of view, it still sees the column as a Choice Type and refuses to acknowledge it as an option in a Calculated Column view.
Despite this weirdness, the column functions as I want and correctly displays multiple values if the user enters them. Now, for the trickier bit :)
The column with the repeating section has values like this:
B123456, C123456, D456789
I would like to create a second column and convert each of these values into a link, so the same string is displayed, but it links to the page I want.
In the past, I've used calculated columns to do this, but as said above, Sharepoint won't acknowledge that the repeating section even exists... and even if it did, it views it as a choice column, not the text box that I've specified it as in Infopath.
In Infopath, I can create a repeating section containing text boxes, and use an XPath Expression, but I've absolutely no experience with them and don't know how to create a link from them, especially since I need to do it for each item in the first column (however many there may be).
Can anyone give me any advice? Huge thanks in advance.