Senpiper
  • Introduction to Senpiper One Resource
  • Getting started
    • Overview
    • Log in to the platform
    • Web workspace
    • Mobile Applications
    • White-labeled Apps and custom domains
  • Groups/Applications
    • Groups Overview
    • How to create groups?
    • Open vs Closed groups
    • Managing group members
      • Types of group members
      • Manual Group member management
        • Adding users individually
        • Adding users in bulk
        • Removing users
      • Automated user management
        • How to define criteria for adding users?
        • How to auto-remove users?
        • User Removal Alerts and Task Delegation
    • Group Details on web
      • Form Table View
      • Kanban View
      • Group chats
      • Pending task (assigned to you)
        • How to access the tasks assigned to you?
        • How to take actions on the tasks assigned to you?
        • How to toggle between different views?
    • Group Details on Mobile Apps
      • Managing Group Views
      • Group Chat Features
      • Form Submissions
        • Form card settings
      • Media Directory
        • How to create Media folder ?
        • How to upload media ?
        • How to delete Media ?
      • Pending Tasks
      • Group Settings
  • Media folders
    • Overview
    • How to access the Media Folders?
    • How to create media folders?
    • How to upload media files in folders?
    • How to delete media folders and files?
  • Scheduler
    • Overview
  • HOW TO CREATE APPLICATIONS
    • Overview
    • Tools to create an application
  • USER MANAGEMENT
    • Introduction
    • Managing users
      • User lists
        • How to create user lists?
        • How to create users?
        • How to add custom user list parameters?
      • How to add users to a user list?
        • Adding multiple users to a user list
      • More actions
        • Viewing users
        • Searching users
        • Downloading user lists
        • Delegating tasks
        • Viewing the change log of a user profile
        • Editing users
        • Deleting users
        • Blocking users
        • Unblocking users
        • Unlocking user
        • Granting permissions to users
    • Managing custom roles
      • Creating roles
      • Assigning custom roles to users
      • Removing custom roles from users
      • Granting permissions to roles
    • Roles and Users for the Reimbursement Use Case
  • FORM BUILDER
    • Introduction
    • How to create forms?
      • Basic details
      • Adding fields and saving a form
        • Types of fields
        • Default field settings
        • Individual field settings
        • Creating master records
        • Language settings for fields
      • Additional form settings
        • Conditions
          • Manage field settings
          • Copy field values
          • Conditional values of fields
            • Master Mapping
          • Validate field values
          • Calculate field values
          • Validate location
          • Face Matching
          • Append values to a field
        • Submit button settings
        • Configure pre loader
        • Configure post loader
        • Set form card layout
        • Set form table properties
    • Advanced concepts
      • Parent-child form settings
      • Using report data in forms
    • Editing forms
    • Deleting forms
    • More form options
  • WORKFLOW BUILDER
    • Introduction
      • Overview
      • Navigating workflow builder
      • How to add a new workflow?
      • How to view draft workflows?
    • Defining workflows
      • Define conditions for a workflow step
      • Define Workflow Actions
        • Configuring communication settings
        • Configuring a conditional assignee
        • Selecting an assignment strategy
      • Define workflow Step
        • Updating the status for a step of the workflow
        • Configuring button settings for a step of the workflow
          • Basic details
          • Form edit settings
          • Assignment settings
          • Comment log settings
          • Auto trigger settings
          • Time settings
      • Ending workflow
    • Editing workflows
    • Deleting workflows
    • Designing the reimbursement workflow (Path 1)
    • Designing the reimbursement workflow (Path 2)
  • ALARM BUILDER
    • Introduction
    • Alerts for form submission
      • Add New Alarm
        • Configuring the basic details
        • Defining the communication type
          • Send an Email
          • Send an SMS
          • Send an App Notification
        • Setting up the schedule for alerts
      • Viewing alarm event details
      • Editing an existing alarm
      • Deleting an existing alarm
    • Alarms for Custom Data Exports
      • Add a new alarm
        • Configuring Basic Details
        • Configure Content
        • Define Schedule
      • View Alarm event details
      • Clone a Alarm
  • General System Settings
    • Introduction
    • Authentication settings
      • Login option Preferences
      • Password settings
      • Custom URLs
    • Organization Branding
    • Custom Settings
    • Enable Sign-Up
      • Build a Sign-up form
      • Settings for Sign-up form
      • Customize Sign-up form
  • DIGITIZE A SAMPLE PROCESS
    • Overview of the process
    • Step 1: Register a company
    • Step 2: Create a group/Application
    • Step 3 : Design forms
    • Step 3: Create Process flow
    • Step 4 : Set up the communication
    • Testing the platform
  • Process migration
    • Introduction
  • Different types
  • Steps for migrating any process
Powered by GitBook
On this page
  • What is the purpose of a master database?
  • Give me an example of where a master database can be used.
  • What type of master databases does this platform offer?
  • How can I make any form a master database?
  • How can I link a master database to a form?
  • How can I map master database fields to the fields of another form?
  • Are there any restrictions in master database field mappings?
  • I need to use master database records while filling a form; how can I do that?
  • Can I apply a different master database from the one chosen in Basic details of the form?

