Re-submission is not allowed within two months.

1. Use background

In customer management, the customer organization information needs to be reported, so how to set the protection period of the reporting time? For example, if the organization has submitted it within two months, repeated submission is not allowed, you can submit it again after two months. You can refer to this document for configuration.

2. Procedure

2.1 Step 1: Create an intermediate table

Role: stores the customer organization name and protection date in the customer table.

Figure 2.1-1 components required for intermediate tables

2.2 Step 2: Create a customer table

Function: manually fill in customer data, automatically link out the protection date, and then check and compare it later.

Figure 2.2-1 components required for intermediate tables

Set the default value of the protection date field to data linkage, and link the protection date in the intermediate table to the current field (as shown in Figure 2.2-2).

Figure 2.2-2 protection date linkage setting

2.3 Step 3: create a business association rule

Function: after adding two months to the filing date, pass it to the protection date component of the intermediate table.

Figure 2.3-1 Business Association rules

The code introduced below can be copied directly into the formula execution,Note: You need to replace the form fields of the component.

{"text":"UPSERT(​时间中间表​,EQ(​时间中间表.客户组织名称​,​客户组织名称​),\"\",​时间中间表.客户组织名称​,​客户组织名称​,​时间中间表.保护日期​,DATEDELTA(DATE(​报备日期​),60))","marks":[{"from":{"line":0,"ch":7,"sticky":null},"to":{"line":0,"ch":14,"sticky":null},"value":"FORM-HC9660C15W7VETEE2FUEK82HLP7B29XPXWSVK1/","invalid":false},{"from":{"line":0,"ch":18,"sticky":null},"to":{"line":0,"ch":32,"sticky":null},"value":"FORM-HC9660C15W7VETEE2FUEK82HLP7B29XPXWSVK1/textField_kvswxz02","invalid":false},{"from":{"line":0,"ch":33,"sticky":null},"to":{"line":0,"ch":41,"sticky":null},"value":"textField_kvsx6h1o","invalid":false},{"from":{"line":0,"ch":46,"sticky":null},"to":{"line":0,"ch":60,"sticky":null},"value":"FORM-HC9660C15W7VETEE2FUEK82HLP7B29XPXWSVK1/textField_kvswxz02","invalid":false},{"from":{"line":0,"ch":61,"sticky":null},"to":{"line":0,"ch":69,"sticky":null},"value":"textField_kvsx6h1o","invalid":false},{"from":{"line":0,"ch":70,"sticky":null},"to":{"line":0,"ch":82,"sticky":null},"value":"FORM-HC9660C15W7VETEE2FUEK82HLP7B29XPXWSVK1/dateField_kvswxz01","invalid":false},{"from":{"line":0,"ch":98,"sticky":null},"to":{"line":0,"ch":104,"sticky":null},"value":"dateField_kvsx6h1q","invalid":false}],"isCmData":true}

2.4 Step 4: Create a verification rule

Effect: When the protection date is empty, it can be submitted. If it is not empty, it is determined whether the filing date is less than or equal to the protection date. If it is, it is blocked.

Click openForm settings>Add formula>Configuration formula>Select block submit and write prompt text

Figure 2.4-1 configuration formula verification

3. Effect demonstration

Click the form to view the effect directly:Click View

Figure 3-1 effect demonstration

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 this link to fill in the questionnaire

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