Ask the Community

I was looking at the API reference... why is there no method to retrieve an element by a field that is defined as PK? That … is basic DB functionality. Currently the only way to use GET (HTTP) to retrieve a record, is with a value no one knows and that can only be calculated via the RECORD_ID() function (... after you already have the record!)To me this .. is so weird haha :-)Is it me? What I would expect is that Airtable allows via the API to query the table with AT LEAST the PK values. 

I need to create an email automation (preferred) or design a page that displays information similar to an invoice.Example data:Person Janice Joe Jill Jerry Jess  Pay $100   $120 $60    Joe and Jess have blank values for Pay because they weren’t involved in this project. I’m able to use an automation to blast out an email to all people involved (Jance, Jill, and Jerry) because a separate field lists them, but I don’t need to actually display the empty records for Joe and Jess within the email content itself. And in real life, I’ve got over a dozen people and only 2-5 that I need to list in an email at any time.Essentially, I need to find a way to setup the email within the automation to only display specific fields if they have values. Alternatively, if there is a way to do this within Page Designer, I could just generate a PDF and manually send it to Janice, Jill, and Jerry. Ideas?

Hey all I am hoping you all can help point me in the right direction. I am looking at just using HTTP calls for updating parts of airtable for us. However, I am confused by how to update fields like single select and multi select. Example: I have a table that has a field of singleselect, and all I want to do is update the single select to have an additional choice. what url would I need to use to update the field? An example would help

Good day everyone, I need some help on how to create a script coding that Fill in the state name in a table cell when a customer fills in the full address in an Airtable form. This is not linked to an Automation, just an independent script that can be run anytime to any table, that also goes with the free geo api nominatim.Thank you.

Hi All! I am trying to build the formula to show working and non workind days of a month in one field Rules: Field musst have 31 charachters, for 31 days of the Month “N” for non working days and “J” for days worked Example: Max worked on a project on 13th & 15th Result should be: NNNNNNNNNNNNJNJNNNNNNNNNNNNNNN i have a lookup field showing the days worked, and i know this goes something like Substitute( REPT(“N”,31), {Days worked}, “N”,“J”) but i am just stuck. thx for any help!

I'm trying to upload a survey in Excel to create a Form view, but unable to do so without losing all the formating. Anyone know how to do this? Thanks!

I have a send email automation set up to email purchase orders to people in the company. I have a department correspondant cc'd on the email based on the department of the purchase order. When I received the email both my name was in the "to" email and the "cc" part of the email.Only the person in the company should be on the "to" part of the email the department correspondent should only be on the "cc" part of the emailThe department correspondent was on the cc and to part of the email but the airtable settings only have the department correspondent on the "cc" of the email automation 

Hello!I am running into an issue where the field count is almost maxed out on two tables in my base and I need the ability to add more fields. In both of the tables, there are many fields that are used for reporting/stats. I considered moving all of those fields to another table but it’s not quite working out.I do closing coordination for real estate agents. The two tables in question are the Properties table and Contacts table.The Properties table has records for each contract. The Contacts table has records for each of my agents. Each property record is linked to the agent for that contract in the Contacts table. Reporting in the Properties table is done based on the agent for things like properties under contract, properties closed X amount of days ago, etc. Reporting in the Contacts table is done based on the agent using rollup/formula fields that reference the Properties table for things like average sales price over X periods, commission totals over X periods, etc.In the new tabl

Hi there, when I sync’d my Airtable to my Google Drive, it automatically sync’d with My Drive. Is there a way to sync it in a Shared Drive or to a specific folder within the Shared Drive? Thanks in advance for any feedback!

We have one workspaces that our team shares, and it’s a nightmare to organize all the bases that exist in the workspace. How do people organize all the different bases in one workspace?

Is there any way to set up an inventory tracking system where someone can scan a QR code, and fill out a form of what they are checking out as well as checking back in?The issue I’m running into is that its fairly easy to create a form with a drop down of what you’re checking out, but when it comes to quantity of what's being checked out, that's where it gets tricky, unless you create a sperate quantity field for each individual piece of equipment, which if you can imagine, you have hundreds of different pieces of equipment, that is extremely inefficient not to mention the form it self would have hundreds of conditional fields. What I had imagined is for example, I scan a QR code, a form comes up, I check out 5 harnesses, 3 lanyards, and 10 beam clamps and click submit. On the user interface, I can look at who checked it out, what equipment they have what department they are etc. When checking back in, they similarly scan a QR code and fill in what they returned. It then compares what

Hi there - I am building some interfaces for my team that collects data in one table that is linked back to another table and I’d like the team to be able to update both in 1 page. Here’s a hypothetical scenario: I have a table of Owners who are all in my dog training class. The Owner table lists all of the things about the owner. I also have a table that has a list of every Dog in my class with information about them. Many Owners have multiple Dogs and I want to associate the Dogs to the Owner. My real-world example is a lot more complicated with hundreds of records. I want to keep my team from bouncing around multiple tables and manually linking records so am hoping to be able to design an interface page that allows them to add new data to another, linked table. I have a script running right now that essentially asks “enter # of dogs” then “create that many blank records in the Dog table” and then “Link those blank records to the Owner Table.” I feel like there’s an easier way… A but

I've set up a very basic automation: Trigger=when a form is submitted; Action=Google Sheets: Append a new row to a spreadsheet. The automation is working correctly, EXCEPT for the fact that the new row is appended at the TOP of the spreadsheet (i.e., row 1, above the header row) instead of at the bottom of the spreadsheet (i.e., under existing rows of data). Is there a way to specify that new rows should be appended at the bottom, below existing rows?Thanks! Heidi

