Form that Holds a Seat During Submittal

asked on December 11

We have a lot of requests for a Form (on-prem) for someone to register for something. For most requests this is not an issue but for some where there is limited capacity and/or limited time to sign up, our customers are wanting someone to be able to "hold" a seat for a period of time (e.g. 10 minutes). This is similar to when buying a concert, sporting event, or movie ticket where it lets you hold your seat while you fill out the rest of the form. If you do not submit it in time or leave the page, then you loose your seat.

Has anyone built a Laserfiche Form with the Modern Designer for public submittal with this functionality? If so, how did you handle:

Starting the timer
Showing the remaining time counting down
Releasing the seat when the timer ran out
Releasing the seat when they left the page without submitting

I appreciate any assistance, as we want to see if this functionality is worth developing or if it is too finicky.

0 0

replied on December 11 • Show version history

The timer is doable with custom JS and custom HTML fields.

The seat reservation will be a little more difficult, but not impossible. If you expect it to have a lot of simultaneous activity you may have issues with the delay between checking if a seat is available and reserving said seat.

In cloud you would have a harder time with this delay using lookup tables since they only support select and update in two separate calls.

You could use stored procedures and direct database connections in cloud if your environment has a database available.

In self-hosted you could use a stored procedure to check/reserve a seat at the same time and another one to unset the seat.

1 0

replied on December 11

This is on-prem so I have more flexibility. That's where I was at too with the JS & HTML fields, along with stored procedures for placing the hold.

Even when I get all that working, I am still trying to figure out how to remove the hold if they just leave the page. Closing the window wont trigger anything that I can call so I am still working that one out if you have any suggestions. My guess is it will be something on the SQL side where I "release" the hold for this case.

0 0

replied on December 15

I would handle it on the SQL side. So query based on some expiration date time and an id like an email. So technically if the user refreshes or closes and reopens the form they can get their same reservation and the timer keeps counting down.

0 0

Question

Question

Form that Holds a Seat During Submittal

Replies

Sign in to reply to this post.