How to setup a Multi-Select Widget

Many-to-many relationships are those where multiple records in one table are related to multiple records in another table (e.g., tasks assigned to a project or students in a class). TrackVia recommends using Join Tables to create these relationships. The Multi-Select Widget provides a more efficient way to add records to Join Tables in TrackVia. 

In this example we have a Projects table (parent table), a Tasks table (parent table), and a Project Tasks (join table that is a child to both the Projects and Tasks tables). 

To use the Multi-Select Widget edit a form used to add records to a Join Table.  Then under the "Available Fields & Widgets" section on the left, click on the "Widgets" tab, then click the "Multi-Select" option and drag and drop it onto the form .

Adding the Multi-Select Widget will open the Multi-Select Settings window.

In Part 1 (Where do you want to store this selection?), select the name of the relationship between the Parent Table (the table associated with the Form) and the Child Table (the Join Table). This tells TrackVia which child table to store the new records in. Then select the Child View that you would like the records to be displayed within the Multi-Select Field. This will impact user permissions, allowing flexibility and control of how users will see the records.

In Part 2 (What do you want to select?), select the other associated Parent Table to the Child Table (Join Table). This will contain the records your users select when using the Multi-Select Widget. Select a Preferred Parent View to filter the records your users can see, or select the default parent view for unfiltered results.

When adding new records using this form, select one or many records using the Multi-Select Widget.

Save the form, and multiple records will be automatically added to the Child (Join) Table.

The Multi-Select Widget can be used to add records to any Child Join Table and will save users tons of time!