Ask the Community

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

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");

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

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 s

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

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 tab

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.

Hello! My company may be no longer allowed to use Zapier so I'm trying to figure out how to recreate my Zap using Airtable automations. I need to be able to upload a batch of image files somewhere (our company uses Box), have Airtable match the filenames of the images to existing records, and upload that image file to the attachment field for the matching record. I've seen posts about bulk uploading images to new records but can't find specific info about matching images to existing records. Is this possible?

Hi all, We are an organization that runs a lot of webinars, and we want to evaluate each program and get participant feedback so we send a survey after every program.The evaluation questions are the same for every program and I want to design a base that will collect all these responses, and for me to have a way to see all the responses by program, by type of program (for example- a one time program vs an intensive) and aggregated as a whole for the year so we can know how we do in general.I have one table that "holds" all the programs themselves as we use it as a workplan to plan the program from start to finish. I would love to find a way that i can send a survey/form to participants (obviously not users of Airtable), and that all replies will be matched to the program they attended (without them needing to choose the program from a long list).I would love to brainstorm a good way to get this done! We're also currently paying for a couple of third-party s

Hey all,I am trying to use the 'search records' module in make to search for a record in Airtable based on an email field (see below).The error I am getting is: [422] Invalid request: parameter validation failed. Check your request data.I feel like I've tried every iteration of structuring the formula (with and without ' ' or " ") with no luck.