Ask the Community

How can I count the number of records in the list "Attended Session & Challenge" that are specifically only from 2023? The attendance is based on a form they fill in that is in a different tab in the same workspace. help would be very appreciated! Thanks. 

Hello everyone, Hope you guys can help me out here.I am trying to fetch some information from Airtable through an Get request API block in Voiceflow. When the parameter field is empty I get a 200 success code but it retrieves all of the information. I want to fetch the information depending on a variable. To do that I type a filterByFolmula in the parameter field and I get 422 error. Does anyone knows how to solve this? I will really apreciate it{"error": {"type": "AUTHENTICATION_REQUIRED","message": "Authentication required"},"VF_STATUS_CODE": 401,"VF_HEADERS": {"access-control-allow-headers": "authorization,content-length,content-type,user-agent,x-airtable-application-id,x-airtable-user-agent,x-api-version,x-requested-with","access-control-allow-methods": "DELETE,GET,OPTIONS,PATCH,POST,PUT","access-control-allow-origin": "*","airtable-datacenter-regions": "us-east-1","connection": "close","content-length": "80","content-type": "application/json; charset=utf-8","date": "Sun, 29 Oct 20

we have a problem with the connection of softr and airtable. We have a part in softr where people can add new data and we need that data to be in airtable. However, in airtable the place where the data should go to is linked with other tabs.Since it’s a linked column softr doesn’t understand it. Is there a way for us to make it so that softr detects the linked column and when a new data is added it is shown in the correct place? or exist any formula that let us to copy automatically cells like in Google Sheets? 

I'm not normally a scripter, but just spent two weeks trying to put this little routine together and make it work. The script calculates the date one year in the future and uses it to rename a new column in the format MMM'YY.  After loads of trial and twice as much error, I actually got in to work!:Naturally I was really pleased with myself! Now just to apply a trigger. I want it to run on the first of each month. My first idea was to paste it into an automation. But I soon discovered that scripts run from the automation cannot create fields.How frustrating! Why not? Can anybody think of a workaround? Is there a command I can put in the script editor to make it trigger on a regular interval?Any ideas or workarounds gratefully received.

Hi - I am having a heck of a time figuring this out.I have a table called "Days" that holds different tasks with various dates. Some tasks have the same date.In a separate table called "Crew", I assign the Tasks to the crew, and can rollup the linked records to only return the unique dates. However, when I try to count these, it adds the tasks up on the same date, even though I only need it once.Example:DAYS TABLE:Ben's Birthday - 3/9 Pickup John - 3/9Brenda's Birthday - 3/10 CREW TABLE:John - Linked to Ben's Birthday, Pickup John, and Brenda's Birthday RecordsRollup field: Arraying unique dates, only return 3/9 & 3/10 as desired. However, when trying to count unique dates, it is still counting all the records even if they have the same date. So it returns 3. Help!! 

Hi, im using softr form to upload people images to airtable and then print it to an dynamic list in sofrt, but if they attach multiple images, softr just shows the first, how can i split this multiple attachments to different records?If you have some advise or another solution i hear you.Thanks.

Dear Airtable Community,I'm reaching out to seek assistance with a perplexing issue regarding the Airtable - Power BI Integration that has been causing me considerable frustration.As many of you are aware, the Airtable API imposes a limit of 100 records per request. However, I've encountered several challenges:Airtable seems to pull 100 records at random, without following any discernible order.The M Query function only operates when I utilize my API Key, which was supposed to expire last month. Personal access keys and OAuth integrations consistently result in errors.Attempts to make additional requests with offset values have only yielded errors.When I've tried to access data via the web, I'm prompted to sign up for Airtable, yet my browser is not supported, and there's no clickable button for further action.The complexity of this integration has left me feeling disappointed, particularly considering Airtable's primary appeal as a platform for no-code, low-complexity datasets.Would a

Hi everyone, I'm trying to implement the following Excel SUMIF Formula: SUMIF('Tabella raggr'!B:B;T2;'Tabella raggr'!D:D) Basically I have to add up all the values in column D where the corresponding value in column B matches the value in T2.In the screenshots below you can find the B and D columns of the 'Tabella raggr' table and the T2 which is the criteria of the SUMIF function and it's on another table called 'SAP'.

Hello The following code works when I pass in the field name as a string to the get function. It doesnt when I use the field id. I want to use field id. The code is taken from the API sample for javascript await table.select().eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function (record) { console.log('Retrieved', record.get('my-field-name') ); }); fetchNextPage(); }) How can I do it using field id instead of ‘my-field-name’?

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be appreciated. TIA. 😊

