Ask the Community

Good morning,I am writing in reference to a problem with the Airtable integration via Token at MAKE We need this integration to ensure that Make automatically connects leads arriving from Facebook and the CRM in AirtableThe problem is that every time I inserted the Personal Access Token to do the integration, it gives me the error "Status Code Error: 401"What could be the problem? Are there any essential settings for the Persona Access Token to integrate it with Make?Thank you,Best Regards

Since the rude depreciation of APIs from Jotform, I have rebuilt my integration using their new system. However, it fails every time a form is submitted reporting:Unknown Field Name "fldqb0p2A79uDENvw". I have no field of that name in either Jotform or Airtable, mine are all user friendly names. So what's going on? I have raised the issue with Jotform support who say they need more detailed logs. Any ideas?

Hello,I need help setting up an automation that links records in a "dependencies" field to a predecessor/successor record (determined by order number). The goal is to automate tasks to hit contributors dashboard when its their turn to work on the project. We have a Projects, Tasks, Content Type and Templated Steps boards that ive set an extension to generate a specific task list based on the type of content. I can edit the extension code to include the dependencies field and set those are part of the template, but the problem is that many project managers use this as a starting point and edit the task list manually, adding or subtracting tasks for their specific need. If a project manager edits the task list, they have to manually manipulate the dependencies field using the gantt view, which is cumbersome and manual. id like to set a way for the field to automatically update based on the task order. So the trigger I have in place is "when record is updated"-

Saw a new ARRAYSLICE function pop up in auto-complete today that isn't in the documentation. Anyone know where it came from? I suppose it allows for a less hack-y way to access individual items in a rollup, but I'm not sure what it provides in isolation, since you would need to know the index of the item you're looking for, unless you're looking for the last item in a rollup.

I need a formula that calculates the number of days we have owned a house.Possession date to sold date and in the case there is no sold date I want it to calculate using today. TIA

Hello!I'm trying to create a formula that will create First Name (Goes By Name) Last Name (Business Name).  I've gotten my formula so that I can get all those pieces together, however if either Goes By or Business Name exists and the other doesn't, I'm getting () included still. For exampleKatelyn () Grant (Airtable) or Katelyn (Kate) Grant () How do I get it to not include the () if the field is empty?Here's the formula: IF(OR({Goes By Name}, {Business Name}),{First Name} & " " & "(" & {Goes By Name} & ")" & " " & {Last Name} & " " & "("

Hi All,I have a table for Employee Timesheets How Do I get a value from same table i.e. reference a record with same date + specific other field valuei.e. the timesheet table contains multiple records for same day...  I want to get the postcode for the previous job, which is determined by Job Order Number field...  I'm new to AirTable so please bear with me.ThanksKalpesh 

