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
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
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
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
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
![11 - Venus 11 - Venus](/html/@A055A40C6B52EB6DE6B5684057669E1E/rank_icons/Rank-Venus.png)
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
![8 - Airtable Astronomer 8 - Airtable Astronomer](/html/@8B0B6143080A349E4F5B6E12C21C6051/rank_icons/Rank-Astronomer.png)
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
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
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
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
![10 - Mercury 10 - Mercury](/html/@3E2B981D004C65386E7C71F08391F0C2/rank_icons/Rank-Mercury.png)
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
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
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:
New Ideas
Submitted on
‎Apr 05, 2024
02:27 AM
Submitted by
Tecky_x
on
‎Apr 05, 2024
02:27 AM
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
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