Hello, I am working with inventory management database. I have two different tables where both have unique UPCs and a status selection. I am creating a third table that will only display products from both tables that are ready for sale i.e status is “Listed”. I have created an automation that checks when status is changed to “listed” then find if that UPC doesn’t exist in product table then create a new field with that UPC. I run into duplicate entry problem. *** when I change a product to listed it will pop up in products list which is what I want but when I change the status to something else and then change it back to “listed” it will create a duplicate field which is not what I expect.***  No matter who much I played around with different conditions and values in find section of automation I still couldn’t figure it out. 

I am trying to simply select a record and duplicate it from a filtered view, but for some reason, AT seems to be stuck or frozen.  It is  a bit frustrating.  Anyone else experience the same issue?

I know there has to be a easier way that writing out a huge if/else We are collecting Birthdates - Got thisWe parse the birthdate against today’s date to get an age - Got this workingWe currently have single select field called Age Bracket that contains the following options to select one based on the AGE field Under 2121- 29 30 - 3940 - 4150 - 5160 - 6170 - 7180+I am working transitioning the manual step of the team is having to do - to select the correct age bracket for the age result (For our Demographics)Thank you in advance for answering how to do this. Cause for some reason my brain just isn’t seeing this the way it needs to.

Does anyone know if you can add Airtable extensions/apps to interface designer?

Hi all - wondering if anyone can help because I’m struggling! I used Airtable to track customers and business opportunities through two linked tables. Within business opportunities, each potential deal is categorised to a stage (via single select) - either Early Lead, Qualified Lead, Proposal Submitted, Pitching, Closed - Won or Closed - Lost).I can link the tables so that ALL opportunities are attached together, but what I would ideally like is to have a section / field in the Customer record for Current Opportunties (Stage = Lead / Qualified / Proposal Submitted) and Past Opportunties (Stage = Closed - Won or Closed - Lost).I understand that I could link automatically and filter the possible selections based on the Stage but what I want is for that categorisation to happen automatically.Any ideas? I’ve tried (and failed) to come up with an automation to do it!Hanna

I have an Airtable Business account and Enterprise license for Salesforce Data Cloud. Data cloud has a beta connector to airtable, but I have been unable to get them to work. Here is the information the Salesforce connector asks for:I have no idea how to get the schema that is being asked for. Also, it asks for a private access token or OAuth. I am at a loss on how to set this up. Any help would be greatly appreciated. I am trying to connect my airtable to Salesforce because there are things that are much easier to add to airtable than Salesforce, but that I need to get into Salesforce for use elsewhere.

I looking for a script to send automaticly a webhooks at a date and a time variable...

I have a parent table with a bunch of linked children.On the parent table, I need to be able to click a check box, which will give the user a 30-minute grace period before the record is “Frozen” (it will move out of an interface section and into another one). The children will then move into a view that will sync it to another base, where automation will create a CSV and upload it to a server somewhere.  My thinking was to have a last modified filed field keep track on when the check box was clicked and then add 30 min to that and then let that determine the rest.However I’ve now been looking into the NOW() and it seems quite unreliable for things to do with precision and filtering records into a view to be synced to another base, is also an issue as the date time will only allow me to filter days, but not use time.  I can see how this could potentially be solved with a fairly expensive automation setup, where automation constantly looks for updates when the user clicks the check box.

Hello :) I’m not sure if this is possible but I would really appreciate any input or advice… I am overseeing the gig booking process for a band. I have 2 tables:Bookings EventsIn the Events table I have a summary field which concatenates various pieces of data about the event. I want to use this so that, when I am looking at the overall Booking, I can see a summary of all the info for each Events that is part of that Booking. The formula for this summary field is: CONCATENATE("\nEvent Name: "&{🟣 Event Name}&"\nDate: "&{🟣 Event Date (pretty)}&"\nEvent Time: "&{🟣 Event Time (pretty)}&"\nInfo on sound reqs: "&{Long text field 1}&"\nInfo about parking and dressing rooms: "&{Long text field 2}&"\n") At the moment I am pulling it into the Bookings table as a Lookup, but I think it could also come through as a Rollup. Once it’s in the Bookings table, I have an automation that copies it into a long text field so that the \n formatting splits up the da

Is there a way to make a photo (which I assume needs to be an "attachment" fied) clickable, where someone can click it to go to a URL? For example, I'd upload a photo of a dog and if they click it, it would go to pets.com.If not, is it possible to insert a clickable text link right underneath a photo?(The Pexels/button extension wouldn't work since I want to upload custom photos, in addition to trying to minimize expenses and complexity.)Thanks! (Please forgive me if my label was not appropriate - I'm new to AirTable).

I want a field that tells me if a volunteer shift is full, using the Volunteers Needed number field and the Volunteers Assigned linked records field. If I could write the code in plain English, something like:IF [number of records in Volunteers Assigned] is equal to or greater than {Volunteers Needed}, then display “YES”, IF lesser than, then display “NO” Checkbox field checked/unchecked instead of “YES” or “NO” text would also be cool but not necessary. I can figure out the IF part, but can I get the [number of records in Volunteers Assigned] just in the code, or do I need a Count field to find that and then use that Count field in the formula?

I want to make it simple for my users to copy a URL or long text field in an interface. I can add a button and it can copy the link to the record, or open the url in the record, but not “copy to clipboard”. What am I missing? This seems like a simple function that could be done?