Hey Community!!
Not a real actual current use case, but thought I'd spice-up the community a bit to kick-off the year! I can think of different workarounds for the following edge case, all of which could theoretically work (although not ideal) however I'd love to get to know your thoughts for it as the same logic and issue applies for other use cases.
E.g. think of music concert tickets with initial stock of two (2) tickets.
If Buyer A, Buyer B, and Buyer C all open the form at the same time (or before any submission occurs), they will all see availability of 2 tickets.
Even if Buyer A purchases 1 ticket, available tickets shown on Buyer B and Buyer C's screen will still show 2 (unless they refresh the form and therefore retrieve new updated data from Airtable).
This will not be an issue if Buyer B purchases 1 ticket immediately after -as there is still one ticket left.
However, by the time Buyer C wants to make the purchase, the form still shows 2 tickets are available, however there is actually 0 available tickets. Regardless of that, Buyer C will still be allowed to move forward with his purchase.
Workarounds I can think of:
- Confirmation Email checking actual stock at the time of submission, and letting the buyer know the tickets were not available.
- Re-direct, before payment/final submission, to a second form that could check latest stock (issue would persist if they all land at this new second form before they actually pay).
Any form auto-refreshes by itself (I love Fillout, but I'm aware they don't do that). I might be missing on smth obvious...
Special call for my fellow active community members @TheTimeSavingCo @ScottWorld @kuovonne 🙂
Best practices for working with forms handling items subject to stock?
+21Best answer by Alexey_Gusev
Hi,
I did a quick try with old forms, each ticket is a record in Tickets table, linked to Buyers table. A formula in Tickets shows Free or Purchased depending on Linked field
In Buyers table, only Free tickets available for selection
Then I tried to open Form and go to Select ticket, chosing the free one.
In other window, I 'purchased' this ticket by other Buyer
Returning to Form, I pushed Submit and get this message:
Don't know, maybe it can be helpful.
+23Hi,
I did a quick try with old forms, each ticket is a record in Tickets table, linked to Buyers table. A formula in Tickets shows Free or Purchased depending on Linked field
In Buyers table, only Free tickets available for selection
Then I tried to open Form and go to Select ticket, chosing the free one.
In other window, I 'purchased' this ticket by other Buyer
Returning to Form, I pushed Submit and get this message:
Don't know, maybe it can be helpful.
+33Wow, that’s an amazing discovery that you found there, @Alexey_Gusev!
That solves the problem right there! I didn’t realize that Airtable had built in that feature.
I wonder if Fillout offers this functionality built into their product??
- ScottWorld, Expert Airtable Consultant
+21Hey @Alexey_Gusev sounds exactly what would be needed! I should test the filter to be "Available Tickets is greater than 0". But should work just like your "free/purchased" filter did! Thanks!!!
Unfortunately Airtable Forms are usually not powerful enough, and therefore I rely on Fillout and other providers a lot. But Kudos to Airtable for this one!!
@ScottWorld, I can confirm that Fillout does not offer such functionality :(.
Mike, Consultant @ Automatic Nation
+33I just submitted this as a feature request to Fillout.
I created a Loom video for Fillout at this link which you can watch — although for future people reading this thread in the future, I don't keep my Loom videos forever, so that link will be invalid in the future.
- ScottWorld, Expert Airtable Consultant
+21Thanks for submitting that @ScottWorld! Loom video is great, just watched it 🙌.
If you get any response, or workaround suggestion from Fillout, I'd love to hear more about it.
Thanks @ScottWorld and @Alexey_Gusev. This was fun!
Mike, Consultant @ Automatic Nation
+33The CEO of Fillout wrote back and said this:
Thanks for sharing this Scott! Added it to the roadmap 🙂
+27I'm late to the game, but yeah, race conditions are a pain. If buyers B and C both submit the form at the exact same split second, there is still an issue. But the chances of that happening are small enough that I think we don't need to worry about it. At most, I would add to my {Data Validation} field that there are more purchased tickets than are available.
+21I'm late to the game, but yeah, race conditions are a pain. If buyers B and C both submit the form at the exact same split second, there is still an issue. But the chances of that happening are small enough that I think we don't need to worry about it. At most, I would add to my {Data Validation} field that there are more purchased tickets than are available.
Thanks for pitching in @kuovonne! That safe bet is only if using Airtable forms -which for sure have their own limitations (as discussed on different posts). Chances of messing up using Fillout (or others) is not low at all 😞
Looking forward to more powerful Airtable forms!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.