Only one data can be submitted per person per day.
During the form design process, we can set that duplicate submission is not allowed for each field. However, in the actual application process, each field may be allowed to repeat, but several fields may not be allowed to repeat. Common situations include the submission of employee logs, event registration, and welfare claims.
The following is an example of how to limit each person to submit logs only once a day.
1. Create a form
First, we create a log submission form, which mainly includes the member name, submission date, and today's work report. If you need to submit other content, you can add it yourself.
Log submission form
The name uses the member component, the submission date selects the date and time, the work report selects multiple lines of text, and a single line of text is added as an aid, which is set to visible but not editable.
2. Function usage
Here, we use the member component to obtain the nickname of the current member through the USER() function.
Get the current member
Permissions on this field can be set to visible and not editable. You can select a date by yourself or use the SYSTIME() function to automatically obtain the current server time.
Obtain the current server time
Then we add a single line of text as an auxiliary (you can also write some instructions for this auxiliary field). The submission date needs to be converted from timestamp to text as a verification condition. TEXT(DATE (submission DATE),"yyyy-MM-dd")
Convert the submission date to text
At the same time, set the form verification formula EXIST (name, each person can submit only one piece of data per day), and set the field permission to read-only.
Submit verification
3. Effect demonstration
With this setting, you can limit each person to submit only one piece of data per day. If you need to limit multiple values, you can continue to add them as needed.
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!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
