Showing ideas with label formulas and calculated fields.
Show all ideas
Submitted on
Oct 14, 2022
10:50 PM
Submitted by
MidnightLightni
on
Oct 14, 2022
10:50 PM

One of the aspects of working with blockchain-type data for cryptocurrencies is that the values recorded have a large number of decimal places. Bitcoin has 8 decimal places, and so just barely fits within the max number of decimals Airtable allows. However, Ethereum has 18 decimal places, and many of the tokens built on that infrastructure followed suit, and have very high number of fractional decimal places. Many spreadsheet applications max out at 15 significant digits for numbers, and so are hard to work with Ethereum values that use that full spread. Since Airtable has such a robust API system, I experimented with using it to solve some of these issues and here are the pain points with that: Because the “Number” field cannot go up to 18 decimal places, a “Single line text” field format is needed instead. Using a base that has a Date column and a “Single line text” field, an outside script (capable of high-precision math calculations) can create “running total” values fairly well. However, in displaying those values, it then becomes a problem of alignment: if a base has values of: 0.12345 12.5454555 1.7 7235.3 0.000111222333444555 (a mix of number of digits left of the decimal point, and right of the decimal point) Then when they’re all left-aligned (as Airtable columns are, and how this bulleted list appears here), it’s very hard to see which numbers are bigger at a quick glance. If Airtable allowed text columns to be displayed right-aligned, then each of those values could be padded to make them align nicely: 0.123450000000000000
12.545455500000000000
1.700000000000000000
7235.300000000000000000
0.000111222333444555 Alternatively, if the Number field were able to go up to 18 decimal places, that would be even more beneficial (and able to do math on cryptocurrency values right within the UI as a formula), which would set Airtable apart from other spreadsheet tools which are limited in that regard.
... View more
Submitted on
Jul 19, 2022
05:40 AM
Submitted by
Adam_Hodson
on
Jul 19, 2022
05:40 AM

I know that something like this would be possible by creating two columns, one for the raw data and one for a formula to transform the data. That being said, it would be great to be able to create a “Transformation Field” that would operate similarly to a Function field. The function would receive the cell data directly, and transform it into the desired formatting for the cell. For example, you could paste in a URL that would then be run through a REGEX function to strip away everything except the root domain itself.
... View more
Submitted on
Apr 07, 2022
01:04 PM
Submitted by
TroyTessalone
on
Apr 07, 2022
01:04 PM

System Field or Formula Function to Indicate Record Created Method (Manually, Form, API, Automation, Interface, etc.) Similar to Autonumber, Created, Last Modified, etc. OR Formula Function to use in a formula (e.g. Created Method) Can see this info in the Record View - Activity Log, but no real way to use these data points. ‘Created By’ shows “Anonymous” as the User when a record is created via a Form.
... View more
Submitted on
Feb 11, 2022
03:02 AM
Submitted by
Mireille_Dode
on
Feb 11, 2022
03:02 AM

When you group rows in a grid view, you can select how each column will be summarized. When selecting the “Average” or “Median” summary, the format of the summary is the same as the format of the lines being summarized. If my column is a “Count” from rows of another table, then they are an integer, and my summary is an integer too. This is not helpful in my case, as my real average is 2.54. I don’t want to see 3. I worked around it by creating a formula column that is equal to the Count column, setting the format as decimal, and then using it for my summary.
... View more
Submitted on
Dec 19, 2021
10:38 AM
Submitted by
itoldusoandso
on
Dec 19, 2021
10:38 AM

In the Last Modified Time formula you can watch for changes in selected fields. I wish I could also add a condition filter to only watch for changes in the selected field if there is a value match. I know I can do that via an additional separate field that will have a match-type function and then watch for changes of this field using the last-modified-time field… But it just ads unnecessary fields in Airtable. If Last Modified Time formula can do that, it eliminates need for the extra field. With number of fields in Airtable limited to 500 fields, saving every field counts.
... View more
Submitted on
Oct 11, 2021
05:04 PM
Submitted by
Rebecca_Elam
on
Oct 11, 2021
05:04 PM

just a column that has the excel/google sheets equivalent of the airtable formula for the people migrating to have a more seamless transition. something that says 'if this is what your formula in excel looks like this is the formula you need to use in airtable. or @kuovonne is this something that could be an app? or even included in readymade formulas
... View more
Submitted on
Sep 06, 2021
06:05 PM
Submitted by
Jeremy_Chevalli
on
Sep 06, 2021
06:05 PM

This would be insanely valuable — show only records where a SPECIFIC FIELD was edited within the last two days, weeks, etc. Just like how date filters currently work:
... View more
Submitted on
Jul 05, 2021
07:32 PM
Submitted by
Sho_Nitta
on
Jul 05, 2021
07:32 PM

Related to this (# Changing Displayed Field in Calendar View and/or Display Value of Field ) topic, how about creating a View detection function that can be used in the Fomula function? I thought it would be nice to have this function so that the title could be changed depending on the view.
... View more
Submitted on
Feb 21, 2021
02:04 PM
Submitted by
ScottWorld
on
Feb 21, 2021
02:04 PM

It has come to light that the VALUE() function is broken.
The VALUE() function is supposed to extract numbers from a string. It’s designed to be used as a simple filtering tool to remove non-numbers from a field. This is how it is documented on the formula field reference page: Formula field reference – Airtable Support
Instead, the VALUE() function does at least 2 completely different things:
The VALUE() function converts certain letters into numbers, and then multiplies those numbers by the closest numbers that it can find! This issue is documented here: Value Formula Returning Numbers not Found in Cell - #2 by CT3
The VALUE() function interprets certain symbols as operators to perform math on all the extracted numbers from a string. This issue is documented here: Interesting discovery: The VALUE() function performs math
We do not know what the complete list of letters & symbols are that cause the VALUE() function to fail, so there is no telling how many different ways this function can fail.
In my opinion, everybody should avoid the VALUE() function. Or at the very least, proceed cautiously when using it.
This comes right on the heels of me losing a lucrative Airtable client because Airtable has not fixed its mobile views. My client’s website depended heavily on Airtable-embedded views — and they charged their clients to access those pages — BUT most of their clients used mobile devices to browse their website (as do the majority of people using the Internet).
But, despite many posts in the forums about this for several years, Airtable still does not offer grouping, filtering, sorting, and searching on any mobile views. So it rendered his website unusable to his clients.
My client even emailed Airtable Support about this, and their response was: “We can see how fully-functional mobile views could be helpful. Thanks for the feedback.”
Airtable thinks they’re filling a bucket with tons of customers, but they’re not paying attention to the hole at the bottom of the bucket which is leaking customers & causing people who were once fans of the product to badmouth the product instead.
... View more
Submitted on
Dec 24, 2020
12:40 PM
Submitted by
Greg_Jarmiolows
on
Dec 24, 2020
12:40 PM

I don’t want to rollup and I don’t want to use string lengths to count array elements. Just give me a real count() function. Bonus points for allowing me to cast a string into an array.
... View more