I have a base that has multiple tables with different kinds of items (RFIs, Submittals, To Do list, Change Orders) and I want the main tab to have a list of only the open items from each category. How would one go about doing this? ... View more

I have ended up with very wide tables (100+ col’s) that are hard to navigate in either grid view or as vertical tables. I would dearly love the ability to easily separate into separate tables on 1 to 1 relationship or group certain fields into a tab so as to get them out of the way. So instead of a huge vertical form view of a record, i see 6 or 8 different tabs, each tab containing groups of data - like, publishing attributes, acquisition attributes, sale attributes… these are all col’s of my data and it’s not easy to separate them out to separate sheets, yet it’s not easy to manage the data on wide tables either. basically, what i’m looking for are 1 to 1 relational sub records that can be displayed as tabs ... View more

Hello! Id like to report a couple hiccups in the user experience of our Airtable forms (at least on my iPhone 5s): When entering a date into a date field, the keyboard pops up and covers up the date picker. You can’t move the date picker to view it in full, and if you touch the x to remove the keyboard, the date picker closes too :frowning: When finding an existing record, the keyboard also pops up and makes it difficult to choose from existing records: Chosen existing records appear much wider than the form itself on the mobile screen, so that it’s difficult to figure out how to delete them if you’ve chosen the wrong one: ... View more

I would like to link to a linked field on a table so that on the third table, the list presented is a subset of the records in the context of the second table. That probably makes no sense so I’ll try to sketch it out: Table A A Record1 A Record2 A Record3 A Record4 A Record5 A Record6 A Record7 Table B B Record1 linked to: A Record2 A Record5 A Record6 A Record7 B Record2 linked to: A Record3 A Record5 Table C C Record1 linked to: B Record1 What I would like to create on table C is a column that links to Table A in the context of Table B. So that if I want a link to Table A in the context of Table B, I’m only shown the corresponding records from Table A as selection choices, rather than ALL records from Table A. In the example above, linking C Record1 to B Record1, the link to linked field on table C would only list A Record2, A Record5, A Record6, A Record7 instead of the entire contents of Table A. Is this possible today or is this only available as a feature request? ... View more

We run a government program over 9 different offices and use colors in the calendar to show which office a calendar event applies to. We have a number of different types of calendar events and would love to be able to have events identified using tow different colours (e.g. a swash on the side). ... View more

First post, so I apologize if this is in the wrong place, or it’s a duplicate. I did a search, but did not find a match. Also, this feature could already be in the app, and I just missed it. Situation: I’ve got a 1-to-many relationship between two tables in a single base. For illustration purposes, let’s say one table is “People” and another is “Families”. Let’s say that I accidentally link the wrong Person to a Family. Is there a way in the Android app to remove that relationship? It looks like I can long-tap and move the records/links, but there does not seem to be a way to remove them. In the web app, I can select an “X” in the field to delete the relationship, but not in the Android app. ... View more

It appears that when you create a countdown block, the time configuration defaults to GMT. It would be great if there was an option to count down time in a specific timezone, or to view the time left in the countdown from my local timezone. ... View more

This one’s a little complicated to explain in the abstract, so I’ll give you an example: Let’s say I’ve got a table of Students and a table of Classes. The primary key on the Classes table is a number field rather than a single-line text field, the number corresponding to the graduation year. In the Students table, there is a field that is a link to the Classes table, so that each student can be associated with their graduating class. Let’s say we have a student named John Smith who graduated in 2015. The record for student John Smith would have associated class of “2015”, which links to all the properties of class “2015”. Now, lets say I’m on the Students table and want to filter out all students who graduated before 2014. When I hit Filter while viewing the Students table and chose the Class field (that is, the field that links to the Class table) the filter options I’m given correspond to single-line text (contains, does not contain, is/n’t empty) rather than the data type of the primary key, number. For this purpose, that wouldn’t work very well as I would like to be able to filter students based on class number being greater than or equal to 2014. I recognize that since you can link to more than one record, you may need additional logical parameters (any vs. all). But I still think it would be useful. ... View more

I’m trying to use a lookup function to help me avoid running a zap within zapier. But it seems I’m limited to do a lookup (count sum function) within a specific table, not within a specific view within that table. Here’s the deal… I currently keep track of my customers that have requested quotes from our shirt shop (but don’t have an actual order going yet) in a specific view within my ‘order’ table. When they convert their quote into an actual order, we just change the ‘order status’ within that specific record. In order to help each quote customer remember to reply to us (if they want to move forward or not), we automatically send them a ‘1 week reminder message’ and if they still don’t reply a ‘2 week reminder message’ - These messages are zaps running within zapier. These reminder messages are great and help us convert a lot of customers into actual orders, but sometimes we have an issue where certain customers call, email or physically come into our shop to start their order, versus going through our suggested route of converting their quote into an order. The problem that arises from them starting a new order while also having a quote with us is, even though they now have an active order record with us (displayed in our ‘all active orders’ view), they also still have an active quote record with us (displayed in our ‘all quotes’ view). Because they have two records for the same order, specifically the one in the quote view, we don’t have a way to check for conflicting records automatically and their ‘1 week’ and ‘2 week’ quote reminder messages will still be sent out (which is awkward when they have an active order at the same time). If I could do a ‘lookup’ function, and have it be limited to a specific view, I could do a lookup within our ‘all active orders’ view and have it count how many records exist, displaying a number. If this field displayed a number greater than 0, I could have our ‘quote’ order status records (that also have a number greater than 1 in the look field) show up in their own view. This view would then trigger an integration within zapier to auto-create a todo for our team to manually look into this, verifying if we need to delete the quote record or to see if it is, in fact, a unique quote. So, does this feature already exist and I just can’t find it? If not, I’d love to add it as a feature request. I can think of a dozen uses for this functionality. Thanks again! ... View more