Ask the Community

My airtable account does not let me generate an API Key, instead it pushes me to creating a PAT. I have used a PAT and successfully linked to Make.com however as far as I am aware I need an API Key to integrate Airtable with Voiceflow, so does anyone know how I can overide what it is saying and generate one. Or can someone help show me how to use the PAT to link with Voiceflow.

1. The Date Time Button in the filter when we select a date the data is not the same in the table where it is linked? When we select the past month, the value of the data is not match in the table when we filter it2. Can we do math operations in a table that is not in the same row but in different row?

I’m starting using AirTable and VoiceFlow. I use the following URL Endpoint to GET JSON string and it works fine. httpx://api.airtable.com/v0/appRDBju2BbYrBKCc/colori?maxRecords=1000&pageSize=1&offset={offset} I need to add filterByformula function. Could you suggest me syntax and how i have to use it? Is there a good documentation for this anywhere? Thanks very mach. Federico

Hi,I have a table named "Customer" whose field is "Address"I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is a roll up field.In my case, i only want to retrieve the last address of the last linked customer. So if i have ["Customer1","Customer2"] in "Target Customer", the "Latest Address" must be Customer2's address only.How can i achieve this?Note: Customer1 and Customer2 are not related to any created time or updated time or any min max value. The sequence is totally random. Thank you

Hello there,https://api.airtable.com/v0/appycQyQBCRaFT2aD/Tebi-Category-Test?maxRecords=110&view=Grid%20viewI'm using this API to get the my table's data and after that I will process this into my CMS and then to fetch next records there is offset which I'm using to get another records. Since the records are more than 100 server might get out so I tried to get less records like 10 but offset is not there in the response.so can someone help me to get less records and also the offset in it ?Thank you.

Hi there,We have a number of users who have interface only access (i.e., no base access). One of our pages uses a 3 level list. When they attempt to add a new linked record/new row through the interface by using the + icon (e.g., a task or action), they get a permissions error. Any insight about why this might be happening would be helpful. 

Is it possible using a formula or automation to compare two multi-select fields and show which items are missing from the 2nd? I'd like to have a 3rd field that would show just what was missing from the completed list. 

The "Add record" and "Add milestone" controls are disabled in our Gantt view. Removing all filtering, all grouping, and disabling/re-enabling "Use milestones" in the view's settings have not helped.'How is this supposed to work? 

Is it possible send an Airtable form without the Airtable cookies (disable the cookies)? We don’t want to save the forms's information in the cookies, when it’s not necessary.

I recently started having this issue in Safari where select option fields are causing autofill login prompt to appear. I’ll have to look into it but I was wondering if anyone else has come across this too?

Hello! I'm creating an Airtable base to manage book club meetings. I have a column for the meeting dates (DD/MM/YYYY) which take place once per month. I'd like to have a "Reading Status" column that uses a formula to create the following labels:"All Done" for meetings where the date has already passed"Up Next" for the upcoming meeting"Not Yet Read" for future meetings that are not the next closest meetingI am new to formulas and struggling with how to set this up. Any help would be much appreciated. Thank you!

I would like to use a content calendar to create a mockup or preview of my instagram grid based on the dates and images in a record, so that I don’t need to go outside of airtable to preview it. Has anyone found or built a solution that does this?

Hello community!As a "young" Airtable user, I'm stuck on a problem that's probably very simple, but I just can't seem to solve it!I have two tables: TODO and USER for an onboarding process.When I add a new user to the USER table, I want all the tasks in the TODO table to be associated with that user.Can you help me?Thank you in advanceThierry__________________________________________________Bonjour la communauté !"Jeune" utilisateur de Airtable, je bloque sur une problématique probablement très simple mais je n'y arrive pas !J'ai deux tables : TODO et USER pour un processus d'onboarding Je souhaite que lorsque j'ajoute un nouvel utilisateur dans la table USER toutes les tâches de la table TODO lui soient associées.Pouvez vous me guider ?Merci par avance à tous et toutesThierry___________________________________________________ 

I have a base that is mostly photos, with reference numbers on each one. Because the photos are the "main event", I am trying to use gallery view to print and/or save as PDF.However, I find that cards often break across pages, and sometimes leave the photos invisible. See example, attached.Is there a way to make gallery view print so that cards do not break across 2 pages? Eg, if a card is to big to fit on the bottom of one page, I'd like the whole card to bump down and begin at the top of the next page...Thanks!PS, here is a view-only link to the base in question, if you want to take a look for context:https://airtable.com/apphd3iQywmXlOo2D/shreaoqDCsKGsNO9G 

