Contents
One way to work out the site column ID is to go to the setting of a content type where the site column is being used. Hover over the site column and the ID is shown in the URL as below. Going to the site column gallery won’t work as that will just give you the internal name of the site column/field.
How do you create a look up?
Create a lookup field in Design View
- Open the table in Design View.
- In the first available empty row, click a cell in the Field Name column, and then type a field name for the lookup field.
- Click in the Data Type column for that row, click the arrow and then, in the drop-down list, select Lookup Wizard.
How to get InfoPath to display the lookup column value?
So, how can you get InfoPath to display the lookup column value? One way is to add a data connection to the list (or lists) containing the lookup values and change the repeating table field controls from text boxes to calculated fields. Here are the steps: Create data connections to the lists containing the lookup values
How to add new fields to InfoPath form?
Choose “Mandatory” option. Click the “OK” button to save the changes. Right-click and add a row to InfoPath form. Drag and Drop the new field Product Code from the fields list to the form. Now the new field and control is missing data-population.
How to add a calculated column to a form?
Following are main steps: 1) Add new receive data connection. 2) Select List from which you want to fetch data. 3) Select all additional fields you want to be displayed on form. 4) Insert a calculated column on form. 5)Click on Advanced View for this field. 6) Select new data connection from dropdown. 7) Expand dataFields.
Where do I find the lookup fields in SharePoint?
Choose your SharePoint site as shown below. Choose the Lookup List. (the secondary list from where data is pulled). Choose the fields to display. (In our case only Code field exists.)