The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
It would be helpful to sort a table by last name, when you have a single field for the whole name. I envision this being a check option when you choose sort options. Presently, when you choose the option “Sort”, you get the option to sort A->Z or Z->...
A table view that allows the user to draw simple shapes and place them to form a layout, and then place records in those places. Starting with a simple gridded background (i.e. like graph paper) place a circle or a rectangle in the grid and then conn...
I would like to build a database that has records in flux and records that are locked. The records that are in flux–the current period, whether monthly, quarterly, or annually, would be separated from locked records by a closing date (or other numbe...
I certainly understand the complications of an autosort feature. It seems to me this could be accomplished by having reports. When you pull up a report view, the information would be sorted. You could determine whether you wanted the view to autoupda...
Try using the group feature to group the records by the dates in question. (You may need to create a column that uses a formula to classify the record). When Airtable groups records, it automatically gives you a count of the records in each group an...
Why can’t you create a form from the MEMBERS table? Each member would be a record row, and the columns would include in addition to what I suggested above, any additional info (contact info, for example) that you wanted to keep for each member. You m...
I agree with the prior comment that you may be asking for something that Airtable is not designed to do. You might be able to try this though:
Table VENDORS to list all vendors, with a column for products, which are linked to…
Table PRODUCTS list a...
Sounds like you need a table, MEMBERS, that lists each member and status (leader vs. team-member), and team.
Then you need a table, TEAMS, that lists each team. For each team there will be multiple team members (linked to MEMBERS, multiple members in...