Using a Linked List
Sintel Forms allows using one or more linked lists within a form. This functionality is similar to the repeating table available in the InfoPath with the difference that Sintel Forms stores such data as individual list items in a linked SharePoint list.
Steps to create a form containing a linked list.
- Create the main list
This will be the list storing the form data, in our example, it will be called “Requests”
- Create a linked sublist
This list will allow adding child items into the form, in our example, we will call it “Request Details”
- Create a lookup column
This lookup column must be created in the linked sublist (“Request Details”) and it will look up the main list (“Request”) in our example we will call it “RelatedRequest”.
- Place the linked list on the form
Once the linked sublist is created and it contains the Lookup column you can launch the Sintel Forms Designer on the main list. The “RequestDetails” linked sublist will appear in the List Fields section. Drag the RequestDetails and drop it into a section. In the example below RequestDetails will be dropped into the “Curricula Changes” section.
- Configure Linked List columns
After the RequestDetails is placed inside a section, click it in the designer area to open its properties. You can now show/hide columns, change column width and adjust other properties.
Every new column which is added to the linked list placed on the layout is hidden by default so after modification, you should navigate to the Linked List properties and turn the flag ‘Visible’ on.
- Save and Exit: now you can enjoy adding related items.
When using linked lists or libraries standard SharePoint permissions apply i.e. you must ensure your users have contribute permissions on any linked list or library to ensure they can add items into those linked lists from the main form. Forms submitted by external users are an exception to this, for these forms you don’t need to grant access to any lists to enable external users to submit forms.