Page 1 of 1

Display Lookup Fields

Posted: 19 Jul 2016
by kb2020
I have a lookup field , and selected "Add a column to show each of these additional fields" whereby 6 additional columns were selected. However the data for these columns are not shown in form when designed with form designer. How can this be fixed ?

Re: Display Lookup Fields

Posted: 20 Jul 2016
by Dmitry Kozlov
Hi,

Most likely, you need to add the additional fields into the target content type. Navigate to the List Settings -> select the content type and click "Add from existing site or list columns" link under the list of columns.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by kb2020
Hi, the fields are not available there. How is this normally done ? I have two list, one that was designed by form designer and another which is used to lookup companies. I created a lookup column for the company name, and also selected additional columns under "

Add a column to show each of these additional fields: "

Re: Display Lookup Fields

Posted: 20 Jul 2016
by Dmitry Kozlov
Then navigate to the content type settings, remove the lookup field from the content type and then add it again. It will be added with all additional fields.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by kb2020
I tried everything, still no luck with this at all.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by Dmitry Kozlov
Are you sure that the content type, the form of which you're editing, is listed in the list of content types next to additional fields:

Image

After re-adding the lookup column to the content type, restart Forms Designer. The additional fields will appear on the left side, in the list of available fields.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by kb2020
Hi, Yes I am sure. The problem is when I drag those fields to the form designer and save. When the form is opened, only the lookup value is shown, Lookup:Quantity etc etc is not shown. it is just blank.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by Dmitry Kozlov
Please, note that the additional fields are read-only. You cannot use them on a new form. As for edit forms, they will change after saving only.

Re: Display Lookup Fields

Posted: 20 Jul 2016
by kb2020
Ok I didnt want to edit those fields, it is purely for reference purposes, for example if I had an invoice number field, when invoice number is selected the associated details are shown instantly, so there is no ambiguity. But i understand what is possible now. Thanks.