Ask the Community

Suppose I have multiple products (Cola, Root Beer, and Diet Cola) that come in different sizes (6-pack and 2-liter). I currently have an interface set up where I can fill out a sales order where product and size are selected separately via single-selection. The problem is that each possible combination has an arbitrary price not based on any mathematical formula. I would like to reference the price based on these two selections, but I can't see any way to do that.I'm totally comfortable making a new table with a separate record for each possible combination (so six, in the current example). I just need a way to reference those records based on my two single-selects.

Hi everyone!I want to send email to our customers in which I want them to choose between two options (buttons). "YES" or "NO" depending if they agree with the cost of repair for their product.How can I build this buttons and email so that I can get their choice direct to the AirTable? I already have one single select field with yes/no option. But I don't know what to do next.Thank you for your help!

I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apostrophes Quote ('), it gets an airtable error.  Any advice?Kevin

Hello:I am trying to create a RollUp for A Scoring Process we are undergoing related to our Strategic Plan. I have managed to get everything else to work; however, I am running into a challenge doing a RollUp for two questions.One is a Simple Yes/No Question. I want to get the total number of Yes/No Votes.The second is a Yes/No/Maybe question. Likewise, I would like to get the total number of Yes/No/Maybe votes.I have tried creating conditional formatting that counts IF FIELD=YES, but that is not giving me the total number of 'Yes' when I roll up. I recognize I will probably need five new columns - but I cannot figure out how to get them to populate with the required information.Thanks for any help. 

I struggling to correct a formula where I want the return value to appear based on IF AND statements.Goal I am trying to achieve:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).Here is a short Loom where I walk through what I want to fix: https://www.loom.com/share/82b6cdb91b12403d96fdb047760e01e0?sid=bdca5f77-58d9-478e-bfbd-6395874742dcBelow is my current formula:IF(DATETIME_DIFF(NOW(), {📧 Inquiry received}, 'days')>=90, IF(NOT({🎉 Date Won}),"📞 ",""))What I want the formula to say:If the “inquiry received” date is greater than or equal to 90 days

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Hiya! I'm relatively new to Airtable and need help with this formula. I need to find a formula that displays the date for the Friday of the week before the start of the next month based on a date in another field. Would also love to know what each element does so I can learn a little too rather than straight copy/paste. Thank you so much!

Would it be possible to disable database snapshots, delete/clear out database snapshots, or configure snapshots to ignore specific fields?The way database snapshots currently function undermine any meaningful data deletion or redaction strategy for an active base. Our organization uses an automation to redact certain fields in our database for any record over X days/months old. While this automation cosmetically redacts the data, the original, pre-redacted data is preserved in the database snapshots. As database snapshots are not able to be deleted separately from the base they're attached to, the only way to ensure that redacted information is not preserved is to duplicate and then delete the database.While a workaround exists (duplication+deletion), it's tedious, creates broken links, and makes operationalizing a data retention policy difficult. As a base admin, I would like to be able to either disable database snapshots, exclude certain fields from snapshot functio

My team uses the revision history function a lot when editing records. Currently, that function is not available in an Interface, as far as I can tell. I hope that it can be added ASAP. I have a workaround that embeds a link to the record in the base, and directs the team member to click on the link and open up the Activity pane to see the track changes. This is a workable solution, but far from an ideal one, as it requires the team member to interact with the base itself rather than the much more streamlined—and much less confusing—Interface.

HI, this is my code for my payload posting to a table using Google Apps Script: var payload = JSON.stringify({"records": [{"fields": {"OnlineSubmissionLink": [{ "id": linkedRecordID }], // Set the linked record field// "SaleDate": formattedSaleDate,// "SalePrice": donationAmount },"typecast": true}]}); My log says: Constructed Payload: {"records":[{"fields":{"OnlineSubmissionLink":[{"id":"recXE6yQpMi1NyWRx"}]},"typecast":true}]} for

Hoping someone can guide me with setting up a formula to score tests that are reported on another table.Here's the current setup:Table 1 - record of all test takers by session ID, including fields for all of their question responses.Table 2 - question key  - records of all questions used in exams including a field for the correct answers.Table 3 - scoring - how can I set this up to pull response data from table 1 and cross-reference against the correct answers on table 2 and then display correct or incorrect, 1 or 0 etc for each right or wrong answer?Table 3 would then also have separate fields that would tabulate the raw scores for each section and covert them accordingly.  It's a relatively easy formula on a spreadsheet, so I thought it would be easy here as well, but it looks like Airtable doesn't support combining formulas with lookups?  There are over 100 responses in each test session,

Hi all,I feel like this question may have a very easy solution, however I have been unsuccessful with my attempts so far. Basically, I have created three interfaces with one or two pages in each. I want to share a couple of my interfaces with some of my team members, and the other interface with my other team members. I am struggling to understand how to accomplish this, such that they do not have access to the other's interfaces.In the sharing options, it gives me the option to share to individual bases via link, however when I test the link i can click back and open the other interfaces (I also tried with another account I can access to test it and the same result happened) I am sure I am missing something. And if there isn't a solution, a work around where I only get one page/interface is acceptable. Thank you,Ben

I have built an inventory management system, where each item is a record in a table. I was able to add an extension that creates a QR code for each record and saves it as an attachment in PNG format.  The intention is to print that QR code on a label, then stick it on each item in my store room. Once someone extracts it from the store, they scan the code and mark it as "OUT" to keep inventory up-to-date.My main issue is to create a way for the QR codes (PNG attachments) to print. Ideally I would like to have a button that uses an extension or script. Once you click the button, it prints the QR code for that specific record only. Does anyone have a suggestion on how to achieve this?

I'm trying to delete an entry from my airtable through the API (on voiceflow to be specific). I have experience with the API as the rest of the application uses many GET and POST commands that work just fine. The problem comes when trying to delete, where I keep getting error 401 (authentication required) despite including my bearer API key as a header. I'm using an exact copy of the DELETE example in my airtable API documentation.Anyone have any ideas if this problem could come from somewhere else? Or if it's just a bug to do with my application? Thanks!

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": "clos

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 prim

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"