- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 29, 2024 03:36 PM
I have a very large, dynamic number of opportunities with a dynamic number of positions available in each opportunity. I want to limit the number of Form submissions to the total number of slots, depending on the opportunity. When registration opens, it’s a mad rush because the spots are first-come first-served.
The number of opportunities are too large to monitor manually, and I don't want to deal with the headache of an automated email that says, "sorry, please try again." Its a potential for too many unhappy customers.
The Form is currently accessed through a button in an Interface, and I'm curious about the Record > Button: Rules > Visibility feature. Thinking I could hide the button to limit the access to the form (that's half of the challenge), but every time I click on the Visibility toggle, Airtable prompts me to upgrade without an explanation of how that would help. I've reached out to Support but haven't heard back.
The rabbit hole took me to Fillout, which has amazing features, but the conditions were static and only available through URL params.
Can anyone think of any way I might accomplish this? Outside the box is welcome.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 29, 2024 03:26 PM
@ScottWorld Still working on a solution for a dynamic form submission limiter using Fillout.
From what I tested today on Fillout, the "quantity remaining" was passed in through URL parameters, so it won't refresh, per se.
Right now, access to the form is through a button on a shared, public view. The button action opens a URL from a Prefilled Formula. In the URL formula, I created an IF() statement that keep the button active as long as the filled positions < total positions, like this:
IF({Filled Positions} < {Total Positions}, {Prefill Airtable Formula}, '')
I also embedded the shared view in a webpage, therefore, I have the view set to hide a row based on the same condition.
I'll keep digging in Fillout to see if there's a way to refetch those values when navigating to a second page.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 07, 2025 08:45 PM
Hi there!
At miniExtensions, we've created a third-party form that integrates seamlessly with Airtable, and allows you to restrict submissions when specific conditions are met. By using an auto-number field and the Save & Continue mode, you can track how many submissions have been sent. Additionally, with the multi-page view, the user will be informed that their submission will be invalid on the first page before they decide to proceed.
To set up the condition, you will need a formula field that reflects the value of the auto number field.
The, you can activate the Save & Continue mode in the Save & Continue section. You can choose to have the Save Mode either manually triggered by users with the Save Button each time they make a change, or automatically triggered every few seconds, along with the Save Button. When this mode is activated, the formula fields in your form will be computed, allowing conditions to be verified based on the submission’s auto-number value.
Go to the Field Validation section and add the condition using the formula field that reflects the autonumber field.
The Save & Continue mode will compute the formula on the first page of the form and inform the user that the limit has been reached.
- « Previous
-
- 1
- 2
- Next »