Lookup Field Save To

I am trying to use a lookup field but it will not let me set the "Save To" property to what I want. The options it gives me are pictured below. I want to save the selected text to the "Title" field but that isn't in the list. I tried to set the value in code, fd.field('Lookup1').SaveTo = 'Title'; Is there a reason why I can't select 'Title' or why I can't just type in the name of the field I want to populate?

Screenshot 2021-03-09 090050

Dear @smithme,
Please, be careful with your selection here. The value is not stored as text, it's stored in JSON format, and if your selected Save To column will contain values in different format, the field will fail to load properly.

While you can use one of existing fields, we highly recommend creating a new field specifically to store the lookup value.

1 Like

Thank you. Now I understand.

1 Like

Hi @Nikita_Kurguzov.

Is there a way for us to extract the lookup value from the JSON when we choose the "Save to" option of the lookup control? I would like to know if there's a way to just save/extract the lookup value instead of the entire JSON.

Thanks,
stormanh

Dear @stormanh,
You can simply copy the text value to another field when it changes? You'll need to create a field first though, but something like this would work:

fd.spRendered(function(){
 fd.control('Lookup').$on('change', function(value) {
    if(value && value.LookupValue){
      fd.field('Title').value = value.LookupValue;
    }
    else{
      fd.field('Title').value = value;
    }
 });
});
1 Like

Understood, works great! Thank you @Nikita_Kurguzov !