You create a table with all students who attend music class and what instrument they choose. Users could play one or more instruments, and some users could play the same instrument. So, here’s a "Many to Many” relationship between users and possible musical instruments.
STEP 1: Create an InForm table
- From “My IntelliBoard”, go to Apps > InForm.
- Click “Add Table”.
- Under Table General Info, enter Table Title as “Music Class”.
- Choose “Everyone Can Manage an Entry” option from “Entries Managing Mode”.
- Under Table Columns enter the column name as “Instrument”, and select the type as “Enum” (because we may have only some instruments and want them to be shown as a drop-down in our future form). Click “Save” to add the column to the table.
- Under Table Relations select ‘Many to Many’ options because we want to be able to assign one music instrument to several users per time.
- Relate this to the ‘Users’ table, as we need to assign instruments to students.
- Select Full Name to show as we should know whom we assign the instrument in future form.
- Click “Add”.
- Click “Save”.
STEP 2: Create InForm Form for adding new data.
- From “My IntelliBoard”, go to Create New > Create InForm.
- Enter the Form Name as “Music Class Entering Form”.
- On the right-hand side, choose the “Music Class” table.
- Drag-and-drop column and relation to the middle block.
- Click on the “Instrument” column.
- On the left-hand side, make this “Required”.
- Add some options that will be shown in a drop-down. For this, enter the option name and click the “+” icon.
- From the left side box, click “Save” for saving column options.
- Click “Save” in the middle block for saving the whole form.
STEP 3: Add Master Form to the table
- From “My IntelliBoard”, go to Apps > InForm.
- Find “Music Class” table. Click 3 dots under Actions, and select Edit.
- Under Table General Info, select “Music Class Entering Form” for the “Master Form” setting. Select Instrument under Name Column.
- Click “Save” at the very bottom of the page.
STEP 4: Add new and edit entered data
- From “My IntelliBoard” scroll down to InForm and find “Music Class Entering Form”
- Enter some data by selecting an instrument from the first drop-down, and then choosing user(s) from the second drop-down.
Note: You could select several users per time for assignation because we have selected “Many to Many” relation. - Click “Save” to add a record.
- In case you wish to add more users to some existing record or remove some records, you could edit the entered data. For this, from “My IntelliBoard”, go to Apps > InForm.
- Find “Music Class” table. Click on the 3 dots from Actions, and select Show.
- For the required record, click 3 dots from Actions and select Edit.
- You will be directed to the form (Master Form you’ve added before) where you could add more users or remove some from those already added.
- Make changes, and click “Save” for the record.
For additional assistance, please email helpdesk@IntelliBoard.net