Knowledge: Concatenate Choice Values in Live Formula
Back
Knowledge
Title*Concatenate Choice Values in Live Formula
ManualAdministration
Manual Level TwoData Rooms
Manual Level ThreeForms Design
Created14/12/2023
DetailFunction to return selected checkbox choices as a delimited string, please in input form header script and use in live formula on form using example: getCheckedChoicesAsString("TextField26", "-");
function getCheckedChoicesAsString(tableID, delimiter)
{
let tbl = $('table[databasevalue="' + tableID + '"]');
let selectedOpts = $(tbl).find('input[type="checkbox"]:checked');
let str = "";
for (let opt of selectedOpts)
{
str += $(opt).val() + delimiter;
}
let trimmed = str.replace(new RegExp("[ " + delimiter + "]*$"), '');
return trimmed;
}
Additional Manual Locations