https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Split_Multiselect_Values 2026-04-03T23:02:02Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Split_Multiselect_Values&diff=237&oldid=prev 2020-05-25T20:44:30Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Smtxwiki https://wiki.smt-x.com/index.php?title=Split_Multiselect_Values&diff=236&oldid=prev 2016-12-19T10:23:25Z

<p>Created page with &quot;Cae : we have a multiselect field (checkbox) and we need each individual value (to call a subform). So how to move from the piped values into seperate values (each value in a...&quot;</p> <p><b>New page</b></p><div>Cae : we have a multiselect field (checkbox) and we need each individual value (to call a subform).<br /> So how to move from the piped values into seperate values (each value in a seperate field)?<br /> <br /> we will use substring :)<br /> <br /> example:<br /> <br /> checkboxes contain a list of IDs (!!always 3 digits!!), and in a second column the name of the subform.<br /> <br /> suppose they select 187||203||567<br /> <br /> to extract the first value (&#039;187&#039;)<br /> <br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 0,3)<br /> <br /> &#039;0&#039; indicates the starting position, &#039;3&#039; indicates the number of characters we need to pull out<br /> <br /> the second value would then be found via:<br /> <br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 5,3)<br /> we start at position 5, because of the first 3 characters and then the 2 pipes<br /> <br /> <br /> for the following elements:<br /> <br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 10,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 15,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 20,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 25,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 30,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 35,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 40,3)<br /> SubString(&#039;#REPLACE-FORMFIELD-Bart approval test||Subforms||Nr#&#039;, 45,3)<br /> <br /> sample form: http://dev.ssp7.smt-x.com/Forms/Admin/formDetail.aspx?tab=1&amp;id=81&amp;ActiveFieldId=8175</div>

Smtxwiki