Ask the Community

first off: recurring issue: where can i report bugs?the record history seems to give wrong information when the change in the record was an addition of a linked record. the record history should say "[USER] created this ['record' or custom name for record as per table settings]" but it does not respect the table settings of the related table and does not use the custom name of the record of the linked table.i.e. i have two linked tables, one called "products" and one "sales". the tables are set up so that records in the "products" table are called 'product' and in the sales table are called 'sale' (for example in the footer of the table when summing up etc).when i create a record in the sales table say 'sale #5239234' related to say the record 'GREEN APPLE' on the product table, the record history of that 'GREEN APPLE' records should say "[User] created this sale" and display the change in the link-field. instead it says "[User] created this product", but i created a sale related to a

DEAR ALL,Column type "link to another record" with "Limit record selection to a view"✔️When you try to select a value manually, the list is OK⛔When you copy/paste a value which is not in the list/view, it works ! Why ?BR

Hi all, I’m a social media manager. I have a base which links together editorial content with associated social posts. It makes amazing things like this possible: Now, I’m trying to create a fully automated UTM parameter system which collects data from various linked records — such as linked web content, associated campaign, etc — and spits out a single URL with appended UTM parameters for tracking in Google Analytics. I’ve got most of it figured out. One step remains: how to extract part of a string. In this case, everything found AFTER the final “/” in a given field. Here’s what I mean. I’d like a formula which scans this text, finds the final “/” in the string, then spits out everything AFTER that: Here’s my current, incomplete formula: Could I do this with RIGHT()? Any help is much appreciated! Thanks in advance. :blush: Best, Alex

Hi,i am creating 3 tablesINVENTORY, SUPPLIER, PRICEINVENTORY contains every items SUPPLIER is just supplier namePRICE containsLinked table INVENTORY, linked table SUPPLIER, currency field.thefeore i have:SupplierA ProductA usd10SupplierB ProductA usd9 I want to design my INVENTORY table so that i can see the min price with the corresponding supplier. I did rollup the price and it is easy. How about the corresponding supplier? How do i rollup this?Thanks

Hi all, I’m currently trying to set-up a pie chart via Airtable’s ‘Blocks’ function. Is there any way to choose my own colour for each of the segments? The default colour scheme that my pie chart is using is completely contradictory from the labels of each of my segments - and I can’t find a way to change it. Any ideas? Thanks in advance. Cheers, Mark

I have a summary table that is comprised of a single row with a linked field (projects) containing multiple values, then a series of rollups with $ calculations based on project status back in the project table.I would like to automate the addition of new projects to the summary table linked field when projects are created in the primary table, and also automate the deletion of those linked field values when projects are completed.I'm unsure how to best accomplish this in an automation. Are there any suggestions?

Hello,Can anyone help me?I'm trying to get the data from Airtable by using this scripthttps://github.com/sleiman/airtable-phpHere's the code<?phprequire 'vendor/autoload.php';$apiKey = 'tokenFromAirTableMyAccountSection';$database = 'AirtableTest';$tableName = 'Data';use TANIOS\Airtable\Airtable;$airtable = new Airtable(array(    'api_key'   => $apiKey,    'base'      => $database,));$request = $airtable->getContent( $tableName );do {    $response = $request->getResponse();    var_dump( $response[ 'records' ] );}while( $request = $response->next() );after all that I'm just getting NULL.Any help would be much appreciated.Thanks.

I am in Real Estate and have created at table for all my transactions.  Some date fields are calculated based on a formula.  For example, a Loan Application is due x# of days after contract date - it can vary based on the contract.  I am creating a template that lists tasks based off that calculated date.  I create the template and choose a relative date but the calculated date is not listed, only dates that are manually entered (vs. calculated) are showing.  Does anyone have any suggestions on how to accomplish this?  

Hello everyone, I have a data base with activities wher date and time are fulfilled but I would like to show only the hour in one column.I'm unable to display what i want. I have for example one column with ISO 14/12/2023 1:52 and i would like two different columns with 14/12/2023 and another one 13:52 Thank you for your help !

Hi, Seeking help here.. I need a formula in the Client name cell where in it will only show the client name if either of the Client or Brand columns has a name on it. Meaning if the Client cell has a name the Client name formula will only show "Path Social" and if the Brand name has a name on it "ThingTesting" it will only show in the Client name cell 

So if you have an Airtable Enterprise account and issue personal access tokens (PATs) tied to a service account.  Apparently, once you create 100 PATs, the interface WILL NOT let you issue any additional PATs tied to that service account:Honestly, this seems very arbitrary.  The workaround is to create *another* separate service account to issue new PATs, but this seems very, very janky.I don't understand why Airtable gates the max number of PATs per service account to 100 total, but it is what it is.  This is mildly annoying.  FYI. 

