I have created a booking form and I want only want 30 bookings on any date selected

  • 26 July 2018
  • 1 reply
  • 6 views

I have created a booking form so that users can book for a workshop, but I only want 30 users per day

I created a column on my form booking count, which is a calculated value with this formula

 

IF([Booking Date])=30, "Booking is full"))

 

but It does not do what I want, what might be wrong


1 reply

Hi Dimakatso Maluleke,

Does the issue still exist?

If so, can you elaborate more about the situation?

If not, would you share how you work around the issue?

From the information you provide, I will guess it might be syntax error.

the formula you provide consists of excess parenthesis highlighted in red below:

IF([Booking Date])=30, "Booking is full"))

Reply