How to allow users to make one data entry per day in sharepoint list

Question

I want to allow users to make one entry per day.

Tuhin Paul · Answer

You can achieve this in SharePoint by using a combination of column validation and workflow. You can create a new SharePoint Designer workflow on the list. In the workflow, add a "Condition" action and set the condition to check if the "DateEntered" column contains today's date. You can use the "Today" function in SharePoint to get today's date.

Pramod Bhosale · Answer

Can you please tell me which SharePoint version are you using? (On-prem or Online)

Naimish Makwana · Answer

Hello Sowmya, Please refer blow link: https://sharepoint.stackexchange.com/questions/153059/limit-only-one-entry-per-day-per-user-in-sharepoint-list Thanks Naimish Makwana

Rajkiran Swain · Answer

To allow users to make only one data entry per day in a SharePoint list, you can use a combination of calculated columns and validation settings. Here are the steps: Add a "Date" column to your SharePoint list. This column will track the date when a user last made an entry. Create a calculated column named "Today" with the formula "=TEXT(NOW(),"yyyy-mm-dd")". This column will store the current date in the format "yyyy-mm-dd". Create another calculated column named "DaysSinceLastEntry" with the formula "=IF(ISBLANK([Date]),0,DATEDIF([Date],[Today],"d"))". This column will calculate the number of days since the user last made an entry. Edit the list validation settings by going to List Settings > Validation Settings. In the formula box, enter the following formula: "=DaysSinceLastEntry>=1". This will prevent users from making more than one entry per day. Save the validation settings and test the list by trying to add multiple entries on the same day. The validation will prevent the second entry from being saved. That's it! With these steps, you have set up a simple mechanism to allow users to make only one data entry per day in a SharePoint list.

sowmya AE · Answer

Hello Pramod, I am using sharepoint Online. How can I connect with you online? I have lot more questions I read all of your blogs It would be much helpful for me if you can clear my doubts.

How to allow users to make one data entry per day in sharepoint list

Answers (5)