Was this helpful?

  1. FORM BUILDER
  2. How to create forms?
  3. Adding fields and saving a form

Creating master records

PreviousIndividual field settingsNextLanguage settings for fields

Last updated 2 years ago

Was this helpful?

Master records act as a database, the data entries from which can be used to populate certain fields in other forms, provided the master form is linked with those forms.

For example, let's say we have a form called Item Master with a textbox field Item name which captures the names of the items that can be used for reimbursement. We have another form, Reimbursement Form that also has a textbox field Name of the item which captures the names of the items for which the users are seeking reimbursement.

In this case, we can set Item Master as a Master database to the Reimbursement form and link the Name of the item field of Reimbursement form with the Item name field of Item Master.

What is the purpose of a master database?

The user can create a form and choose its submissions to be saved as a master database. This database can be used to create submissions of other forms.

Give me an example of where a master database can be used.

  1. Create a form Item Master and mark it as a master form.

  2. Create another form Reimbursement form and mark the Item Master as a master form to it.

Check about how to create Item Master form and use its master database for Reimbursement form.

What type of master databases does this platform offer?

  1. Using Form Submissions: The user creates a master form and can use its submissions as a master database like in the example given above.

  2. Using Mange Users data: The user can create user lists using Manage Users feature. The user list data is stored as a master database which can be used further in the similar way as explained in the above example.

How can I make any form a master database?

While creating forms, the user can mark a form as a master form under Basic details.

Once this toggle is on, the form submissions created will be categorized as a master database.

It is important to note that a form can be made a master form only while creating a new form. Once the form is created and saved successfully, the master toggle will be disabled in edit mode.

How can I link a master database to a form?

  1. The user clicks on the Apply master data settings in the Basic details tab of the form builder.

  2. Switch on the toggle Apply master data to this form.

  3. Select the form whose submissions should be used as a master database for this form.

In the below image, Item form is being used as a master database.

How can I map master database fields to the fields of another form?

  1. The user can click on the settings icon next to the field created to see Master data settings tab.

3. Under Master data settings tab the user will see the selected master form fields in the drop down and the user can select the desired master form field whose value is to be populated into the form field under consideration.

Are there any restrictions in master database field mappings?

Yes. The form fields can be mapped only when their datatype is same. When we say datatype, it means the field we are talking about is an email type field or a date type field or a textfield and like that.

The user can map similar datatype fields. to simplify that please refer the below table:

Form field for which master database is to be used
Master database form field

Textfield

Textbox Select Email Phone Radio

Number

Number Slider Rating

Phone

Phone

Email

Email Textfield Select

Location

Location

Geolocation

Geolocation

Richtext

Richtext

Date

Date

Radio

Radio

Slider

Slider

Rating

Rating

Image

Image

Document

Document

Video

Video

Audio

Audio

Canvas

Canvas

QR code

QR code

Bar code

Bar code

I need to use master database records while filling a form; how can I do that?

To answer this, first we need to understand how master database is working to fill in some other form fields values. Let's get back to our example of Item master form. In the Item master form we add three submissions; with values in "Item Name" field as "Milk", "Coffee" and "Sugar"

Submission Number
Value in the field "Item Name"
Value in "Unit Price"

Submission 1

Milk

100

Submission 2

Coffee

200

Submission3

Sugar

300

Now, user wants to search the master records by values present in "Item Name" while filling the reimbursement form.

E.g. User can search the master database for "Milk" and "Unit price" of "100" is auto-populated in the reimbursement form if mapped. Learn about master field mapping above

To do this, we map Item name with Name of the item field of Reimbursement form and switch on the toggle Allow users to search and populate master values from this field.

While creating the submissions of Reimbursement form, the user will see a text in the input box of the form field for which this toggle is on, which will indicate that this form field is being used to search through the master database.

When the user adds a new submission for the "reimbursement form" they will be able to search the "item master" records through the field "Name of the Item" as shown below. Choosing any one of them will populate all other mapped fields of the Reimbursement form accordingly.

If Milk is chosen then all the mapped fields e.g. "Unit Price" will be auto populated with the corresponding values from the Item master

Can I apply a different master database from the one chosen in Basic details of the form?

Once the master data to be applied for the form is selected as explained , the user will have to provide a mapping to let the system know which master data field should populate which current form field.

While mapping the using textfield or select field, the user will have to ensure that the textfield/select field submissions in the Master form have @ in their values else textfield/select field value populated in email field via field mapping ( ) will result in a failed form submission.

Let's learn to create a master form step by step using the link.

Yes. A separate master can be chosen for the select field. In the select type field, the value can be populated via a different database (be it a ).

The mapping of the select field will be as per the datatype supported as discussed.

details here
here
above
form or user list
above
Email field
Email type field inherent validation