I have a script that I'm using to update records in my Airtable base, but it seems to be taking longer than expected and sometimes hangs indefinitely. I'm seeking assistance to optimize the script for better performance.Script Description: The script aims to update records in the "Tasks" table of my Airtable base. Here's what it does:It retrieves records from the "Tasks" table, selecting specific fields: "Predecessors", "Tasks", and "Next task".It filters the retrieved records to find tasks that don't have any successor tasks (i.e., "Next task" is empty).For each of these final tasks, it traverses the chain of predecessors to update a field called "Milestone Name" with the name of the final task.It performs updates in batches of 50 records to avoid hitting Airtable API rate limits.Code:async function updateChainWithFinalTaskName() {const table = base.getTable("Tasks");try {const query = await table.selectRecordsAsync({fields: ["Predecessors", "Tasks", "Next task"]});const finalTasks =

Hi! 2 things…I’m trying to find a workaround so that when you being typing in the address field, the address starts coming up like in Google maps. I have the map extension installed and can not figure it out. From what I’m researching it’s not possible? Also, relating to address mapping… here is my other scenario…Im creating this for a cat rescue and we perform mass trapping also. While in the field and a cat is trapped is there a way to snap a pic, create a new record and in the location field have our location populate? thanks! 

Hi there: There are two records with to dates, I need to use the DATETIME_DIFF function, but it only works If I have the fields side by side, not in two diferent records. How can I work this out?

Hello everybody,For my personal knowledge, I want to create an automation to send emails in mass to the interlocutors but one email per person. I mean : 1) How do we automate to send an email to each of the freelancers? So in “To”, there will only be the freelancer concerned?In the Find Record, I wrote (See screenshot 1):Where freelance is not emptyand Status is "A rédiger"and date-publication is todayWhat I understood in human language: "Hey Airtable, you will do something when the Freelance field is not empty, so when there is someone to identify and the status is "A rédiger" and that 'in addition the publication date is for today'.Then I configured the email by saying (See screenshot 2):To: List of "freelance" and "List of Name".Human language: Send to the list of email addresses identified in the freelance field.Messages: "blablabla"...Grid of records: “post_idee” and “freelance”Human language: A table with the post ideas in the first column and the freelancers identified with

Hi,I'd like to ask how many emails i can send through automation triggered send mail action.I've read other posts and threads but i am still confused with the wording of Airtable.it says I can send any number of emails to collaborators with verified emails.and also i can send email to 100 unique non-collaborator email address per day.In scenario, I send task notification email to "A" non-collaborator email address, and then sends task assigned email to "B", when "A" completes and changes the status, and if it sends completion email to both "A", and "B" then would it still count as 2 unique collaborator, and i still have 98 more unique non-collaborator email address room left?Just want to clear up this before i start mailing stuff through the automation.Thanks

Can anyone help me with how to use  useRecordActionDataIn the docs it is describing that it can be triggered when we open the extensionI want to perform oauth while opening the extensioncan anyone help me with this?

As others said, attaching facebook selfies to Airtable is not popular at work. But attaching sample pictures to records from web search *IS* one of activities enterprise customer employees do often.N-O-T a good choice. https://air.tableforums.com/t/web-search-in-adding-attachment-pictures-no-longer-avail-from-jan-30/1045

TIA - this community is amazing and so helpful when I can't get my head around these more tricky ones. but I am learning more and more! I have a bunch of method steps for our recipes:COOK THE SALMONPat dry salmon with paper towel, remove the skin and cut into bite size pieces, discarding the skin. Add salmon, olives and courgette to the pot. Simmer, gently stirring occasionally, for 5-6mins, or until the salmon is cooked through and all the veggies are tender. Remove from heat. Check seasoning. "MAKE THE AVOCADO DIPCut lemon into wedges. Halve avocado, remove the stone and scoop out flesh with a spoon. Place avocado into a third medium bowl and mash with fork until smooth. Mix in aioli and (1/2 tbsp/1 tbsp) lemon juice. Season with salt, pepper and more lemon juice to taste. Set aside.TIP: If you prefer, add avocado to the salad in STEP 5 and serve aioli on the side. "MAKE THE HERBY VINAIGRETTEFinely chop (half/whole) pack coriander, including the stalks. Add to small bowl with (1

Hello, I have a DB ~15,000 records. I wrote a script to merge and delete records. It compares three data fields for duplications and combines the duplicate records. It also will merge data from two other fields if the fields are not empty. I tested my script on a 500 record DB and it works fine. When I test on a 2,500 record DB it times out. Can someone make any suggestions on how I can cut the execution time on my script ? I've seen posts about using a hash index, but I don't think that would work for what I want to do. Because I need to iterate through all records to find duplicates. If I'm wrong I'd appreciate insight.   var table = base.getTable('Testing_Dupes'); var query = await table.selectRecordsAsync(); //find records with a duplicate (first name, last name, residence) let dupli = query.records.filter((record) =>{ return query.records.find((potDupe)=>{ return record.getCellValue("First Name") === potDupe.getCellValue("Firs

Hi Everyone, I’m working on a TV series, and looking for some online database solution for a really easy(-looking) task: I have to follow the realationships between the characters of the TV show during the script writing (friends/enemies/…etc - it can also be a simple list). So it means I make a list with the names of the characters I guess, and then I need to duplicate this list and somehow make a third list that contains the connections between them (it’s like a two dimensional graph). And then the second question: if the database is finished, how can I easily make the entries (we are talking about hundreds of character names). For example, I have two names in the list: “Joe” and “Bob”. I want to change their relationship into “friends”. I guess I will need some kind of combined searching form that looks for the two names and make me able the change the third data between them. Do you think I can do this in Airtable? Can you help me with this? Thanks, Miki

Hi everyone, would you please tell me how to convert a multiple date string field (i.e., 2/11/2024, 3/3/2024, 2/19/2024, 2/25/2024) to the correct format date field that reflects all the dates in the string field? Please note that the string field mentioned contains the date values based on a lookup function from its source field or table. Thank you.

Hi there, Brand new to Airtable and have been messing around with it to see if it fits our needs. I’ve been impressed! One question I have yet to find the answer for is… Is there a way to process a submission fee payment as part of forms created through Airtable? As an organization, we collect a small application fee. While I assumed that Airtable’s integration with Stripe/Paypal would make this easy, I have yet to find a way to do so? Any help or potential workarounds would be appreciated.

I'm trying to build an IF Formula that seems like it would be straight-forwarded, but is proving to be more complicated than I thought it would be and has got me stumped. Both fields are Lookup fields getting a Rollup value from another table. I started with a basic IF formula, but the problem is it resulted in X $0 values being replaced by the Y value, when I wanted the $0 X value to be returned.IF(X,X,Y) Then I tried to a formula to say if X is equal to or greater than 0, and that worked, but it would not return Y if the X Column was blank. IF(X >=0,X,Y) So, I tried an IF / Or Formula. It still returned the X field correctly, but did not return the Y Field if the X field was blank. (Update: I originally wrote this wrong when I posted. I was trying to say if X is not blank & is equal to or more than 0, return X, otherwise return Y. Also tried with X !="" instead of Blank() - same result).IF(OR(X >= 0,X != Blank()),X,Y) I'm not sure why this is being

I have a fairly niche-type issue that I've not been able to figure out; for context, I've created a check in base optimized for a team of supervisors to check in/out staff using the Airtable mobile app. I have 2 tables linked together, where one represents 1 record for every shift (named "All Shifts"), which is linked to a table (named "BA Data") that houses the staff info of whoever is scheduled for a shift. I would like for my Supervisors to be able to open the linked record (aka "BA Data") while looking at the "All Shifts" table and be able to modify a "Current Location" field and a "Lead Notes" field (both are housed in the "BA Data" table). The navigation to do so seems to work just fine, but when a user opens the linked record from the mobile app, it appears that the Sort is defaulted to newest to oldest fields, in the order they've been modified; I know this because when I converted the oldest field to "Current Location" in order to bump it up to the top, the oldest fi

Hello,I would like to ask whether is possible to copy linked connection between two tables with automation?I have three tables:1. Summary - here I would like to collect prices from Payment and VAT from Invoices2. Invoices - here are list of invoices, each has at least one connected Payment.3. Payment - list of payments with specific pricesIn Payment table I manually connect each payment to specific Summary.What I would like to do is automatically create/update Summary field in Invoices table with same linked connection as I do with Payment, so in Summary table VAT can be calculated. I tried it with automation, but probably I have mistake somewhere in the action..Hope I explain it clearly, here is link to my sample base - https://airtable.com/apphUNbqkv8pDYRGS/shrdfftFVSqakQLawThank you very much