Forum Discussion
PandoraGirl
Jun 05, 2024Copper Contributor
Create error message when Currency Field exceeds maximum
I have a SharePoint form that I want to set the maximum allowed value and have an error message appear before the form is saved telling the requester that the field exceeds the maximum allowed value. I have tried a variety of things but am not having any luck. The form can't be saved but it doesn't inform a user as to why.
- Josh_WickesBrass Contributor
Hi PandoraGirl
You should be able to use column validation. Go to the lists settings open the column, towards the bottom there will be an option for column validation, add this formula =[Amount] <= 100 (change amount to your column name) and add the error message in the text box below
Now if your users enter a value higher than 100 the error message will appear
- PandoraGirlCopper ContributorJosh,
Thank you for your help. I have used the column validation but I am not getting an error message in the form and they can still save the form unless I add the column maximum allowed value. Then they cannot save the form but they still don't get any kind of message telling them why the form won't save.- Josh_WickesBrass ContributorHave you tried using g the column validation list settings rather than column settings?