It would be nice, if we could use @ also from the mobile version, not only from desktop version. ... View more

Hi! So have a question. We have a system where we are always putting money into Credit card numbers that are attached to certain bank account numbers. The way we have it set up is Accounts Credit Cards Flagged Accounts (Replacements for Cards) We label it as T-Cardnumber-Accountnumber; we have two cards for each account number. So T-1234-0000 & T-5678-0000 They both need 900 dollars in them at all times (so if they were both active it would be 1800) So if T-1234-000 needs to be replaced, we empty its “portion” out of the bank account (-900) What we do is we search via blocks to see if T-5678-000 is active (so it tells us if we need to leave 900 dollars in there to compensate for that one …say it got charged and there was only 1200 dollars in the account, so we would only take out 300) Confusing. Anyways, we wanted to use the “Blocks” search to find how many ACTIVE cards are linked to it. Thing is, we get replacements for the cards, and so on the “Cards” doc we will have like 5 or 6 cards that show the same account number (previous replacements). We have check marks for the accounts that were “Added to account” . Once they are added to the account we put the Credit card code on the accounts tab… How do I filter out the column “Added to Account” when searching in Blocks? Or is there a feature where once I check mark the “Added to Account” column I can archive it that entire row? ... View more

Allowing formulas to cross-reference other sheets in the base ... View more

I would like to make a sheet for collaborators to be linked to multiple other sheets in the base. That way, collaborators can see anything they’re tagged in from one sheet. ... View more

This just came up recently, and I couldn’t find a similar request outstanding. Lately I’ve been working on a query generator for a client with some relatively complex database and reporting requirements. Frankly, as the base currently stands, it’s impossible to create a query using filters that meets his needs, as the values to match and the records to report are too distant in the model. To get around that, I’ve created a table he can use to build queries. Each record represents a single atomic query (e.g., ‘which customers bought a white widget in 2016 or 2017?’ or ‘who bought a widget at WidgetWorld in 2017?’). Up to five queries can be defined, and the individual queries can be AND ed or OR ed together to create more complex inquiries. Admittedly, it’s a work-in-progress, but so far it seems to be holding up. I’m about to add more potential variables to the equations — say, salesperson (‘Who bought a widget from John last year?’) or color (‘How many people bought camo widgets in 2012’). Currently, I have a <Make Selection> view that hides all but those fields pertinent to creating a query. I’d like to change that to <Make Selection> and <Advanced Selection> , with several less-frequently used values visible in the latter but hidden in the former. The concern is that the user may easily switch from <Advanced Selection> to <Make Selection> with a value or values still present in [now-hidden] advanced fields. I already have an {Alert} field that watches for common problems and flags them (for instance, specifying both a generic ‘during year 2017’ and a specific 2017 event [‘Widget World Asia 2017’]), and I’d like to expand it to include such things as values included in hidden fields. If I could do something like IF(@CurrentView='NormalSelect', ; advanced fields hidden IF( OR( Salesperson!='', Color!='' ), 'Alert! Hidden fields contain data!' ) ) then I could watch for such an error (and no doubt help prevent hours of confused troubleshooting). ... View more

While it seems Airtable is a desktop-built application, many customers/clients use mobile. A fair limitation to using Airtable for our business is the ability for our prospects to use the Sort/Filter features for an embedded view on mobile. They simply can’t interact with the data unless they are at a PC… ... View more

For the URL field type, I’d like to be able to set a field option so clicking on the URL opens it in a new window/tab. ... View more

Please create a global chat so we can have a conversation with teammates that are general and are not based on a specific record. ... View more

I like the fact that I can create links between records in the same table, however, it is not super useful beyond creating parent-child relationships for the org chart block. It would be much better if it was possible to apply a lookup to one of these linked fields so that those relationships could be more useful. I understand that there’s a risk of creating circular logic, but that could be addressed by preventing the lookup of the fields that would cause that to happen. A real world example of this is trying to create a website site map and using these lookup fields to determine what the permalinks would be for any page. There would be a field for the url slug, and then a formula that would create the permalinks based on the parent-child relationships. Right now, the only way in which this is possible is by having multiple tables, which basically violates the relational database rule that each table should contain the same type of object. ... View more