How to copy the template value to the string field

[Samiksha2]

Hi All,

I have created some templates for a custom field. 
In the custom field, there is a reference field (Template)referencing to the sys_template table (I have added the filter to show only templates related to the table).

On change of Template field, values of that template should be copied to the string fields of the table.

Please help me.

Thanks,
Sam

[Ankur Bawiskar]

@Samiksha2 

then you should be able to achieve using the approach I shared above?

sharing it again here

Now on your table you have a field which refers to sys_template and want to bring the value

Use this in onChange with getReference() callback

1) get the values as encoded query

2) split and then set each field value

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @Samiksha2 

What will happen, or what is the next action, if a template is available in the dropdown? If the client wants that when they choose a template from the dropdown, it should be automatically applied, then this may not be a good use case. It would be helpful to educate the client on the OOTB (Out-of-the-Box) way of working.

[Ankur Bawiskar · Accepted solution]

@Samiksha2 

this worked for me

Template:

onChange client script: on that template field

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }

    var values = g_form.getReference('u_template').template; // give here the field name

    var fieldValuePairs = values.split('^');

    // Loop through each pair and set the value on the form
    fieldValuePairs.forEach(function(pair) {
        var [field, value] = pair.split('=');
        if (field && value) {
            g_form.setValue(field, value);
        }
    });

    //Type appropriate comment here, and begin script below

}

Output:

Before: when template is not selected

After selecting template fields populated

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Samiksha2]

Hi @Ankur Bawiskar ,
It is working. You are awesome!!!

Thanks,
Sam

[Ankur Bawiskar]

@Samiksha2 

Glad to help.