Showing ideas with label formulas and calculated fields.
Show all ideas
Status:
New Ideas
Submitted on
‎Mar 17, 2024
10:35 AM
Submitted by
Jonathan_Culley
on
‎Mar 17, 2024
10:35 AM

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
Status:
New Ideas
Submitted on
‎Apr 05, 2024
03:16 AM
Submitted by
hubkei
on
‎Apr 05, 2024
03:16 AM

What is the proposed idea/solution? An extra Action for the Button Field inside a table (not in the interface), where we can select "Run an Automation" How does is solve the user problems? At the moment there is no direct way to run a simple automation from a button field. it only works on buttons in interfaces. How was this validated? The press of the button should also "pass" the record ID to the automation, so any automation ran can use the record ID to specifically work on a record. Who is the target audience? This is useful for everybody who wants to use the button field in day to day simple operations.
... View more
Status:
New Ideas
Submitted on
‎Jan 03, 2023
03:39 PM
Submitted by
Karlstens
on
‎Jan 03, 2023
03:39 PM

What is the proposed idea/solution? Reading through the available rollup field formulas, I'm surprised there's no Mode() or Median() available for use. https://support.airtable.com/docs/rollup-field-reference How does is solve the user problems? Mode and Median are a staple in 6th grade mathematics, and I can't even begin to summarise how they solve countless user problems that they're used for. The target audience is anyone working with a rollup field wanting to quickly extract mode and medium data from their linked record array. In my current example, I have a Rollup containing several dates, and I need the most common date - IE, the mode(values) needs to return the date that occurs most often within the array. mode(["2023-01-09" , "2023-01-09", "2023-01-08" , "2023-01-09"]) returns "2023-01-09", similarly how max() returns 2023-01-09 and min() returns 2023-01-08. So importantly, Mode() needs to work not only on numbers and integers, but also dates as well - or possibly even strings. For example, a Rollup mode(values) of ["Dog", "Dog", "Dog", "Cat", "Dog", "Cat", "Cat", "Dog", "Mouse"] returns "Dog".
... View more
Status:
New Ideas
Submitted on
‎Feb 14, 2024
01:55 PM
Submitted by
Drew_Nemer
on
‎Feb 14, 2024
01:55 PM

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
Status:
New Ideas
Submitted on
‎Dec 04, 2023
04:16 PM
Submitted by
afassero
on
‎Dec 04, 2023
04:16 PM

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
Submitted on
‎Nov 26, 2019
01:25 PM
Submitted by
Christian_Hudon
on
‎Nov 26, 2019
01:25 PM

I’ve searched through the forum, and saw multiple posts about this with no answer, so I assume this is not supported currently. Hence the feature request.
Basically, I want a way to sort an array. One example use case is with ARRAYUNIQUE(). Currently, the ordering of the array returned depends on the order of the rows in the table. This is not a very desirable property for a rollup column meant to summarize a set of values. If there was a SORTED function, I could call that and make sure the value in my summary column didn’t depend on the order of rows somewhere else.
Please consider adding a SORTED() function. Thanks.
... View more
Status:
New Ideas
Submitted on
‎Jun 06, 2023
09:55 AM
Submitted by
Danarone
on
‎Jun 06, 2023
09:55 AM

What is the proposed idea/solution? A Project Archive Feature to make it easy to 'deactivate and hide a project when certain criteria are met. An archived project would be grayed-out, hidden completely everywhere in the base or moved into an Archive Table. It would no longer affect any rollups or calculated fields. To make it active again, the user goes to Archive settings, click 'Show Archived Projects' then changes the criteria back to active. How does is solve the user problems? Current solutions only hide the project from view. it is still active and you need to consciously filter it from view everywhere in the base. Or you need to manually copy the project to an Archive table and delete from active which is tedious. How was this validated? No validation has been performed. Who is the target audience? Project managers with multiple projects that have a lot of fields/data. Their organization is known to pause or cancel a project and re-activate it again at a later date. Or they simply want to save old projects for reference.
... View more
Submitted on
‎Aug 20, 2019
05:57 PM
Submitted by
Zollie
on
‎Aug 20, 2019
05:57 PM

Google sheets already supports this, whereas Excel does not. Airtable would be wise to follow Google’s lead. Or leapfrog them both and add a ton of array functionality.
... View more
Status:
New Ideas
Submitted on
‎Oct 09, 2023
10:31 AM
Submitted by
DaxAlexander
on
‎Oct 09, 2023
10:31 AM

What is the proposed idea/solution? I'm trying to use an interface to present financial information; however, numbers are left aligned in list view and there is no option for totals. Even columns that are right aligned in Grid view are left aligned in List view. Can this be corrected so that it allows the option to right align? How does is solve the user problems? It will allow us to use list view for financial information in a way that is more intuitive to users. How was this validated? ... Who is the target audience? Everyone and anyone that looks at financial information in a list view or interface.
... View more
Status:
Launched
Submitted on
‎Oct 22, 2018
02:19 PM
Submitted by
Katherine_Duh
on
‎Oct 22, 2018
02:19 PM
UPDATE 2: last modified time is now available to everyone! You can learn more about it here. UPDATE: The last modified time beta is now closed as we get ready for a general release. Thanks to all of the testers who made this beta a success. ORIGINAL POST: Hi folks! We’re very excited to announce that we’re beta testing a last modified time field type, as well as a LAST_MODIFIED_TIME formula function. Many thanks to the users who’ve posted specific, detailed feedback about their needs and use cases with regard to this feature, like @Arlo_Haskell, @Deborah_Buck, and @Jordan_Friedman. We read everything that is posted here in the forums and your feedback is incredibly valuable for us when we’re planning the product roadmap and developing new features! If you’re a Pro plan user and you’re interested in testing out the last modified time field type and/or the LAST_MODIFIED_TIME formula function—and giving us your feedback—please sign up using this form. (Note: this is a different form from our standard beta signup form, and it requires you to fill out a couple of additional questions.) As you are all aware, this is a highly anticipated feature, and there are many users who would like to get beta access. However, for technical reasons and to ensure an optimal user experience, rollout for this beta will be conducted in small, limited batches. (In practical terms, that means that it might take a while for you to get access.)
... View more