Status:
New Ideas
Submitted on
Jun 14, 2023
12:38 AM
Submitted by
Tobias_LGKR
on
Jun 14, 2023
12:38 AM

We are currently consolidating our style guide in Airtable. It would be of great help if a new HEX field and a new COLOR field were introduced to use as a design color for fields, text, shapes or backgrounds in interfaces. The new COLOR field would then display the color of a selected HEX field, both in tables as in interfaces. Along that same line it would be great if Admins could define global HEX colors for the entire workspace, so these colors can be used to brand the user experience for everyone. These custom colors would then show up as a custom color list everywhere in Airtable, where colors can be used/selected.
... View more
Submitted on
Feb 23, 2016
07:00 PM
Submitted by
Mike_Eovino
on
Feb 23, 2016
07:00 PM

Please consider adding conditional formatting based on formulas. This is a key feature in Excel and would greatly help in Airtable.
... View more
Status:
New Ideas
Submitted on
Aug 03, 2023
01:01 AM
Submitted by
Ilias_T
on
Aug 03, 2023
01:01 AM

Our beloved platform seems to ignore thousand of users and so we are still struggling with numbers and the use of comma instead of dot for decimals. To do that, we have to literally TRIPLE the number fields. Even though many have asked for it, we still miss printing an interface. Of course they also ignore many users that need a multi page designer !!! These 3 requests are not new! The first one dates back the first years of this platform. They don't even have an answer for that ! They just ignore us I'd appreciate if I could: Have a Global Field for each table Had more possibilities to edit the text in an Interface (for example: align text) Guys if none of these are scheduled to be fixed then I kindly ask the co-users suggestions for other platforms - data bases.
... View more
Status:
New Ideas
Submitted on
Feb 03, 2023
03:24 AM
Submitted by
Karlstens
on
Feb 03, 2023
03:24 AM

I don't understand how both btoa() and atob() methods are supported within the Airtable Scripting App Extension, but not within an Automation Scripting Action. https://developer.mozilla.org/en-US/docs/Web/API/btoa https://developer.mozilla.org/en-US/docs/Web/API/atob Base64 encode and decode is an absolute staple in system integrations. Can it please be included to the Automation Scripting environment? To get me out of a tight spot, I have used the below function to substitute btoa() function btoa(str) {
let characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
let result = '';
let i = 0;
let char1, char2, char3;
while (i < str.length) {
char1 = str.charCodeAt(i++);
char2 = str.charCodeAt(i++);
char3 = str.charCodeAt(i++);
result += characters.charAt(char1 >> 2);
result += characters.charAt(((char1 & 3) << 4) | (char2 >> 4));
result += characters.charAt(((char2 & 15) << 2) | (char3 >> 6));
result += characters.charAt(char3 & 63);
}
return result;
} I think that this is rather unnecessary...
... View more
Submitted on
May 22, 2018
01:36 PM
Submitted by
Jeremy_Oglesby
on
May 22, 2018
01:36 PM

