Looking to leverage Airtable for a complex volunteer tracking tool.
How can I create “shifts” that volunteers can select in a signup form? Similar to signup or signup genius? Without having to manually enter every available shift as a select option?
Also, need to limit some of those “shifts” to one or two volunteers, so they wouldn’t be an option after they were selected or filled.
This seems like a common issue that someone may have solved already.
I have a table with events. And a table where you can register for these events. The latter one has a form. I only want people to see upcoming events in that form. Not the past ones.
I’m using a table as a personal task manager and want to use linked records to split tasks into subtasks. Right now I can link to records in my subtask table, but I can’t tell whether a task is complete or not without opening the expanded view. I would like to set a filter to hide all the completed subtasks on a given item.
Yup - I have already sent this through the help link - very important!
My use case is choosing client from related tables that need to show client info or forms - I only want to see the currently active clients (15 to 20) instead of the entire history (hundreds).
Let’s keep this thread alive :slightly_smiling_face:
Michael
As I do more Airtable work for clients, this becomes more and more of an issue. Also, as implied by my comment above, it should be configurable by view (or at least For Forms).
The most typical use case is to be able to select a Contact - but only one for a particular Client. In other words the second link is filtered by another filed in the same record - in Acces, as an example, this would be achieved with Cascading Combo Boxes.
I have a use case: I manage a small club. There are Prospective Members, Active Members, and Former Members. They’re all “Contacts”. Then there is Attendance. When I take attendance I would like the Active members to show up as a list of available values. I also want to be able to look at all the attendance for the past year, so if at some point in the past there was an Active Member and now he’s a Former Member, I still want him in the list. Therefore I shouldn’t separate Active and Former in separate tables (a suggestion I read somewhere). I can see the limits of Airtable when it comes to values with statuses. A filtered linked field would allow me to only enter the relevant values from the Contacts table.
The same thing with people using a form where they need to pick a date from a table. The filter in the table is ignored, which is very aggrevating for the users.
