Practical Application of Public Links in Different Query Scenarios
Introduction
When using Jodoo, businesses often need to publish forms for external members to query information. For example, in the education industry, external members, like students and parents, often need to check scores, evaluations and other relevant information.
Jodoo provides Public Query Link and Form Fill Link to meet the query requirements. They are applicable to different situations and have their own advantages and limits. Businesses need to choose the most appropriate implementation solution according to the actual needs when designing and publishing forms:
Implementation Solution | Public Query Link | Form Fill Link |
Application Situation | External members need to query data from a single form based on specific conditions. | External members need to query or update data from multiple forms. |
Usage Limits | All the data to be queried must be stored in the form. External members are not allowed to make modifications after querying the data, such as providing feedback or signing. | / |
Examples of Application Scenarios | Application Scenario One: Spreadsheet Score Query | Application Scenario Two: Separate Forms Score Query |
Practical Application Scenarios
Overview of Scenarios
This guide will focus on query scenarios in the education industry, explore the two methods mentioned above and guide users in selecting the implementation solution based on scenario requirements:
• Application Scenario One: Score query, where scores of all subjects are entered into a spreadsheet,
• Application Scenario Two: Score query, where scores of each subject are entered in separate forms.
Application Scenario One: Spreadsheet Score Query
Introduction
A school manages scores by entering scores of each subject into a spreadsheet.
Business Requirements
- Provide a inquiry portal for parents to check students’ scores by student number and name,
- Allow schools to release the portal in advance. However, it should be set as inaccessible before the validity period in order to allow sufficient time for entering and verifying scores.
Realization Method
- Publish the Score Spreadsheet to the student’s parents through the Public Query Link,
- Setting the expiration date of the Public Query Link to control its accessible time, ensuring that the parents cannot check the score before the validity period.
Configuration Plan
Note: It is recommended to install the app template of Public Link Query Scenario before proceeding. This guide will use the sample data from the template.
1. Building a Score Spreadsheet
Create a Score Spreadsheet for entering student scores of each subject. The fields are set as follows:
Field Name | Field Type |
Student Number | Single Line |
Name | Single Line |
Score Details | Sub form |
Score Details. Subject | Single Line |
Score Details. Score | Number |
2. Publishing the Score Spreadsheet
a. In Publish > To All > Public Query Link, enable the Public Query Link.
b. Further set the Public Query Link as follows:
- Query Conditions：Select Student Number and Name fields,
- Click Set Validity Period to set the start and end times.
Click Save after the setting.
c. Click Copy to send Query Link and Query Conditions to students’ parents.
Application Scenario Two: Separate Forms Score Query
Introduction
A school needs to enter scores for each subject into separate forms.
Business Requirements
- Provide a inquiry portal for students' parents so that they can check scores of all subjects at a time,
- Allow schools to release the portal in advance. However, it should be set as inaccessible before the validity period in order to allow sufficient time for entering and verifying scores.
Realization Method
- Publish the Score Spreadsheet to the student’s parents through the Public Query Link,
- Setting the expiration date of the Form Fill Link to control the opening time of the link to ensure that the parents cannot check the score before the validity period.
Configuration Plan
Note: It is recommended to install the application template of Public Link Query Scenario before learning. This guide will follow the sample data in the template.
1. Building Score Form of each Subject
Create basic score forms for each subject, such as English Score Form, Math Score Form and PE Score Form. Each form should contain fields of student number, name and score. Take English Score Form as an example, the fields are set as follows:
2. Building a Score Query Form
a. Create a Score Query Form. The fields are set as follows:
Field Name | Field Type |
Student Number | Single Line |
Name | Single Line |
Query English Score | Query Data |
Query Math Score | Query Data |
Query PE Score | Query Data |
b. Make the following settings in the Query English Score field. Use the student number and name as filter conditions to check the English scores of corresponding students:
- Query: Select English Score Form,
- Show Records: Click Single,
Display Field: Click Score,
- Add filter condition: Student number Equals Student number, Name Equals name.
c. As in the above steps, set the fields of Query Math Score and Query PE Score for checking the math and PE scores of corresponding students.
3. Publishing the Score Query Form
a. In Publish >To All, turn on the Form Fill Link. Click Set Validity Period to set the start time and end time.
b. Click Copy to send Form Fill Link to students’ parents.
