• Published

    • Submissions (Form Builder): Key Relationships

    Owned by Harshula Jhala, created
    Last updated: Nov 27, 2023 by Wilmarié Moreland
    2 min read

    This page covers:

    Related pages:

    Submissions: Overview

    Submissions are a feature in Amp Impact that allows users to create a form template with different types of questions (long text, picklist, etc.), which can be used on any object. These forms can then be assigned manually or automatically to other users to fill out and submit. Responses are stored in the system and can be reviewed and assigned a score if needed.

    Submissions: Data Model

    Below is the Submissions data model subset:

    Submissions: Summary of Key Relationships

    There are three key relationships that are foundational to Submissions:

    • Submission: This relationship allows organizations to store templates and responses for submissions/assessments in Amp Impact.

    • Section: This relationship allows organizations to capture the sections/categories in a Submission template or response.

    • Question: This relationship allows organizations to store the template Section and Questions of a Submission template, as well as the Question and Answers of a Submission response.

    Here is a summary of these relationships:

    Amp Object Label

    Amp Object API name

    Object Description

    Sample Use

    Also Sometimes Called

    Key relationships (Amp object's relationship in parentheses)

    Sometimes connects to

    Amp Object Label

    Amp Object API name

    Object Description

    Sample Use

    Also Sometimes Called

    Key relationships (Amp object's relationship in parentheses)

    Sometimes connects to

    Submission

    ampi__Submission__c

    The Submission object holds two types of records: 1) Templates of questionnaires/assessments and 2) Responses to those questionnaires/assessments once they have been filled out and saved. A Submission template record is created and then Sections and Questions (records on different objects) are created to fill out the structure of the Submission. Submission templates can be related to any custom and/or standard object depending on use case.

    Hello Hygiene is accepting proposals for funding for hygiene promotion projects. A grants manager at Hello Hygiene creates a Submission template with sections and questions that applicants will fill out as part of the proposal process. When an applicant fills out a submission, a Response record is created in the system with the applicant's responses for the grants manager to review.

    Proposal, Form, Report

    Question (parent)
    Response (parent)

    Project
    Concept Note
    Reporting Period
    Risk Assessment

    Section

    ampi__Section__c

    Section holds details of the different sections within a Submission template.

    Hello Hygiene's proposal form for applicants has questions organized into several sections, such as Applicant Information, Project Details, and Proposed Budget

     

    Submission (child in lookup)
    Question (parent)

     

    Question

    ampi__Question__c

    The Question object holds questions (and answers) for each of the questions added to a Submission template. Questions can be different types, including Short Text, Qualitative, Picklist, Number, Multi-Select Picklist, and Date.

    In Hello Hygiene's proposal template, some of the Questions are:

    1. Organization Name (Short Text)

    2. Organization Type (Picklist)

    3. Project Start Date (Date)

     

    Submission (child in lookup)
    Question (child in lookup)