There are several requests floating around the forums related to the need/desire for more formula field functions - mostly related to arrays, linked records, or javascript like functionality.
I’m going to create this #feature-requests post with some of the initial ones that I have posted myself, or have seen in the forums, and I will endeavor to keep it updated with new ones that I find or see posted; and, I will even endeavor to cross them off the list as Airtable implements them :winking_face:
To keep the format clean, I’m going to make a section that lists just the function requested and a brief description of functionality - I think the intention for use and the use-cases should be clear by the structure of the function. This will be followed by a section with links to some of the posts I have seen addressing the need/desire for some of these functions.
Airtable users - If you have an idea for a function that is not currently in the list, post it as a reply here and I will try to add it to the list in this OP if the intention is clear and the functionality seems feasible.
@Airtable_Support, @Airtable_Team, @Katherine_Duh, @Howie, @Kasra - please consider :grinning_face_with_big_eyes:
Functions List
LOOKUP(table, field, linked-records-field)
Lookup field functionality, but can be evaluated within a formula field
ROLLUP(table, field, ROLLUP-FUNCTION())
Rollup field functionality, but can be evaluated within a formula field
ARRAY_DIFF(array 1, array 2)
Takes two arrays (or strings of objects with a separator that can easily be converted to an array) - returns {array 3} which contains all objects from {array 1} that do not also exist in {array 2} (ie, subtract {array 2} from {array 1})
ARRAY_EACH(array, variable, FUNCTION())
Takes an array and a compatible Function - loops over the array and for each object, saves the object in the variable, and allows the user to use the variable in the chosen, compatible, string function (such as SUBSTITUTE() , or FIND() ) or in logical Functions (such as IF() , OR() , AND() ); works like a JS for loop
ARRAY_INTERSECT(array 1, array 2, array 3, ...)
Takes any number of arrays (or strings of objects with a separator that can easily be converted to an array) - returns an array with only objects that exist in every array provided to the function
Links List
Formula Fields: Values Based On Javascript Functions Product Suggestions
This one might be a little bit “out there,” but I think that if it were possible it might address a number of requests for additional functions supported by Airtable’s Formula Fields…
I’m wondering if it might be possible support Formula Fields whose values are based on the result of some ad-hoc Javascript function. For example, the user might specify other Airtable fields as the Javascript function’s params, specify the JS function itself, and have the Formula Field’s value reflect the result. …
Array intersect formula Product Suggestions
I have 2 tables, and I need a result that shows only inputs that are the same in both tables.
Hence, to compute the intersection of a number of arrays.
array intersect ( array1, array2 [, array#… ] )
Returns an array containing all the values of array1 that are present in all the arguments.
Where:
array1
The array with master values to check.
array2
An array to compare values against.
…
A variable list of arrays to compare.
Any workarounds at this point?
Comparing two arrays and remove values that appear in both Product Suggestions
Hi airtable!
I have a list (an array) of items in two columns. Each row represents two different lists (one in each column). I’d like to be able to compare the two columns and remove what is common in both. For example
Row 1:
Column 1: Apple, Orange, Pineapple, Kiwi
Column 2: Apple, Kiwi
Result: Column 3: Orange, Pineapple
Row 2:
Column 1: Banana, Orange, Grape, Kiwi, Pineapple, Passion Fruit
Column 2: Orange, Grape, Pineapple
Result: Column 3: Banana, Kiwi, Passion Fruit
etc.
The …
Look-Up from a Look-Up Field Product Suggestions
A very useful feature to have would be the ability to “drill-down” another level when working with Look-Up fields.
We use AirTable to manage our company E-mail accounts and Distribution Lists (Distribution Lists are email addresses that contain members and distribute messages to all who are assigned to it, i.e. info@company.com can go to John, Mary, and Paul). Here is the basic set-up between 3 tables:
Table PEOPLE contains a list of all employees, and links to EMAIL which contains all email a…
How can I make a lookup field show only unique results? Ask the community
The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?
Dynamic (calculated) link to a record in a linked table Ask the community
How to create a dynamic (calculated) link to another table?
There is a Table#1 (Daily Expenses) [ID, Date, Sum, subject,MonthNo].
Where MonthNo=MONTH({Date})
There is a Table#2 (Months of the year) just as follows:
MonthNo MonthName
1 January
2 February
3 March
etc.
Linking Table#1 to Table#2 will allow me to calculate monthly expenses directly in a Table#2 by means of Lookup(Sum) function.
How can I do this? If I choose a standard Link field then every time later I will have to select…
COUNTIF AND COUNTIFS Formulas Product Suggestions
It would be great if the COUNTIF and the COUNTIFS formulas were implemented in Airtable. I use them in most of my excel spreadsheets, and it is a little frustrating not being able to use it here. Are there any plans to add more formulas?
Support lookups and references/links within formulas Product Suggestions
First off, Airtable is great! One thing though: I’d really like to not have to create additional columns in order to simply do something like the following:
Formula:
if(lookup(row_10,"column_1"),lookup(row_12,"column_4"),lookup(row_53, "column_2"))
Also, I have a lot of varied data and I’m trying to use one big table for everything with lots of different views rather than use lots of different tables with aggregate tables and views based on those smaller tables. I can link to a row within the…
... View more
Submitted on
Jul 07, 2020
02:31 PM
Submitted by
ScottWorld
on
Jul 07, 2020
02:31 PM

2024 update: Even though Airtable eventually added this feature, all of this is possible in a MUCH easier & much more customizable way with Fillout’s advanced forms for Airtable. Fillout’s advanced forms for Airtable are 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to conditionally hide fields on a form, update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more. ————- Old post from 2020: Not sure if this is a bug in Airtable or just a missing feature, but we really need this feature. Airtable needs the ability for us to have hidden fields on forms that will submit data upon form submission. Currently, Airtable doesn’t accept the values from any hidden fields. Here’s the situation: My clients are currently having difficulties with Airtable forms, because prefilling fileds on forms (using the “?prefill_fieldname=” syntax) only works if the fields that you’re prefilling are actually visible upon submitting. We’re trying to prefill hidden fields on the form that we’ve hidden using Airtable’s brand new conditional field feature for forms. So we’ve hidden a bunch of fields (using fake values that will always result in false). We’re forcing these fields to be hidden. These hidden fields actually get their prefilled values filled in correctly! How do we know this? Because if we type in the fake values to “show” these hidden fields again, the prefilled values are visible! The prefilled values are right there! But — the only way to get these values to be added into our Airtable database upon form submission is to keep the field visible. If the field is hidden, Airtable won’t submit the value into the base, which then defeats the purpose of having a hidden field to begin with. Thanks!
... View more
Status:
New Ideas
Submitted on
May 24, 2023
12:09 PM
Submitted by
Jared_Wright
on
May 24, 2023
12:09 PM

What is the proposed idea/solution? ...Summary: I want more control if you are going to have this feature let me add my own values and use it or not use it if I want to. Rename what records are called for each level - To rename what each record in a List view is called (i.e. "Task" vs. "Record") use the customized terminology feature. Reasons why I like it: I like it because it is useful to see the context change for each record in each table based on what kind of record is contained in it. How does is solve the user problems? ... Reasons why I don't like it: I don't like it because I don't have control over what I call records I don't want to pick from a pre-built list I want at least to add my own value and not be forced to use the list that I am given. I use field names that really help me identify what table I am using and if I can't use the unique field name that I create then it makes it hard to know what field is being used. What do I do if I have two tables where the records are called the same thing how can you tell them apart?
... View more
Submitted on
May 13, 2021
10:43 AM
Submitted by
Jack_P
on
May 13, 2021
10:43 AM

I would love the ability to reshuffle and group Automations. I often have 10-20+ automations in one Base and they are created at different times. It would be a great help if i could organize them in a chronological, or dependant, order as i add automations to the list. Currently if i create an automation that is the 2nd to trigger in the base but i created it months after the others that already exist, it sits at the bottom of the list and makes it very difficult to remember which Automation triggers in which sequence. (I currently have a stack of 6 automations that trigger one after another but are all jumbled in the Automation tab)
... View more
Status:
New Ideas
Submitted on
May 23, 2024
02:43 PM
Submitted by
Allen_Douglass
on
May 23, 2024
02:43 PM

What is the proposed idea/solution? ...NEED a smartdocs field like google docs, box notes, notion pages etc How does is solve the user problems? ...Endless How was this validated? ...Every other solution has it Smartsuite, google docs, box, dropbox, Notion etc etc etc Who is the target audience? ...Literally everyone
... View more
Submitted on
Jun 16, 2021
05:52 PM
Submitted by
Tim_Heymans
on
Jun 16, 2021
05:52 PM

To get an overview for long-term project planning, a “Year view” in Calendar is needed. Gant charts aren’t usable for my usage case because every task needs to be on a different line. This way, information is scattered and I can’t get a decent overview. (If grouping items on a gant chart didn’t merge all of the different subitems into one big blurp but kept different tasks with their start and end dates on the same line… Yes, then it would be useful, then it would be great. - But that’s for a different feature request. Let’s stick to a Year option in Calendar view as for now. Easy to implement, so…)
... View more