Hi All, I want to create a bibliography. I have all the pieces in different columns and want to use the concatenate formula to pull them all together. However the Title of the book needs to be in Italics, how do I carry over the italics from the cells, or adjust the formula to make only the title Italic? Author Surname, Initial(s). (Year) Title. Place of publication: Publisher. This is my formula: CONCATENATE({Author(s) Max 3},"(",Year,")","."," “,Title,” “, City,”:"," ",Publisher) Any ideas?

Hi! I already created and published a form that has received entries. I realized I need to add another question in the form so I added the question in the form, and added that column manually into the base that collects the data. I published the form, but answers for that added question doesn't show up in the Airtable base where it collects data. Where am I going wrong? I made sure to add the column with the exact text in the same order as the form. I also published the form. I can't see anywhere else I need to make changes in order for this response to reflect in the base data. Any advice?  

This morning, trying to use an interface created a long time ago, I encountered an anomaly:when I go to create a record, it does not extract the list of valid values if it has to extract them from a table via a filter.I enclose two screenshots showing how the list on the form is empty, while the preview list of selection criteria has the correct values.Thank you for your support in resolving this anomaly

Hi! I found a workaround that’s helpful for me, so I thought I’d share. If someone has an easier way to do this, please let me know! Apologies if this has already been posted, I didn’t find it after a bit of searching. The problem I was trying to solve was that when updating a record, a field can be named using its friendly name (e.g. “First Name”), but then if I change it later, even a little bit, my API integration will break. Each field also has a unique ID, prefaced by fld, but I wasn’t aware of any way to actually find that name. Well, it turns out that you can for most fields, with a little trickery: Edit: See drassi’s post below for an easier way to do this. In the GUI, create a new field, and make it a formula. In the formula, refer to the field that you want to know the ID of. (For instance, if you want to know the ID of the “First Name” field, make your formula “{First Name}”.) Delete the field that you want to know the name of. Now, the formula field will have a red erro

I've got an automation in Airtable to send a record ID to Make to then fetch some data and send a whatsapp message. When I send the content of a 'Long text field' - it fails. I've tried adding a function in Make to remove all special characters like line feeds etc. and send to WhatsApp - but I can't get it right. Anybody know what special characters are used or the regex I could use?In my trouble-shooting, I created a single line text field and copied the text in there - then use that to send to whatsapp - and it works...  just without the line breaks. Any ideas for me please? 

Hello, Is it possible to show specific data which is unique to Interface-only viewers. I want to create an interface where they can see a record of form submissions (use case: invoices) which they have submitted via an airtable interface form and see what the current status is without seeing everyone elses response. Is this possible? if so, how do I go about it?I would like to avoid duplicating and re-making interfaces for individual viewers so am looking at softr worst case.

Hey I am stuck with the automation of "update records", and this is where I am:1. I have a table named "master project" (primary field) and in each row, consists of 7 sub-projects under the same master project. All 7 projects shared the same status on 4 variables, while each also have different status on 5 variables  2.  I need to break each of the 7 sub-projects into individual row so that I can run calculation based on each row. For this purpose, I have created another table with "Projects" being my primary field. And to continue build on new projects when i have more master projects input from table 1 (above point), I have use "create a record" automation to pipe in full information of each project3. My challenge is, I need to create an automation that, if any update is detected on (1), it should also automate my second sheet (2). But now because I have broken down 1 master project / record in table 1 into 7 rows in table 2, seems like the software is having diff

Hi Team,I've one particular requirement that if  I can replicate records from one base to another, especially when these bases are located in different accounts.  I'm aware of Airtable's robust automation features and wonder if there's a solution or workaround for achieving cross- airtable account automation. In simple words, I'm interested in a process where, when data enters into one base automatically adds that same record to a corresponding base in a different Airtable account.

How do I add a column of numbers quickly without creating a formula?

I have created a form using fillout and and added a forms table in airtable How do I auto update the client table, services table, etcI would appreciate any assistance 🙂 

Hello,I have an automation that updates the Invoice Table paid column with a checkmark when we receive a Payment in the Payments Table with a matching invoice number. We now have noticed that clients may pay the invoice twice. To document this, I wanted to have a linked column (to my payment table) in my Invoice table that links the matching payment. My automation currently updates the invoice base and will populate the 1 linked record, however if a 2nd charge comes, it replaces the record. I know it is possible to link multiple records in one field (and use rollup function) as I have done this before, but I am struggling with the automation populating both linked records and keeping them. Any solutions? Thanks!