Employee Information collection data statistics
1. Case Background
Administrative personnel often encounter employees who fill in the form slowly and easily forget to fill in. Administrative personnel cannot remind employees to fill in the form in a unified manner in time or quickly know which employees have not filled in the form.The solution is not unique., the following steps are relatively simple to implement.
2. Achieve results
- Automatically remind personnel to fill in the form
- Real-time statistics of filled and unfilled personnel lists
3. Procedure
In this case, two forms are required (one form stores personnel information base table, one personnel information form to be collected) and one report (displays data)
3.1 Step 1: Create a bottom table of personnel information
3.1.1 after creating the application> Click Create page in the upper left corner> select Create form
Create a form
3.1.2 go to the form editing page> pull component configuration
The personnel information storage table does not require too many components, but only members, dates, and radio components. If you need more components in your own scenario, you can add them by yourself.
Configure components
3.1.3 message notification configuration
Verbal notification staff fill in the information often forget the situation, to avoid forgetting can pass YIDA Message notificationPersonnel fill in
Message notification
3.1.4 enter the information base table
Do not fill in the "fill in date" field first, enter no in the "fill in or not" field first, and use the business association rules to update the current form data after the personnel fill in.
Input information
3.2 Step 2: create a collection information table
3.2.1 after creating the application> Click Create page in the upper left corner> select Create form
Create a form
3.2.2 go to the form editing page> pull component configuration
For more information about the fields to be filled in the form design, see the following screenshot component types.
Component configuration
3.2.3 function formulas used in the form
(1) use the USER() function to automatically obtain the name of the person currently being filled in
Automatically obtain the current logon person
(2) automatically obtain the Department of the current login person
Automatically obtain the department to which it belongs
(3) use 2 date components to automatically calculate the number of days in and out of work
Automatically obtain the number of days on the job
(4) obtain the age and gender according to the ID number
The following code can be directly copied to the formula editor,Note that the ID card field is replaced..
{"text":"IF(EQ(LEN(身份证),18),VALUE(TEXT(TODAY(),\"yyyy\"))-VALUE(RIGHT(LEFT(身份证,10),4)),\"\")","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":15,"sticky":null},"value":"textField_kn8841dw","invalid":false},{"from":{"line":0,"ch":66,"sticky":null},"to":{"line":0,"ch":71,"sticky":null},"value":"textField_kn8841dw","invalid":false}],"isCmData":true}
Automatic age calculation
{"text":"IF(EQ(MOD(VALUE(MID(身份证号,17,1)),2),1),\"男\",\"女\")","marks":[{"from":{"line":0,"ch":20,"sticky":null},"to":{"line":0,"ch":26,"sticky":null},"value":"textField_ksfyitkm","invalid":false}],"isCmData":true}
Automatically calculate gender
3.2.4 configuration of business association rules
In this case, after the employee submits the "basic information filling form for employees", we change the field data of the "personnel information bottom form" and "whether to submit" to yes, this effect can be achieved because we have used itBusiness Association rule formula, for more information, see the following or documentation.UPDATE-UPDATE
Note: The symbols in the formula need to be in English.
Business Association rule configuration
3.3 Step 3: Create a report
3.3.1 create page> Create report
Create a report
Go to the report Design page> select components. You can select any chart according to your needs. The Table component is used in the case;
Two table components are required in the report to display the list of submitted and unsubmitted personnel respectively.
Pull report component
To better distinguish the content displayed by the two table components, you can set the title of the table components to display, which supports custom naming.
3.3.2 configure datasets
The two tables can be configured in the same way.
Data configuration
3.3.3 conditional filtering
Because the data displayed in the two tables is filled in and not filled in respectively, you need to set conditional filtering on the table data, as shown in the following figure.
Submitted personnel filtering
Unsubmitted personnel list filtering
4. Effect display
The effect of the dynamic chart is displayed from the input data, message notification, whether to fill in the fields after the personnel fill in the form, and the final report.
5. FAQ
5.1 How to verify the ID card number field?
Select the ID number in the format of a single line of text.
Format components
5.2 why can't the link component of the bottom table be found?
Form/flow chart has no link component. You can copy it to the form on a custom page.
Configure component links page
6. Further reading
7. Try it online
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!