Contact Login Register
h M

Data Springs Modules Community Questions & Answers

Dynamic Forms Sold Out Tickets

We have a form selling tickets. People can choose the amount of tickets they want. The client only wants a total of 150 tickets sold. We were wondering if it's possible for the form to remember how many tickets were sold and show up with a "sold out" message when the limit is reached.

Thank you!


asked 4 months ago
Elizabeth Netzhammer2
Elizabeth Netzhammer
  • HI Elizabeth, so you would need to do this:

    1) create an SQL table several columns with the maximum number of tickets (150), and another column with (tickets remaining) column.
    2) each time someone submits the form by choosing a certain amount of tickets, you would update the SQL table and subtract the amount from the tickets remaining (or you increase the amount and make it tickets sold)
    3) then on page load, you check this table for remaining slots available or ticket sold and if it goes to 0 for remaining slots or to 150 for ticket sold, you would display a question that shows Sold Out through the configuration of question events.

    So you would need an SQL table, an SQL completion event, SQL initial binding to get the open tickets available, and question event to display Sold Out message and hide all other fields so they cannot purchase any longer.

    I hope that points you in the right direction.

    Data Springs Technical Support - David To 4 months ago

0 Answers

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...

10 inform moderator flags remaining

I am deleting this question because...

I am flagging this answer because...

10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

Luxury replica watches
konulu porno
deneme bonusu maltcasino bahis siteleri
escort beylikduzu gay porno