Hello All,
I am new to Nintex. I came across a strange problem and haven't been able to solve it by reading other posts. Hope one of you could help me.
Intention here is to have a SharePoint list to book seats/desks in office (necessitated by COVID-19 social distancing).
I have created a simple form, and connected the Seat and Date fields from different lookup lists (Date because I want to control which dates are allowed to book). Now I am using a Calculated Value Control to combine Seat and Date to create a unique identifier. Idea is that if this identifier exists already in the SharePoint list, the user won't be allowed to book it again. For this, I have an invalidate rule connected to the Calculated Value Control.
The rule is as follows:
Now, the logic works, which means if the string exists, the Save button doesn't save the data and stays back on the form!! Once the date or seat selection is changed, then Save works if the new string doesn't exist.
But the PROBLEM starts on the Validation Message. Whatever I type doesn't seem to be displayed. So the user doesn't really know why she/he can't save the form. Not sure where I am going wrong. Please help. Below is a screenshot from the New item form.
I even tried a workaround by putting a label below and adding a rule that it stays hidden as long as the calculated value control is true, but this doesn't work either - I think that's because how I tried to do that is incorrect. So if the actual issue cannot be resolved, would also be immensely helpful if any of you could tell me how to implement the workaround.
Cheers,
Sup