Showing ideas with label formulas and calculated fields.
Show all ideas
Submitted on
Sep 28, 2022
09:09 AM
Submitted by
Joel_Lee
on
Sep 28, 2022
09:09 AM

First, let me start off by saying how incredibly important this feature is. The data so many organizations could have by being able to create custom calculated metrics in Interfaces is untellable. When creating big numbers (like the Numbers widget in an Interface), you are tired to a specific field, then you must select an operator. For example, you tie that Number widget to a field in one of your tables, for example, “Revenue,” then select “Sum” and it gives you the total. Let’s say you did that same thing for “Profit.” Then, with those two metrics, there is no way to create a third one based off those that calculates, for example, something like: Profit / Revenue (displayed as a percentage (Margin)). The problem is that the only workaround to achieve the above (something that is a basic feature in, for example, Google Data Studio), is to build in the Profit, Revenue, and Margin fields at the table level which can fail to work if you are dealing with a metric for which there is no workable operator. For example, you cannot use “Sum” in the settings of a Number widget in an Interface in order to sum up all the “Margin” values in your table. That doesn’t make sense. Long story short, I would love if, in Interfaces, you could calculate your own metrics. The flexibility this would provide would help people who are using Interfaces for basic financial or other number-based widgets, and could give them the insights they need (like the organization I work for!).
... 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
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
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
Submitted on
Dec 20, 2018
01:44 PM
Submitted by
Kamille_Parks
on
Dec 20, 2018
01:44 PM

Right now, to format values pulled from a Currency field in a Formula field, users have to use something akin to the following formula to get “$65,756” to display as such. Otherwise, AirTable displays it as “65756”, no commas, no currency symbol: IF(
LEN(CONCATENATE({Trip Budget}))<4,
{Trip Budget},
IF(
AND(LEN(CONCATENATE({Trip Budget}))>3,LEN(CONCATENATE({Trip Budget}))<7),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
IF(
AND(LEN(CONCATENATE({Trip Budget}))>6,LEN(CONCATENATE({Trip Budget}))<10),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-6)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
IF(
AND(LEN(CONCATENATE({Trip Budget}))>9,LEN(CONCATENATE({Trip Budget}))<13),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-9)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),9),3)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
)
)
)
) This is obviously inconvenient, and it doesn’t even take into account decimals or amounts greater than $999,999,999. I propose a new formula function that operates something like this: CURRENCY([number or field reference], [currency symbol]) => CURRENCY(12345.6,"$") = $12,345.60
... View more
Status:
New Ideas
Submitted on
Mar 13, 2023
03:32 PM
Submitted by
Karlstens
on
Mar 13, 2023
03:32 PM

Button Fields could really use an update to allow for dynamic button labeling. A label could be set to not only Single Line Text, but also support other field types such as Single Select, Link Fields, but also Attachments where an Image could be displayed as a clickable button. Here, we see each button opening a unique URL, however the label is static - locked as the text "Open URL" which is an awful user experience. Why not allow for other fields to be referenced within the Label, exactly how the URL formula works? Part of this issue stems from the URL field itself also being too simplistic, and not supporting text for the referenced URL itself (which then itself could be used by a button field, without the need for an independent Label field).
... View more
Submitted on
May 04, 2020
02:00 PM
Submitted by
Paul_Warren
on
May 04, 2020
02:00 PM

Can you please add comment functionality in functions? This would be a big help when understanding previous peoples work!!
... View more
Status:
New Ideas
Submitted on
Sep 18, 2023
08:30 AM
Submitted by
Andy_Lin1
on
Sep 18, 2023
08:30 AM

I'd like to see a formula function for looking up values in linked records, something like: LOOKUP({Linked Record field}, {Field in linked table}) Basically, a two-criteria lookup similar to "INDEX MATCH MATCH" in Excel without needing to import all the fields from the linked table into the current one. Or just a dot/membership operator in SQL databases. Currently, if I want to fetch data from a linked record, I need to use a Lookup field. This is fine if I want to display the field's values in my table or consistently refer to it in a formula; but if I have multiple fields I want to reference in a single formula, then I would need to add a Lookup field for each of the source fields. This adds an number of extra fields to my base that only serve a single formula field and clutter up my field lists. (Or I would need to do something hacky with the formula, or use scripts/automations.) For example, say I have two tables: Articles and Authors. Articles has fields like Article Author, Article Type, and Article Cost. Authors has fields like Name, Email, and the rate schedule (News Rate, Feature Rate, Review Rate), as below: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: ? Authors Name – Short Text Email – Email News Rate – Currency Feature Rate – Currency Review Rate – Currency Articles Written – Linked record: Articles If I want to lookup an author's email address, I can add a Lookup field and it's a good reference to have for every record in my article table. However, for an article's cost, I only want to see the relevant rate from the author's record. Currently, in order to do this, I'd need to add Lookup fields for each rate because the Formula field can only reference fields in the current table: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: SWITCH({Article Type}, "News", {News Cost}... News Cost – Lookup: Author.{News Rate} Feature Cost – Lookup: Author.{Feature Rate} Review Cost – Lookup: Author.{Review Rate} But now I have three fields dedicated to this one formula. The fields are of no other use in that particular table and are basically clutter that I have to hide in every view. If a LOOKUP function existed, then I don't need those extra fields, and instead my formula would look something like SWITCH({Article Type}, "News", LOOKUP({Article Author}, {News Rate})... This would benefit anyone working with rate cards, inventories, or schedules (or any case where they need to perform a variable-field lookup). Another use case is doing a "deep" lookup, such as getting the country code for a phone number based on a city. Say you have a base with tables Phone Numbers, Cities, Countries; and Phone Numbers are linked to Cities, and Cities are linked to Countries; and {Country Code} is a field within Countries. Because Lookup fields in Airtable only go to one other table (you can't lookup a Linked Record field in another table and get data from that third table), you would have to add a Lookup field to Cities for {Country Code}.
... View more
Status:
Launched
Submitted on
Mar 27, 2019
05:34 AM
Submitted by
DanielAssayag
on
Mar 27, 2019
05:34 AM

I have a condition that Inputs Boolean and outputs Boolean, and i wish to make it appear (format it) as a checkbox and not as a string “true” or “false” IF(Field1 = TRUE(), TRUE(), FALSE()) Thanks
... 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