Hello Daniel and Yves, and Happy New Year!
Here's a question for the community. I've noticed something with the booking forms. Context: I am adding a SELECT to the form. At the top of the menu, I am adding an option with the text "Please select value" and an empty value. The default value will be the empty value. That's going to check if you've selected a value and warn you if you haven't, that works perfectly well.
Now, all the values in that select will be numbers. They help us to count people. So the options will be 1 person (value 1), 2 persons (value 2), and also No, thanks (value 0). Then in the CSV, we can use the SUM function on this column. BUT when I book an event and I select "No, thanks" with value 0, then the booking form returns "Invalid field: Dinner140219".
So we can't use null because it checks that you have selected a value, and also we can't use 0 (or 00, same effect) because it does the same.
Which numeric value should I use to be able to count from the CSV AND not get this warning in the booking form?
Thanks everyone