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

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:

1. Add a "Date" column to your SharePoint list. This column will track the date when a user last made an entry.

2. 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".

3. 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.

4. 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.

5. 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.

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.

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.

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

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