hey, Linked fields populated by formula !!!!!! I think it's so obvious and self-explanatory for everyone that has ever dealt with relational databases. this is a feature needed for yesterday, it just makes no sense we need to use all those workarounds and automations to get there, and although product is already so advance this is still not available :(( ... View more

I am trying to create a company budget database where all the accounts are in the main table (grid view), but some of them are subaccounts of other accounts (and others are sub-sub-accounts, etc.). All the parent/child relationships are between records in the same table. How do I display the data where the sub accounts are indented under their parent records and can roll up at each step of the hierarchy, if desired (including a calculated sum field) For example,  100 Personnel Costs ($250K) <-- This is a calculated roll-up from subaccounts         110 Salary & Wages ($200K)         120 Healthcare ($50K) 200 Facilities ($65K)  <-- Calculated         210 Rent ($30K)         220 Maintenance ($20K)         230 Exterior ($15K)  <-- Calculated                 231 Grounds ($10K)                 232 Signage ($5K) etc.... It would be nice to roll up the budgeted amounts for each subaccount into a field in its parent account. I tried the List view type, but that requires a relationship between records in two different tables.     ... View more

Converting a Single Select text string to a numerical value requires multiple fields and formulas.  This idea proposes a way to automatically convert a Single Select text string into a numerical value within a single Field. An additional build on this concept would be to include a formula calculation option within the single select field options.  See concepts below... User selects Text (e.g., "Minor Issues") and Airtable sees a numerical Value (in example below, "3")     Option B: Embed a Formula option within the field: User selects text string  "Jan" and Airtable sees 01/01/2024. (I realize example below is not correct formula) ... Currently this process requires 2-3 fields and formulas to convert a text string to a numerical value which clutter up the base very quickly. Also if the single select text string is long or if the choices change, creating and updating the formulas to convert to a value becomes extremely tedious.  .. No validation done yet ... Creators who are using text strings to make choices user friendly and they don't want to have multiple fields and formulas complicating the base.  ... ... View more

What is the proposed idea/solution? Creating a dedicated workspace for formulas that are on the bottom of the window in a Base that will generate greater visibility for formula expression writing.  It would also be very helpful if the formulas would have more predictive capabilities.   How does is solve the user problems? The current floating model is often too condensed to navigate or edit when dealing with lengthy formulas.  This would allow for greater visibility.  How was this validated? There can be a "expanding" button that could create either a pop up window or a lower page window for viewing the formula. ... Who is the target audience? ... ... View more

Airtable finally added this calendar month as a date filter option which is great, however there needs to be a last calendar month instead of just last month. We need to submit every month our expenses from the previous month. So for example today, I need to be able to see all expenses from January (i.e. last calendar month). How it is now if I do last month, it will show me expenses from Jan 14 - Feb 14 which is not useful. ... View more

I have a table with many, many fields (150+).  Not all of these fields need to be populated.  In fact, most of them are sparsely populated based on conditions present in other fields. It would be awesome if in GRID VIEW there were a way to selectively "gray out" field values based on a formula (unique formulas per field would be ideal).  That way, users could visually know when to "skip" a certain field and focus their attention on others. I need this functionality specifically in GRID VIEW, because my users do a lot of visual comparisons between ADJACENT records -- and there's no easy way to do this visual comparison in any other view types currently. ... View more

What is the proposed idea/solution? I want to be able to add a color based on a formula. For example I have a bunch of subtasks under a parent task. I want to color the records where due date is greater than the parent task end date because this is a task I need to be flagged since the whole task should be done before it is currently planned. Ideally the formula would be,  IF({parent task end date} - {due date} < 0) and then I can set the color to yellow. ... View more

What is the proposed idea/solution? ...when changing the name of a Field in a Synced Table, the updated name should also be Synced. This would likely require a feature, whereby a Synced Field and a local Field can have the same name without a conflict. This should not be a problem, because it's easy to determine what is synced field vs local due to the lightning bolt icon. How does is solve the user problems? ...without this feature, any changes to a Field Name are not propagated to other Synced Tables. This causes confusion. How was this validated? ...Try changing the field name of a Synced Table and find out! It's frustrating. Who is the target audience? ...all users who use Synced Tables. ... View more

What is the proposed idea/solution? ... A new feature that transposes the Rows and Columns of a View. How does is solve the user problems? ... It is useful to transpose the Rows and Columns of a Table for for viewing and / or calculations. In Airtable it is more efficient to create Records for time rather than Fields (e.g. each Row is a unit of Time like a Week, Month, Quarter, Year, etc. and not the column). The ability to see each unit of Time as a column moving from left to right is standard practice. How was this validated? ...This is a core feature to all spreadsheet applications. Who is the target audience? ...All Users ... View more