Hello!
We recently created a checkout survey that asks patrons if they are celebrating a special occasion at the performance they are attending with us.
While all the parts are working (textbox field, they fill it out, we are getting the CSIs on the backend), it's almost working too well...a blank CSI is being created for every single ticket order, regardless of whether the patron enters anything into the text box.
I have tried to switch a few things around in the setup but haven't been able to stem the flow of blank CSIs successfully.
Looking for any advice on what I missed in setting this up. Thanks!
As John mentioned, I believe it is not possible to only have CSI's created if there is data entered. I do believe that if you have a back end coder who is great at SQL, or if one of those folks on the forums could help, you could set up a process to run overnight to remove or close any 'blank' CSI's.
Jeffrey, thanks for the response! I am working with our DBA to try and do just that. Hopefully, we get it all settled soon.