Hi everyone, first of all I'm really sorry for the noob question, I'm an English teacher who is not good at math and I cannot figure this out after days of trying.I have an excel document where tasks are given scores based on prioritization questions.Most of the questions follow a simple "If answer = YES add a numerical value of 3 to the overall score" format.But I have a few segments that use COUNTIF logic.In one of the sections where there are 5 prioritization questions the COUNTIF logic looks like this(COUNTIF(I7:M7,"Yes")>3,12,IF(COUNTIF(I7:M7,"Yes")>2,9,IF(COUNTIF(I7:M7,"Yes")>1,6,3))So the yellow section of questions follows:If 1 question in the yellow segment is answered "yes"  - add 3 points to the overall scoreIf 2 questions in the yellow segmentare answered "yes" - add 6 points to the overall score

Hi Experts!My goal is to create an image carousel in HTML/CSS to embed in a website in order to view the image uploaded in an attachment field for each record. Something like Airbnb image gallery. The number of photos may vary so it must be flexible.I'm currently using Softr to display my item details in Airtable but the options to show images are poor and not very UX friendly. But I can embed code. I already do that with embedded YouTube videos and google maps.Right now I'm thinking to build a html code + CSS iframe with make.com that is feeded with Airtable attachments with the iterator block, and then copy to in a rich text field for each record, but I'll need a CSS HTML5 developer.Any other ideas on how to implement this?Thanks a lot for any suggestion!

Hello!I'm new here and trying to mimic a critical feature for my workflow. Is there any way to create parent tasks and sub tasks, each with unique columns? This is something I'm able to do in monday.com, but I really want to use airtable as my PM system 🙂 Here's a pic if it's easier to visualize: I searched around and couldn't find it in the community posts, so wanted to check here.Thanks!

Hello, I am trying to build a query in Power Query/Power BI to load an Airtable table into the data model. I have found some working code which uses the offset parameter returned by the API to deal with the pagination. However, the offset value returned does not match the API documentation and gives an error when I try to parse it. According to the API docs, the offset should look like this: "offset": "reco1XxXxXxXxXxXxXx" However, what I get is this: "offset":"itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx" When I parse the value into the URL, using &offset=itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx, I get the following error: {"error":{"type":"LIST_RECORDS_ITERATOR_NOT_AVAILABLE"}} When I try passing either of the values (before and after the /), then the error is: {"error":{"type":"INVALID_OFFSET_VALUE","message":"The value of offset itrZXxXxXxXxXxXxXxXx is in

I have a form that collects multiple garment measurements. Each measurement goes into its own field.I would like for all the measurement fields to be displayed on the form. One or more should be required, depending on the value of another field (garment type).This doesn't seem to be possible. Have I missed something?

I want to automate an email that goes to staff two weeks before their leave year renews on the anniversary of their start date each year.Is it possible to create a formula which will automatically show the next anniversary in a date format? For example: If my start date is 28/02/2019 and today is 07/02/2024 then the next anniversary date should read 28/02/2024Or if my start date is 28/02/2019 and today is 01/03/2024 then the next anniversary date would read 28/02/2025I'm UK based so using DD-MM-YYYY formatting. I'm struggling to generate anything that works - any help appreciated.

I am trying to have the person who submitted the form on the left followed by a dash - and then another field but cannot seem to fix this. Any help would be appreciated.

Hi everyone, I have a collaborator with Creator permission who is unable to add attachments to an Attachment field. Is there a solution?Thanks in advance.

Hi I am a newbie to Airtable so please bear with me.I have been using JotForm to collect timesheet data from employeesand one field contains team members i.e. could be more than one team member in a single field and appear to be space separated in Airtable - in the JotForm itself this is a multiple select for each team member present that dayHow can I view/split this to make individual timesheets for each member listed in that cell i.e. duplicate the view for each one of those team members please?  This would then enable me to share each team members timesheet with them individually?The team member field looks like this:ThanksKalpesh 

Forgive my ignorance!  I have a column called Tickets.  I ultimately want this column to tell me how many tickets to each event AND separately, the number of tickets for the attendee for each event.  At the bottom of the table, I want a total number of tickets to a venue, despite there be multiple events at the venue.Do I have to create multiple columns to get this?

Im using Parser by Zapier to receive mails and create a record with certain infos mapped to my columns. One of which is the Mail Attachment to be placed in a File Column in Airtable. Somehow the file gets renamed on the process. In my example I send "invoice-60.pdf" to the zapier parser. It got added to the record as "9UngNgXzKLZ3jsMlQmQBOa95o1I5ENxS9LaFRxLNIfNkfLjB0I3ul64-P893QYjt62uhsUPyHBMe_P2i65Zv7-O3qjclkk4ACMI72H8AytGuav9QrcSMjQ1w8Sc1t4_UWDuEuGw6wGENXNjHf3XzQlMf2LLiwwxSveX6kdXYwBk"Somehow the .pdf end got lost in the process. I need to use an Airtable automation to send an email containing that file to a specific address when the status is changed. Due to the lack of .pdf ending the receiving system doesn't recognize the file and rejects it. Bizarre enough, i can open it in Airtable and take a look at the filename, there is no .pdf at the end. When I download it though, the .

I have been tasked with developing a system for individuals to evaluate (with a rubric) a series of proposals related to a strategic plan coming in.Individuals are submitting ideas using a Form that feeds into an AirTable Base (Base 1). We are doing this because we also want to visualize the ideas.The idea is that once individuals submit their ideas, a group of people will be able to evaluate them using a scored rubric (Base 2). Initially, I figured I would create another Base and then Sync the Two Bases (One Way) While also adding a form that would input the scores into the New Base (Base 2). I would link them based on either the AirTable ID or the Title of the Proposal. I was then going to create a third base (Base 3) that scores and averages the results of the evaluation.The challenge I am running into is that MULTIPLE people will complete the evaluation – up to 15. I am trying to think of a way to use AirTable for the scoring phase, but there need to be MULT

Hi everyone. I have a table "receipts" that collects receipts linked to different projects. Every receipt can only be linked to one project. The Receipts table has a Number Field "Amount in Euro". Now I the Project table, I want to have a Rollup field with the sum of all Amount field. But only those who are linked with the Project im currently in. What I want to do is add the condition "Where Project is exactly current project". So for Project 1 it filters by that, for Project 2 by that one. But I can only choose one particular project. Am I missing something or is there another way to do this? Basically what im trying to do is see the Sum of all incoming and outgoing receipts for every project right within the Project. Any helps would be greatly appreciated 🙂 

So GIFs working on synced view on laptop but not on android. But if view is a shareable link they work? Same data.At mo I created a button back to original as want to edit on phone but mystified why not working. Sure it worked before on Pixel phone but now on Samsung. Any thoughts anyone?

All day it's been 10-15 mins to execute a workflow of a few steps, some scripting, some update record.  Is this isolated or has anyone experienced this today?

HiWe have an Email Tracker table in our base with a lot of data rows, so I want to move that table to it's own base to avoid maxing out our limits too quickly.The Email Tracker table is fairly independent, with the exception of 2 data columns:1 linked records field (linking to the Campaigns table)1 look up field that is pulling in the "campaign owner" from that same Campaigns tableI'm not sure how to best maintain the 22,000 rows of data already linking to the Campaigns table in our primary base.The Email Tracker base will have a Campaigns table that is synced to the original one in our primary base. However, I'm not sure how to get the linked records fields that are currently looking to the primary Campaigns table to now look at the synced version of that campaigns table that I created in the new base, short of manually updating all 22,000 rows!I did a test, pulling in all the information of the Email Tracker. The linked

Hi there,I have a registration form. A single respondent will enter the the following data: name_1, email_1, an ID code, name_2, email_2, name_3, email_3.Instead of this being stored as a single row. I need this to be stored as multiple rows.row 1: name_1, email_1, and ID code, name_2, email_2row 2:  name_1, email_1, and ID code, name_3, email_3How can I get this done? 

It appears the URL for a sidesheet within an Airtable Interface does not contain the Record ID. Hoping to create a formula link to records displayed in a sidesheet, however cannot figure out how to do this with the structure of the sidesheet URL.The structure is either:https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX?xxxxx=sfsXXXXXXXXXXXXXX&detail=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXor: