Showing ideas with label formulas and calculated fields.
Show all ideas
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
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
‎Feb 16, 2024
09:29 AM
Submitted by
Danarone
on
‎Feb 16, 2024
09:29 AM
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
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
‎Feb 14, 2024
11:00 AM
Submitted by
Ringthebells86
on
‎Feb 14, 2024
11:00 AM
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
Status:
New Ideas
Submitted on
‎Jan 18, 2024
07:43 PM
Submitted by
dk82734
on
‎Jan 18, 2024
07:43 PM
![7 - App Architect 7 - App Architect](/html/@A5FC3CBAAE60D538F9A953E47A560077/rank_icons/Rank-AppArchitect.png)
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
Status:
New Ideas
Submitted on
‎Jan 02, 2024
09:05 AM
Submitted by
Ringthebells86
on
‎Jan 02, 2024
09:05 AM
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
Status:
New Ideas
Submitted on
‎Dec 20, 2023
09:39 AM
Submitted by
afassero
on
‎Dec 20, 2023
09:39 AM
![6 - Interface Innovator 6 - Interface Innovator](/html/@781FA7B006C69ED0612A0090F8465157/rank_icons/Rank-InterfaceInnovator.png)
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
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
Status:
New Ideas
Submitted on
‎Nov 28, 2023
08:37 AM
Submitted by
g4knr99
on
‎Nov 28, 2023
08:37 AM
![5 - Automation Enthusiast 5 - Automation Enthusiast](/html/@8E0586A35C6D0D07EA6A610CF7AEF6BF/rank_icons/Rank-AutomationEnthusiast.png)
The current grid view summarisation options are great, but we need the summaries to calculate the combined values when using formula fields. E.g. Each record calculates a % using two number fields. The summarisation doesn't give the total combined % but rather a sum, average, or another inappropriate function.
... View more