Skip to main content

How to display the latest data

1. Business Background

In some scenarios, we need to display the latest data entered in the current form in this form. For example,The epidemic situation needs to be reported every day. When the form is opened and submitted, the data in the form displays the content of the last submission.

2. Design ideas

Create 2 new forms, enter a basic data table with members-fill in daily, and design multiple other fields; Then design the same form-fill in the bottom table, used to store everyone's latest data.

Set up data linkage in the daily filling table, and fill in the bottom table data in a linkage based on the conditions of members. When entering data in the daily filling table, update the data in the bottom table based on the members in the Member component. In this case, the data in the bottom table is the latest submitted data, which is displayed in the daily report table through data linkage, you can obtain the latest data entered in the current form.

3. Form design

[Fill in daily]: the basic data table. The member component automatically obtains the current login person, and uses the current login as the condition to fill in the bottom table, configure the data linkage, and enter the basic data in advance.

Obtain the current logon person as shown in the following figure:

The data linkage configuration is shown in the following figure:

Note: all components except member components that need to obtain the latest data must be configured with data linkage.

[Fill in the bottom table]: a data storage table that stores the latest data of each person.

4. Configure business association rules

PassBusiness Association rulesTo update the data entered in the daily fill report to the bottom table.

Fill in daily reports>Form settings>Form events>Formula execution>Add Business Association rules;

5. Effect demonstration

6. Video demonstration

此处为语雀视频卡片,点击链接查看:新-表单回填.mov

YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!

Click here to fill in the questionnaire


-------------------- Get the latest information YIDA, welcome to follow US--------------------

This doc is generated using machine translation. Any discrepancies or differences created in the translation are not binding and have no legal effect for compliance or enforcement purposes.
Copyright © 2024钉钉(中国)信息技术有限公司和/或其关联公司浙ICP备18037475号-4