Showing ideas with label formulas and calculated fields.
Show all ideas
Status:
New Ideas
Submitted on
Jan 12, 2025
04:12 AM
Submitted by
Frite666
on
Jan 12, 2025
04:12 AM

With Rating being a type, it should be possible to format look up and formula into a directly into Rating. Right now this is not possible, without the use of Automation even so a rating is a disguised Number. Adding this functionnaly would help application that have to deal with things like community ratings. Because a Rating is Number between 0 and a max rating, the resulting value in a formula should be clamp with 0 as the min and the max rating as the max.
... View more
Status:
New Ideas
Submitted on
Jan 09, 2025
08:02 AM
Submitted by
ThesianMarcus
on
Jan 09, 2025
08:02 AM

What is the proposed idea/solution? A new View Type that "freezes" records filtered into it so that its data, including formulas and perhaps other dynamic fields, no longer update but provide a snapshot of the record at the time it was "frozen". Records in the view can get ignored by API queries making automation and actions faster too. How does is solve the user problems? Improves Base performance because the system doesn't needs to constantly update formulas or check dynamical filtering conditions on records that are not in use. Reports can still be generated on this data without needing to copy the data from dynamic fields to text only duplicates of the field or duplicating entire records to another Archive/Reporting table or external source. Who is the target audience? Enterprise customers and users with large datasets.
... View more
What is the proposed idea/solution? ...Enable Arrayunique to be used on text fields with spaces How does is solve the user problems? we cannot use Rollup to retrieve just the unique values when the field is a concatenated field with spaces. If this was addressed, then a rollup with arrayunique(values) can be used on concatenated fields (most primary key fields are concatenated) How was this validated? ...Tried it on a text field with spaces and it did not work. Who is the target audience? ...Creators
... View more
Status:
New Ideas
Submitted on
Dec 13, 2024
06:56 AM
Submitted by
Martin_Malinda
on
Dec 13, 2024
06:56 AM

Airtable already depends on pre-defined formatting. And to certain degree formatting is configurable. Some fields might have different `actual value` and `presented value` by default - for example the datepicker, duration or percentage field. This is great! It makes the field both user friendly and well usable within automation and scripts and filtering, sorting. I think it would be awesome if this pattern would expand further: Often we're using formula fields. To some degree there's a possibility to format the formula field: as number, currency or even map it to single select options. What if in the formatting tab, there would be an option for "formula"? Then you can define your own custom way to format your value. Examples: Formatting difference values as `+5%` with the `+` included. (Price difference) Custom date formatting via DATE_FORMAT (but the underlying value is still date) Custom duration formatting Units visible directly in the cell (200 m²) Custom number formatting (using both K, M as needed... 100K, 200M) Formatting dependent on other fields! $200 in one record, €200 in another, based on the picked currency in the Currency single select field Custom labels for Urls and buttons! The button CTA could be different based on other fields but the link is defined. `Open 'SKU123' in Admin` or `Delete John Doe in X` (as opposed to Delete User). I think this little thing could improve a lot of QOL improvements. And you would not have to have special `formatted` formula fields. Values would display nicely and at the same time you could also practically work with them in automations and scripts. The main downside? It could be confusing to someone that they are entering a value but the underlying formula then transforms it differently. For example you enter "3" and it shows up as "0.03%", depending on how the author designed the formatting formula. But I still believe this would be a net positive feature 🙏
... View more
Status:
New Ideas
Submitted on
Nov 27, 2024
01:53 PM
Submitted by
smullin
on
Nov 27, 2024
01:53 PM

Hi, I'm super excited about the new date dependency features. I've manually implemented that before with automations. However, limiting the precision to "days" seems arbitrary and limits the functionality to project management. Increasing the precision to minutes or seconds (or whatever the standard is for dates) would vastly improve utility for things like batch scheduling. Cheers, Scott
... View more
I'd love to be able to designate universal variables that could be referenced from any table in a base. So, for example, if I have a sales tax rate of 8%, I'd like to set that sales tax rate in one single place and then be able to reference that in formulas across the entire base. Currently, if I want to set up this type of variable, I need to 1) create a table of variables then 2) make sure every single record in the other tables is linked to the variables table 3) add a lookup field to every table that looks up this universal variable 4) create a formula which references this variable in the lookup field. For each universal variable, one should be able 1) give it a unique name that could be referenced in formulas across the entire table 2) set a data type (number, currency, percentage, etc) Then, if the sales tax rate changes, I just update the reference variable, and the changes propagate to all the formulas in the base that reference it. It's true that this could be done with manual copy paste or automations, but that's a LOT of work or automations for a very basic bit of functionality. It could easily eat into an automations cap on an AirTable plan. I imagine that it is pretty easy to script for someone who knows how to code, but that's a lot of work (or vendor cost) just to set a variable. I'd love to be able to tell AirTable: "I'm creating a universal variable called "SalesTax". It is a percentage variable." Then enter the number 8% and be done.
... View more
Status:
New Ideas
Submitted on
Oct 03, 2024
11:09 AM
Submitted by
JackLathrop01
on
Oct 03, 2024
11:09 AM

I assume this is a popular request but I think ELIF functions would be very helpful in making functions easier to write. Nested IFs can get cumbersome and the alternative SWITCH can be difficult given a large set of possible values. Converting single and multi select fields into a logical format would be much simpler using ELIF. This would likely also generally reduce the need for dummy fields used for steps in a larger function. I find the select fields to be very useful for users and would like to be able to run automations and calculations via select fields but it seems more difficult than necessary. I think ELIF would reduce the complexity.
... View more
Status:
New Ideas
Submitted on
Oct 01, 2024
03:02 AM
Submitted by
SamGluck
on
Oct 01, 2024
03:02 AM

What is the proposed idea/solution? Currently we've got the option of formatting a formula field as a single select, I'd like to format it as a muliple choice How does is solve the user problems? I'd use this feature for labeling records with what fields still need to be filled. Lets say the Name and Email fields are empty, it would show at the top of the record red labels of what information still needs to be filled in the record, and as you enter the info, the labels disappear. Yes you can use automations with a script for this, but it doesn't work instant. it takes 10-15 seconds per run. using a formula would be instant.
... View more
Status:
New Ideas
Submitted on
Sep 27, 2024
10:34 AM
Submitted by
slauden
on
Sep 27, 2024
10:34 AM

I would like to be able to tell the top 5 selected items — I'm missing the ability to tell what row number an item is in/how many rows there are in a table.
... View more
Status:
New Ideas
Submitted on
Aug 23, 2024
01:19 PM
Submitted by
Dennis_Petrou
on
Aug 23, 2024
01:19 PM

I know we can alphabetize all the options in a Multi Select field, but the field itself will display all the entries in the order in which they were selected. That should be an optional toggle, to let it display as it does currently or also alphabetically. When looking at many records at a time, and trying to compare values in a Multi Select field, it makes it very messy and difficult.
... View more