Knowledge: Concatenate Choice Values in Live Formula
Back
    Title*Concatenate Choice Values in Live Formula
    ManualAdministration
    Manual Level TwoData Rooms
    Manual Level ThreeForms Design
    Created14/12/2023
    Detail

    Function 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;
    }
    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages