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!
Sydney Schless,
If, as I take it, your goal is to have a functioning checkout survey that creates a CSI if and only if they actually fill in that field, I am not entirely sure that is possible with standard, out of the box functionality. You CAN make it so that there is NOT a CSI created as we do since our checkout survey is solely the order source number survey, but I am not aware of any way to make it so that the CSI is only created if someone actually enters data. You could of course REQUIRE that patrons enter data, but I assume from your post that that would be equally undesired.
Happy to be wrong if someone else knows otherwise, but that is my understanding.
John A. Moskal II
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.
John, thanks for the response! I am continuing to dig into options.
Jeffrey, thanks for the response! I am working with our DBA to try and do just that. Hopefully, we get it all settled soon.