Practical Application of Public Links in Different Query Scenarios - Jodoo

This guide will focus on query scenarios in the education industry in which external members, like parents, often need to check scores, evaluations, and other relevant information. You can explore the two methods mentioned above and select 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.

What are Public Links?

In Jodoo, public links include the Public Query Link and Form Fill Link. They apply to different situations where external members need to query information.

Public Query Link and Form Fill Link have their 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

Application Scenario One: Spreadsheet Score Query

In this application, the school manages scores by entering scores of each subject into a spreadsheet. It can 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.

Demonstration

Provide an 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 to allow sufficient time for entering and verifying scores.

How to Share the Public Query Link?

Step 1 Building a Score Spreadsheet

Create a Score Spreadsheet for entering student scores in each subject.

Field Name	Field Type
Student Number	Single Line
Name	Single Line
Score Details	Sub form
Score Details. Subject	Single Line
Score Details. Score	Number

Step 2 Publishing the Score Spreadsheet

1. In Publish > To All > Public Query Link, enable the Public Query Link.

2. 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.

3. Click Copy to send Query Link and Query Conditions to students’ parents.

Application Scenario Two: Separate Forms Score Query

A school needs to enter scores for each subject into separate forms. The school can publish the Score Spreadsheet to the student’s parents through the Public Query Link. Set 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.

Demonstration

Provide an 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 to allow sufficient time for entering and verifying scores.

How to Share Form Fill Link?

Step 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 the English Score Form as an example, the fields are set as follows:

Step 2 Building a Score Query Form

1. 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

2. 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.

3. 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.

Step 3 Publishing the Score Query Form

1. In Publish >To All, turn on the Form Fill Link. Click Set Validity Period to set the start time and end time.

2. Click Copy to send Form Fill Link to students’ parents.

I have finished reading. 🏆

👉I can't wait to SHARE PUBLIC LINKS.

👉I need more HELP in Discord Forum.