Unable to successfully use Extra Fields

Hi Plumsail Team,

I am still using our trial version of Forms. I need to be sure all of the functions we need will work prior to purchase.

In a form, I am trying to use the "Extra Fields" and "Expand" properties of a three field cascading lookups.Below is an example:
List one: "State" shows all states
List two: "City" shows a list of cities filtered using "Depends on" by the selected State
List three: "Hotels" shows a list of hotels filtered using "Depends on" by the selected City

I want to show the "Street Name" of the Hotel in List three. It is saved in the Hotels Source Data list.

However, in List three, when I add fields (Address, Hotels/Id) to the "Extra Fields" and/or (Hotels) "Expand" properties, my List three returns empty. Removing the fields (Address, Hotels/Id) from "Extra Fields" and the field (Hotels) from "Expand" allows my three cascading lookup control to properly function.

Can you help me sort this out? I have ready through multiple sets of instructions on this site as well as several other posts that I thought might be helpful, but I just don't understand exactly how all of this ties together yet.

Thanks, Rhonda

Hello @rhonda,

Welcome to Plumsail Community!

You need to know the type and internal names of the columns in the source list to properly use Expand and Extra fields property.

What is the type of the Hotel and Address columns? You can share the screenshot of the source list and the column settings if you are not sure.

Hi @mnikitina,
Both of these fields are "single line text". I have the internal names.

Thanks for your help, Rhonda


For Single Line text fields, you need to specify the internal names of the columns only in Extra Fields property, like so:

Hi @mnikitina,
I tried your suggestion above. I even removed Hotels, but the Address is not being displayed. Do you have other suggetions?

Thanks, Rhonda


Do you see any errors in the browser console (CTRL + SHIFT + J)?
Please share the screenshot,

No errors. Any other ideas?


Does the cascading drop downs work? Do you see options in the last drop-down?

What do you mean by 'being displayed'? If you want to display the extra column value, you must use the code.
For instance, if you want it to be displayed somewhere on the form, you need to add this code to the form:

fd.field('Hotels').$on('change', function(value){
           //populate Address field with the Extra field value
            fd.field('Address').value = fd.field('Hotels').value. Address;

The last drop-down works in the New and Display, but NOT the Edit. I just noticed this today.

By "not displayed", I want something like the display on this page ( Customize appearance for lookup fields in a SharePoint form — SharePoint forms (plumsail.com)

I want to show the street address of the Hotel in the same "box" as the Hotel Name. The Address field is in the same list as the Hotel Name field.

Thanks! Rhonda

Have you added Address field to the Extra field property only on the Edit form? Please share the screenshot of the form and the errors in the browser console.

For this you need to use the code as described in the View configuration section. But first we need to make sure that the extra field is loaded for the Hotels field.

I got the New, Edit, and Display forms to work with the cascading drop-downs finally. I did add "Address" as an "Extra Field" in the "Hotel Name" drop-down. However, I am not seeing the Address displayed with the Hotel Name in the drop-down box on the form.

I have attached several screenshots: the definition of "Hotel Name" field, my json from the "New" form, my CSS from the "New" form, and a capture of the design of the "New Form" with the properties of the "Hotel Name" field displayed. I ONLY have "Address" in the "Extra Fields" property. There is nothing in the "Expand" field.

I appreciate your time and assistance with getting this to work. I am still on our trial license, so very new, but trying to prove the concept in order to purchase.

Thanks, Rhonda
20230823ExtraFields.pdf (986.1 KB)


You use the invalid field name in the code:

The name must be without spaces:

Please update the code and test the form. If it won't work, please share screenshot of messages in the browser console and send the code as the text.


I have to move some Forms from old SP-Forms (plumsails-lookup) to Plumsails-Forms for Sharepoint and have some problems with extra fields.

I have two lookup-fields "Fachgebiet" and "Berater".

The value/ID of Fachgebiet is used as filter for Berater. Filterterm in Javascript is like this:


Aditionally I have to filter the field Berater by the value of a boolean-field in the list Berater called "aktiv". Therefore I use the extra-fields of lookup on Berater.


Is that correct and how can I pass the value of aktiv to javascript and use it in the filter-term? How would the filter-term look like?

Thank you for your support UDRO

Hello @UDRO,

Yes, these are correct settings. If you want to filter the lookup values by two values you need to use this code:

//active is true
//doublecheck the internal names of the fields
fd.field('Berater').filter = 'Fachgebiet/Id eq ' + FG + ' and aktiv eq 1';

I have updated the code that you sent with the proper field name. It is still not working. The only messages are :

  1. downloadable font: download failed (font-family: "FabrricMDL2Icons"....... I didn't expect this to work. I am working on a closed network.

  2. POST: https://sitename/_layouts/15/wsapUpload.ashx (403 Error Code)

I have tried a lot of different options trying to get this to work. Can you help me understand the following?

  1. In the JS, in spBeforeRender, when forming the template, what is the data.LookupValue supposed to represent, or is it just as shown?
  2. In the JS, what is the data.Address pointing to? The lookup field name(HotelName), the Extra Fields(in HotelName), or the original list that Address comes from (Hotels).
  3. In the JS, I have fd.control('HotelName').widgetOptions...... is that correct?
  4. Where in the JS should the below be placed? spBeforeRender, spRendered (before or after the call to populateFields), or in the function populateFields?
    fd.field('Hotels').$on('change', function(value){
    //populate Address field with the Extra field value
    fd.field('Address').value = fd.field('Hotels').value. Address;
  5. In the code in #4, 'Hotels' is the name of my list which does contain the field Address. The field on my Form HotelName is a lookup to the list Hotels. Is the above correct?
  6. For the Address field on my form, does listing "Address" in the Extra Fields of HotelName satisfy the requirement to have the field on the form?
  7. When I add any values other than "Address" in the Extra Fields property of the HotelName field on my form, the drop-down values in HotelName do not populate.
  8. If I add any values at all to Expand, the HotelName field on my form, the drop-down values in HotelName do not populate.

Thank you for your time, Rhonda

Just as a reminder.... I am using SharePoint 2019 On-Premise.

20230829Errors.pdf (674.3 KB)

Attached are the browser errors.


From the error messages I can tell that the Address is a valid column name, but the Hotels HotelName are invalid column names. Please share the screenshot of the source list and teh screenshot of the column properties with the page URL like so:

Lookup value includes the ID of the selected title and the display text that user sees in teh drop down. data.LookupValue is a display text of the selected option.

It is the value of the Extra column.

Yes, this is how you change the field template. See the example.

This code must be inside the spRendered() function. Outside of the populateFields() function. Just noticed that the syntax in the populateFields() function is invalid. Please share teh code as a plain text so I could fix it for you.

You must use the internal names of the fields in the code:

No, when you add a column name to teh Extra fields you just pull the data from the list. If you want it to be displayed on teh form, you can add a common text field and populate it using the code you've shared:

fd.field('Hotels').$on('change', function(value){
//populate Address field with the Extra field value
fd.field('Address').value = fd.field('Hotels').value. Address;

You must enter the valid column name. Please share the screenshot of the columns settings that you want to list in Extra fields with the page URL to identify its valid internal name.

You add invalid value.

Would it be better to email you the screenshots as attachments? If so, can you provide your email address?

Hi .... I decided to go ahead and post the requested screenshots here. Thank you in advance for your assistance. Rhonda
20230830ExtraFields.pdf (1.1 MB)