I have a script that has been working for over a year, but now will not update records.  I sync a table from another base to a second tab in main base.  I then use the following script I was given over a year ago (can't remember where I got it).  It has worked great to look at the synced tab to see a unique ID (emp #) and then pull that onto the main table and pull multiple records from the syned tab.  Now when I run it the script runs super fast and doesn't update anything even though I have matching Unique IDs.Here is the script I am using://Substitute "Orders" for table name which contains values//on which you want to run the vlookuplet mainTable = base.getTable("Covid LOA");let mainTableRecords = await mainTable.selectRecordsAsync({fields:["emp"]});//Substitute "Product" for table which contains range to searc

Hello! I'm trying to create an email automation to go out to my team on a weekly basis that would display our top three social media posts by engagements within a certain timeframe. I've figured out how to set up the email and created a view filtering for that timeframe and sorting by engagements. I've seen there's not really a way to limit a view to a certain number of records automatically, but I wondered if anyone had any workarounds or ideas for setting up this email to go out without the entire list having to go out each time and without me having to go in and manually change something in order for the email to go out? Tall order, but appreciate any help.

Hi, I'm pretty new to Airtable and currently just exploring if it will be viable for our company to use. The set up I have is two tables, one for learners and one for workshop sessions.  The sessions table has names etc and a field linked to the learners table that shows the attendees booked on the session (multiple select allowed). The learners table has a similar field linked to the sessions table showing the sessions that they are booked on to (again multiple selections allowed). What I would like to be able to do is have a new field on the sessions table that for example shows the attendees that did not show up (nothing fancy I would just use a linked field to the learners table and just input the learners manually, again multiple select allowed). But then I want a corresponding field on the learners table showing the names of sessions they have not attended, is there a way to populate this with the session name (stored on the sessions table) based on the d

Hi, I'm currently on a free plan with five editors. We are considering upgrading to the Premium Team plan. But wnat to clarify if $20 a month means we can retain our five editors from the freemium plan. 

I am a solo lawyer but I collaborate on some of my cases with other lawyers.I need to be able to see all of my cases in one place, but I need to share information with the other lawyers only for the cases that they are involved with and they need edit-level permission.  “Views” are not sufficient to share information in a usable format, so I have created “interfaces” to do that.  The problem is that interface sharing seems to require base-level collaborator access, but all of the cases are currently in one base and based off one master table with several related linked tables for specific things.Under this arrangement, some of the data for cases that are not associated with a given collaborating lawyer may be visible to those nonaffiliated lawyers, but it is impossible to know or to control that easily.I don’t know whether to divide the cases into bases according to the co-counsel or not.  If I did separate the cases into separate bases, I would still want to have one in

Hi, I have a client that uses an app working on a Firebird database. I'd like to develop new tools using airtable, connecting to the Firebird DB to extract data. How can I do it?Thanks! Frede

Hello guys,I'm trying to create a formula for the main Name field on my table.I just can't do it, I'll be more than glad to write here the details and if someone can write the formula for this it will be great, and i will also learn that way how to create one in the future.My table is data from the computer inventory list in my office.I want the Name field to first start with the "User" field (the field type is "Link to another record" ) and after that it will have one space and then a Comma and then another space before the next field.Next I want the "Model" field (Single line text) and after that it will have one space and then a Comma and then another space before the next field.The last one is the field "Product ID" (field type is also Single line text) ,  before the field content i want it to have the letters/signs "ID:" and the one space and the the field content.For example i have the "User” John Jakson , he have a computer with the "Model" Apple MacBook Pro (16-inch, 2021)

When we enter a listing name in one table, the same listing should automatically appear in another table. We set an automation, but when we enter the listing name in one table, that same listing should go to another table. But filed is creating in another table, but the data is coming to that table.Help us here!

When automating from Airtable, all day outlook calendar events show as busy not free.Why is this basic functionality not available? It's causing issues for our organisation as users are not able to book time when we have an all day reminder from air-table. Other platforms like zapier etc have the ability to alter the state of 'show-as'.Is there anything in place to fix this?

I think I may have gone too complex with a formula as my base won't open now. It's just stuck on "Loading" on every table. How can I reverse what I did?Note: I created a duplicate of the table and it did the same thing

Hello, we are hoping to build an ad inventory management system that allows us to track when certain ad products are booked.Each ad product has different frequencies (some can be booked 1x a week or some can be booked only for thursdays or can run a flight period). What we'd ideally like to get out of it is also being able to track what is not booked/available to share with our sales team. Does anyone have a similar system already built out that can share a template or suggestions for how to show availabilities?

Hello Airtable experts!I'm a newcomer to the world of Airtable and am slightly overwhelmed with my goal. I'm looking to set up a "button-click" automation within an Airtable interface, aiming to create a private Airtable base with the click of a button. This base should be created within the workspace housing the interface. The goal is to create this private base with one table that references specific records from a source table in another base. I'm curious to know if this kind of architecture is feasible and if yes, can someone please help me get started with some reference code or tips? Would highly appreciate your insights, TIA!

Hey guys,I am trying to find a way to relink Personnel records on a base with synced tabled from 2 different bases in order to limit interface views off Airtable accountsBase Personnel - All Personnel info including airtable account using the User Field typeBase Project Tracker - Overall project information including Personnel like producers linked to record on a synced table from the Personnel base. Airtable accounts are a lookup field.Base Asset Tracker - Synced to Project Tracker to assign assets, pulls over information like producers. Also synced to Personnel base to assign assets to people. The synced Project table on the asset tracker currently pulls over the producer information but obviously as a single test field with the producers in a string out. Obviously I can't change the field type to relink to the Personnel synced table on the asset tracker. I've tired an automation that finds records with the matching name but that does not seem to to work since there can be

Hi !I have the team plan, previously plus, with the bonus payment of 10usd per collaborator per month.If I add a new collaborator, will I still maintain that price? Or will I start paying 20usd per collaborator per month?Thank you.