Multi-record tables are used when your organization needs to track history or many instances of the same thing, such as background checks, trainings, accounts receivable or progress reports.
This guide talks about:
- Multi-record Tables and their Current/Latest Records
- Multi-record Forms
- Prefill from Last
- Prefill Groups
Multi-record Tables
In order to create a new Multi-record Form, you'll first need a Multi-record Table. There are many available in SAM. They can be identified under Tables & Fields, shown without a tilde (~).
Create new Multi-record Table
In SAM, click Settings > Tables and Fields > Advanced Options > Create New Table > select the parent table for the table you want to create > Name the new table > check Has Multiple Records Per Parent Table > Save SAM will take you to the Table Properties screen. Modification and audit fields will be present. |
Current/Latest Record
This function displays the most recent record for a Multi-record table. It creates a sibling table of the Multi-record Table.
Enable a Current / Latest Record
In SAM, click Settings > Tables & Fields > select desired table (Multi-record table) > click Advanced Options (sidebar) > Really Advanced Options > Setup Sibling-Table for Current/Latest Record > enter your Sorting and Criteria settings to denote the latest record over other records > Save SAM will direct you to the Current/Latest table. |
Current/Latest Table View
Edit Current/Latest Record Settings
In SAM, click Settings > Tables & Fields > select desired Current/Latest table > click Current/Latest Record Settings link (bottom of Warning message) |
Disable Current/Latest Table
In SAM, click Settings > Tables & Fields > select desired table (Multi-record table) > click Advanced Options (sidebar) > Really Advanced Options > Disable table > click Ok |
Multi-record Forms
Forms based on Multi-record Tables can be built to show many records or one record at a time.
Multi-record Standard Form Setup
This is the simplest way to build Multi-record Forms. This setup is composed of three forms and the connections between them.
- Container form (view sub-form on it)
- View sub-form (titled Overview)
- Add / Edit / Details form (to add, edit, or view one record)
In SAM, click Settings > Tables & Fields > select desired Table to base form from > click Advanced Options (sidebar) > Really Advanced Options > Multi-record Standard Forms Setup > enter Form Name(s) > select Mirror Overview and Details Forms > set Link to this Form > Save SAM will present the Add/Edit/Details form to modify the form. |
Setup Options
- Forms Base Name - name your new form(s). Typically, this will be the table name for convenience.
- Mirror Overview and Details Forms - copies fields on the Add/Edit form to the Overview forms. Great for a quick setup. Forms can be unlinked later.
- Link to this form - select another form to link this form from. If left empty, no sidebar link will be created.
Unlink Multi-record Forms
At the top of Form Customizer screens for linked forms, SAM will show links to the other forms created during this setup. When you access the linked Overview form, an option to unlink the two forms is available.
Build individual forms based on Multi-record Tables
In SAM, click Settings > Tables and Fields > select desired Multi-record Table to base form on > click Advanced Options (sidebar) > Create New form > enter Title of form > select Form Type > select form layout option desired > set other form options > Save SAM will open to Form Customizer to modify form. |
Multi-record Form Types
- 1-at-a-time - allows entry or visibility of one record at a time
- Multi-record (sub-form) - allows entry or visibility of many records
Form Layout Options
- View / Edit / Both
- Vertical / Horizontal layout
Sub-form Options
- Hide if empty - shows sub-form when records have been entered. Hides the form when no records are entered. Requires records to be entered through another form or Auto Action.
- Create Container Form - All sub-forms must be on another Container/Main Form.
- Yes, if you're creating a multi-record view sub-form to be used as a sidebar link
- No, If you'll be adding this sub-form to another form.
Form Stats
Like report stats, form stats allow you to quickly sort and filter entries on a multi record form by field criteria. You can enable form stats via Form Customizer, or from any multi record form.
Add Form Stats
In SAM, open a Multi-record form from a record > click Advanced Options (sidebar) > Enable Form Stats > click Form Stat icon > click Add Form Stat hyperlink > setup stat as desired > Save To view Stat, click Form Stat icon. |
Clicking on a stat value will immediately filter the multi record form entries by that criteria.
Prefill Form from Last
This function allows users to update fields for a new record from the last record entered.
This feature is helpful in situations where the current record is nearly identical to the last record entered, so users can save time completing the form. Example: Progress Reports where a client's progress may not change much from one month to the next.
Notes
- Only works for multi-record tables.
- Prefill from Last link only present on Add or Edit Form types.
- Form sorting must be set using 'Sort Form By' field.
- On setup, future records will be prefilled from the previous record when Prefill from Last is clicked.
- All fields on the form are prefilled.
Enable Prefill
In SAM, Open Form Customizer from the Add/Edit Form for the form > click Advanced Options (sidebar) > Really Advanced Options > Form Fields Prefill Settings > check enable Form Fields Prefill > enter how the forms are sorted > Save Prefill Form Fields from Last Form (link at the top right of Add/Edit Forms) will show. |
Once the link is clicked, SAM will fill the current record from the previous record. A message will let you know that the record has been prefilled.
If you create a new record > enter data into it > save it > Reopen the record > click the Prefill link, SAM will only prefill the fields that do not already have some data entered. Once a form has been set to Prefill from the Last Record, all future records will be prefilled from the last.
Prefill Groups
SAM's Prefill Groups function adds a group of sub-records, like Accounts Receivable (AR) or Parent Education, under a Main Entity/Record. This is helpful to have SAM enter required records based on your processes.
Prefill Groups can be added manually or triggered using Auto Actions.
Prefill Groups require a List Field type on a Multi-record table and only enter that field when the Prefill Group is applied. If you want more data entry for a record, a series of Auto Actions is a better option.
Examples
- Country/Program Specific Fees from A/R Records
- Benefit Types common for Birth Mother Services/Benefits
- Parent Education Requirements
- Groups of Documents (Document Checklists are Prefill Groups under a separate naming convention because everyone deals with Documents)
Enable Prefill Group
In SAM, open the form to add the Prefill Group to > click Advanced Options (sidebar) > click Enable Prefill Group for Table Name > name the Prefill Group > select List the Prefill Group will pull from > Save > enter a name for a Group within the Prefill Group (multiple groups can exist within a Prefill Group) > Add an item to the Group > Save
|
Create a New Prefill Group
In SAM, click Setting > Prefill Group > select a Group Type > click Add New Group (sidebar) > name the Group > choose Items (drop down) > Save Add additional items as needed. |
Edit Prefill Group Items
In SAM, click Settings > Prefill Groups > select Prefill Group to edit > select Group within the Prefill Group to edit > SAM will direct you to the Edit Group screen |
Add Item to Group
In SAM, click Settings > Prefill Groups > select Prefill Group to edit > select Group within the Prefill Group to edit > click Add Item to Group (sidebar) > select the Item to add > Save |
Edit Group Name
Changes the Name of the Group within the Prefill Group.
In SAM, click Settings > Prefill Groups > select Prefill Group to edit > select Group within the Prefill Group to edit > click Edit List > rename the Group > Save |
Edit List
This allows you to manage the list the Prefill Group is based on.
In SAM, click Settings > Prefill Groups > select Prefill Group to edit > select Group within the Prefill Group to edit > click Edit Group Name > use sidebar to add, edit, delete list items |
Delete Prefill Group
In SAM, click Settings > Prefill Groups > select Prefill Group to edit > select Group within the Prefill Group to edit > click Advanced Options (sidebar) > Delete Group > confirm pop-up message > SAM will direct back to Prefill Group |
NOTE: Prefill Groups cannot be disabled once created, but the groups within the Prefill Group can.
Manually add a Prefill Group
In SAM, Open the Record/Main Entity > Open the form where the Prefill Group exists > select Group to apply from available Groups > Confirm the selection Records will be added for each item in the Group. |
________________________________________________________________________________________________________________
Multi-record Table Advanced Setups (For SAM Support Team ONLY)
This is for more complex setups. SAM's support team will assist with these setups if needed on requests.
Sibling-Table Setup for Refed List-Table
This function allows Big-Search-List fields linked to another Main Entity to include details from the Main Entity's table under another table.
Examples in SAM Case Worker - Person fields available on templates based on the Family table Add the Persons table fields to Family - References, to add new Person records
Instructions
- Begin by accessing the form or field that you want. This will only work with fields that are connected to Parent Entities. Example, Case Worker > Person Record or Placing Agency/County > Organization Record.
- Open the field, then click Advanced Options.
- Click Sibling-Table Setup for Refed List-Table once. Click Ok, Close on the pop-up and the table associated with the field will be available for reports and templates to pull the details.
You can see this table added to the hierarchy from Reports.
Special Connections
Instructions
- Create New Table under one of the Entities
- Create a Field on the Table for the other Entity
- From the Table, click Advanced Options > Really Advanced Options > Linkup to Another Parent Table by Field
- Select the field you just created from the options
- Build forms from each entity's side
Multi-Record Grouping by Field (like Child Sibling Groups)
Record Grouping means that when you add a Multi-Record record which references a Main Record, the record will appear under both of them, just like the "Child Sibling Groups", which link up all the Children together and show all of them on each others forms. (Meaning it doesn't matter whose form the records are entered from.)
This is only for advanced users to setup/enable.
This is enabled by setting the "Advanced | Record Grouping Field" property on the Multi-Record Table. The Field must reference the same Main Entity Type as the Parent-Table, such as the "Organization" or "Child". Only for Multi-Record tables.
For example, to setup a "Branches" Multi-Record table under Organization that links all the Organizations together. Create the Multi-Record table and add a field "Branch" which is a Big-Search List of "Organization", then go to the Advanced Table Properties and set the "Advanced | Record Grouping Field" to use the "Branch" field.
Linking Entity Types with a Shared Multi-Record Table
You can create a shared Multi-Record Table, similar to Adoption or Placement Records, where multiple main entity types are linked together, like Family and Child.
To do this:
- Create the Multi-Record table under the first Main Entity Type.
- Copy the table to the Parent table that you want to connect. (From the Table Properties form > Advanced Option > Copy to Another Table)
- Create a Big-Search List (or Drop-Down List) field for each Main Entity Type, so you can link the records together.
- Open Field Properties for each Big Search List Field you just created > Advanced Options > Change the DB Column name to the Main Entity Type ID.
SAM's Support Team is needed to modify the DB Column name.
Create Under Case
If you want to organize the records per Case and also under the Main Entity Type, a table can be copied under the Case Table.
In SAM, click Settings > Tables and Fields > select desired table under Main Entity > click Advanced Options (sidebar) > Really Advanced Options > under Developer Only Options, click Copy under Another Parent Table > select other Parent table > click Confirm
Change the Table Title to have a postfix like 'per Case' for ease in identifying the table later. Copy Sub-Tables is available when you want to carry over tables under the copied table to the new parent table. |
Adding records per Case
When you setup the forms, choose the table under the Case table ( which is why its important to name these copies with " per Case" at the end). This will make it so that when you add new records they will be for the case that you are currently viewing.
When you are selecting the second Main Entity Type (via the Big-Search List Field), then it will automatically link that record to their latest case. (The Details forms for Multi-Records under the Case have a special option in the Advanced Options to move them to another Case for the same Main Entity, so you could always move the records to other cases.)
These additional steps for adding records per Case are necessary because the Big-Search List field links to a Main Entity, and not their cases. By having the multi-record table copied under the Case table too, then SAM automatically links the latest Case for the Main Entity selected in the Big-Search List Field.
(This is a default feature for all multi-record tables copied under the same Main Entity Type, so if you have a table like "Incidents" under Placements and copied under the Child, then it will automatically link to the latest Placement record, even if its added through a form based on the Child, and vice-versa, so you could see all the "Incidents" for a Child on one form without having to include the "Placements" table on the form.)
_______________________________________
This default feature applies to all multi-record tables copied under the same Main Entity Type. For example, if you have a table like "Incidents" under Placements and copied under the Child, it will automatically link to the latest Placement record. Consequently, you can view all incidents for a Child on one form without needing to include the "Placements" table.
Comments
0 comments
Article is closed for comments.