Showing ideas with label fields.
Show all ideas
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
Submitted on
Jan 23, 2019
12:01 PM
Submitted by
Aaron
on
Jan 23, 2019
12:01 PM

Title is self explanatory. Would save space and scrolling time for boards with many stacks.
... View more
Status:
New Ideas
Submitted on
Feb 16, 2024
10:48 AM
Submitted by
Danarone
on
Feb 16, 2024
10:48 AM

What is the proposed idea/solution? This idea proposes more dynamic options for scaling, rotating or providing 'hovering information' for text in Field Headings so they are readable when columns are narrow in Grid View and List Views. Currently text very easily becomes truncated and unreadable. Row height helps with field contents but not Field Headings. Hovering only works if there is a Description in the Field. Note: this idea is essentially requesting behavior that you see in most spreadsheet programs. Here is a typical Grid view... When you shrink the columns it looks like this which is too easily truncated and unreadable... Proposed Idea A: Enable hovering context information for all text whether there is a Description in the Field or not. If there is a Field Description it would be displayed underneath the Field Name in the floating context window. Proposed Idea B: Field Names can be rotated (similar to spreadsheets). Maybe 45 and 90 (as shown below) Field Names and all other text scales down to ~6 point before it begins truncating. Like the 'In Progress' text below Overall make the margins in all fields super tight. Field Row Height can be changed so the text wraps and stacks. (Not shown below but you get the idea) ... How does is solve the user problems? Keeps information readable when trying to conserve screen real-estate. ... How was this validated? Not validated yet. ... Who is the target audience? Creators who are trying to show as much information as possible on the screen while keeping information readable. ...
... View more
What is the proposed idea/solution? What's existing is that when clicking the + button on a "Link to another record" column, it shows a "search box" and we can find an existing record, but you can only search for the linked record's value. It would be more efficient to be able to find an existing record using its other parameters (maybe the four columns that are shown). In the example image below, if I type "Notes C" or "1335", it should show Item 3. What's currently happening is I should strictly type "3" or "Item 3" to get to that linked record. It's especially inconvenient if it's a lengthy SKU or something like "A Very Long Title Like This and That Vol. 3" when I could use that linked record's other columns to find it. How does it solve user problems? It allows the user to quickly find a linked record through other parameters and makes workflow more efficient. How was this validated? The first four columns on the find field are the linked table's first four columns too, so if the user wants to "customize" the first four columns, they can trigger "Limit record selection to a view" when making that linked record column to use that specific view's first four columns. Who is the target audience? Users who use linked records a lot with multiple useful columns.
... View more
Submitted on
May 08, 2018
12:00 PM
Submitted by
AlliAlosa
on
May 08, 2018
12:00 PM

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 addresses (including distribution lists) Table EMAIL links to DIST LISTS DIST LISTS contains a lookup field to list the names of people on each distribution list. I am running into this problem: because a distribution list’s members can contain OTHER distribution lists, I cannot get a comprehensive list of all members wherever this happens (which is often). For example (using arbitrary email addresses)… say "info@company.com" has 2 members: john.doe@company.com and hr@company.com "hr@company.com" has 2 members: jane.doe@company.com and jim.doe@company.com. The lookup field will only give me “John Doe” as a name as it doesn’t drill-down another layer to lookup the names under hr@company.com. I managed to set-up a second level of “Sub-Members” with some linking (a bit too complicated to explain here), but it would be so helpful to have the ability to look-up a second layer. I know this sounds complicated - I did my best to try and explain in the most simple way I could!
... View more
Submitted on
Jun 07, 2019
07:41 AM
Submitted by
ScottWorld
on
Jun 07, 2019
07:41 AM

We really would love the ability to AUTOMATICALLY sort the related list of linked records. We know that we can MANUALLY sort the related list of linked records, but we would love the ability to AUTOMATICALLY sort. Oh, and equally important, we’re not just looking for the ability to automatically sort linked records alphabetically. We’re looking for the ability to automatically sort linked records by ANY value in their respective table. So, for example: I am creating a large travel itinerary for a tour company where my main table is “Countries” and my secondary table is “Cities”. I have linked each “country” record in the “Country” table to multiple different “cities” in the “Cities” table. But each “city” record has a start date & an end date, so there is a natural ordering to the cities. The cities can be ordered chronologically by date. In fact, that is the VERY BEST way for cities to be ordered: chronologically by date. Back in the “Country” table, each “country” record is linked to multiple “cities” from the “Cities” table. However, on each “Country” record, Airtable has listed all the “linked cities” in some random order. It seems like Airtable has placed them into a “reverse sort order” of when users added each city to its respective country. But this is of no value to us. We would like the “linked cities” to be listed chronologically by date for each “country”. Other database languages, such as FileMaker Pro, have this ability (to automatically sort linked records) natively baked into the program. It would be amazing if Airtable had this same feature! 🙂 Thanks! 🙂
... View more
Submitted on
Sep 26, 2021
11:43 AM
Submitted by
Santiago_Zindel
on
Sep 26, 2021
11:43 AM

I want to be able to hide the primary field when I am sharing specific views. Specifically I would love to do this in the gallery view but ideally in all views.
... View more
Status:
New Ideas
Submitted on
Nov 18, 2024
03:15 AM
Submitted by
Fabian_0904
on
Nov 18, 2024
03:15 AM

What is the proposed idea/solution? Add a Feature so you can change the background color of cells and whole colums manually or based on condition matching. How does is solve the user problems? Design of Tables and List Views will get more clean and easier to use / navigate. Also Users can color cells based on their content (like positive=green, negative=red, ...) How was this validated? It's basic visual Design theories. Who is the target audience? Nearly everyone, at least every user who needs to navigate through big airtable bases & list views.
... View more
Status:
New Ideas
Submitted on
Dec 04, 2023
03:16 PM
Submitted by
afassero
on
Dec 04, 2023
03:16 PM

What is the proposed idea/solution? ...User is able to select multiple Views. Any changes applied to the first selected View are applied to the other selected Views (e.g. Column Width, Column Order, "Hide fields", "Filter", "Group", "Sort", "Color", "Row Height") How does is solve the user problems? ...Currently the process is manual for each View. This can be extremely time consuming and prone to human error, that can affect Synced Tables. Who is the target audience? ...Users who have more than one View per Table, especially users with a large number of Views per Table.
... View more
Submitted on
Jan 05, 2021
05:03 PM
Submitted by
Adrian_Sanchez
on
Jan 05, 2021
05:03 PM

We use Airtable as a CRM and event management. These uses have been accomplished using separate bases but there’s been a growing desire for this process to be streamlined with an emphasis on leveraging the data already in the CRM. Ultimately, what I’m suggesting is Lookup Fields displayed on a Form View once a Link to Another Record Field is populated.
Here’s a use case: CRM has a Table containing contacts with contact information (phone number, email address, etc.) and a Table for an event’s participants. The participant table has a Form View. The first field/question on the form is a Link to Another Record Field where the registrant selects their name. The next field/question would be a Lookup field displaying the phone number found on the linked record. The next field/question would ask if the phone number was still correct. The next field/question could be a question conditionally visible if the phone number was incorrect. We’d then repeat the process for the other data displayed by the Lookup fields.
... View more