I’m new to Airtable, and trying to understand the big picture of what it can and cannot do when it comes to app building.
We have a need to build an app that displays customer & internally submitted ideas, with a navigation (tree?) of Products & their categories to help filter results. I see we can allow non-paid users to submit ideas via a Form, see results as read only, and possibly interact with some additional Form / automation work arounds for things like voting and comments on other people’s ideas (hopefully without making it cumbersome to the user).
I’ve experimented with Interfaces a bit to review what kinds of elements are available, and am exploring templates.
Questions I still have:
- It is possible to have just an expandable tree of Products and their Categories in one element, that when selected filters a second list element? We would be starting with 30,000 records, and would need to filter down the view. The Record Picker element would be a good fallback, but I believe we would need to have a secondary picker that is dependent on the first, before finally displaying records.
- Can we restrict who fills out the Form, if we already have them logged in to a parent app which can authenticate via SSO to the airtable app, embedded or in iFrame?
- If we want unpaid users to be able to vote on an issue, any ideas on setting that up? My first thought is some kind of link to a form that is auto-filled, auto-submitted, and triggers automation, but it’s the limiting to one vote (and removing the vote) that I’m not sure about, unless we can record who is submitting the form.