Ask the Community

Hi AllI am having issues with linking information between tables.I have the below linked:1) Master Order Table 2) Order Line ItemsI wanted to create a new table called Purchase Orders (POs) which is just relevant purchase order information (excluding any sell price etc from the master order) so i can send the PO to my suppliers.The issue i am having is that the information on the POs table is not linking with the Master Order or the Order Line Items tables as per attachments. Please help me with solving this.Thank you!

Hello.I am trying to find records where a rollup results is less than or equal to a function. Both are formatted as numbers, and both work when I search for records in each column independently. Is there a solution for this?

When mapping a WordPress CF7 with airtable, Airtable allows Contact Form 7 to write into the field Email if it's an "Email" field-type, but not if i convert it to a linked table.I would like that the field "Email" inside of the table Messages links to a table named Email, where Email is the PK. Like this we'll be able to see all related messages.Unfortunately CF7 outputs an error with this setup. Is it there a workaround? Or should be build an airtable automation that reads the contact form user input that goes into the (unlinked) Email field and updates another field named LinkedEmail?So, either CF7 links messages to the Emails table, or we will have to auto-link using an automation.What's your opinion on that?

Bonjour à tous,J’ai besoin d’un (gros) coup de main pour créer un calendrier sur airtable... Mon cahier des charges est écrit et précis, mais je débute seulement sur airtable et j’avoue être trèèèsès, loin d’avoir les compétences qui me permettraient d’arriver à mes fins. Bref, si l’un d’entre vous acceptait de m’aider, je suis preneur

Hi allI want to build an Enquiry form that will have prefilled information and prefilled options based off the logged in user. e.g. they may have multiple delivery locationsI also want to have an option to create more options for adding products (as per below)Thanks! 

I have a somewhat complicated formula I wish to create, and as a formula n00b, I don't know where to start. Here's the problem I'm trying to solve:1. I have a series of tags I enter into a single text field, where each tag is separated by a comma. I have two conditions to meet before I list a product with the tags, otherwise, the Make.com automation won't work, and I'll have to spend a fair amount of time deleting a partially created listing and re-editing the record in Airtable. These conditions are 1) I can't have more than 13 CSV tags in the field, and 2) I can't have any duplicate tags.2) I would like to create a formula that displays an ❌ in the formula field if the tags CSV field has more than 13 tags AND/OR duplicate tags. If both conditions are met, display a ✅.Thanks in advance to all the formula wizards out there willing to help! 

Thanks in advance for the help! I want to find a way to use an automation to clear out a pre-filled field when a record matches conditions. For example: We have a check column to see if a task has been completed. We also have a collaborator column to see whom the task is assigned to. I want to create an automation to just clear the collaborator column when the task was completed without deleting the entire record (for archiving purposes). Any way to do this? Thank you!

I never need a field to be not editable. Only a few people use the base and everyone needs to access everything (it's a CRM). Having to set every single field on every single table and view and every place you ever see a field value. It's really awful.

I'd like to be able to create an ordering front-end for our farm. Ideally I'd like to be able to do this through airtable, so i can keep all our data well intergrated and streamlined.Here's my workflow:- Estimate quantities available for harvest on our harvest and delivery day (2 days ahead) - share that with our wholesale accounts. For some products, I communicate a range (i.e. "we definitely have 10kg of parsley, maybe up to 12kg"). Some accounts give a range of how much they'd want - e.g. "we would take a minimum of "10kg parsley, but if you do indeed have 12, we'll take all of it").- Receive orders. If there are conflicts in how much different accounts want, then I have to communicate asap with them. Generally its first-in-first-served, but there are 2 important accounts that have been supportive from the start, through mistakes etc, so I prioritise them.I'd like to be able to handle this with forms that I email to the accounts. My ideal workflow would look like:- Check the items a

I'm trying to use the options from a single select field as an 'input' selection in my script. I'm not sure if Airtable allows this. So far I have: let selectTable = base.getTable("Courses"); let selectField = selectTable.getField('School Year'); let schoolYears = selectField.options.choices; console.log(schoolYears) Which provides Then I make an array from just the names: let yearNames = schoolYears.map(record => ({name: record.name})) console.log(yearNames) Which gives:I'd like to then use those choices as an input: let selectYear = await input.buttonsAsync('Pick a year', [yearNames]); But this gives an error that you need a string. Would this be possible to use? It seems to want a full object literal list and not a variable like this. 

I need to be able to quickly select products to send out as a pricelist each week. Since all my data is in airtable, I'd like to be able to do this from Airtable, however I am unable to find a tidy way to do this with airtable.. The issues I have doing this directly from printing in airtable or interface designer:- It's quite ugly looking- I don't see a way to include branding or other info- Very limited formatting options- Airtable STILL has no wrap function (so products with longer descriptions are problematic).Page designer nearly  does what I need it to (automatically feeding record info into a template) - except that it only lets you do one record a page!The only semi viable options I have is downloading a view as a CSV, opening that in sheets to format it nicely. This level of repetitive action seems unnecessary on a week-by-week basis... Ideally I'd like a Page Designer extension that lets you format a table/grid..Does anyone have any suggestions of an easier

Hi all--We are a publishing company and we sometimes publish the same content multiple times throughout the year. We have a field set up "Publish Date" that shows all of the dates. The problem is when I try to have these feed into our general publishing calendar view, I can either only choose between the Minimum date (the first date) or the Maximum date (the last one), I can't figure out how to show both dates on the calendar (without having it span across the entire time in between the two dates). Is there possibly a way to separate the dates into separate entries and enter them into the calendar that way? Thanks in advance!

So Im pretty new to Airtable and not sure if I am going about this the right way and wonder if someone can point me in the right direction if not. Basically I am trying to use a multi select option to calculate the Extra costs involved in a job with solar installations which I have a field named Extras. So lets just say I have an option of installing on a tile roof which costs an extra 50 which I have added using the formulas below in a separate field called Extras Total.  IF(FIND('Tile Roof', Extras),50) +IF(FIND('3 phase', Extras),200) +IF(FIND('Solar Hot Water Removal', Extras),800) +IF(FIND('Optimiser', Extras),100) +IF(FIND('Panel Removal', Extras),20)  Where I am having trouble is with panel removal and optimisers there may be more than 1 panel or optimiser so is there a way that I can add multiple amounts to these particular options. My only thought would be to add multi options for each one e.g 1 panel removal, 2 panel removal, 3 panel removal etc. But this way w

Hello! Apologies if this is already solved or discuss or I am just missing something obvious. I am trying to create a button on an interface that does the following: Run an automation that has a custom script, create a new record in a different table, and then navigate the user to different section of the Interface. I don't see any automation actions that would navigate the user. I do see that a button can be used on its own to navigate the user to a different section of the interface, but I don't see any way to combine these methods into one swift action. Is something like this possible? Thank you in advance for your help! James 

I use the found records automation to create my report and the date is in the correct format, her DoB is 10th JulyBut when I add this as a grid of records to the Send an Email automation, the DoB shows as 7/10/1953 i.e. 7th October.and this is what arrives in the recipient's email.   

I'm managing Airtable for a large team of 60 people. We've designed a variety of interfaces for their needs, with the goal of preventing them from going into the base and tampering things.However, we still want them to use the CSV Import extension, which unfortunately only exists with Base-Editor access. Does anyone have suggestions for importing CSVs (either with a script, integration, or anything) with just Interface access?

Hi all! miniExtensions (https://miniextensions.com/) looks to have a few solutions that would give me the functionality I really need for my base. I can’t seem to find any posts from folks who are actually using these extensions, as opposed to just miniExtensions promoting their own extensions. Has anyone had an experience with miniExtensions as a customer? Cheers, Kira

I can call my endpoint (with hardcode variable) it's successful in requesting ( got a response ), but when I try to use a variable, params from the record. It's stuck on the CORS problem, but I am not sure why,(both variables are the same, the difference is the one from the variable does not worked,and one from hardcode is worked)//if I used hardcode in data, it work fine.const requestApi = async (params) => { const myHeaders = new Headers(); myHeaders.append("api-key", "xxxxxxxxx"); myHeaders.append("Content-Type", "application/json"); try { const requestOptions = { method: "POST", headers: myHeaders, body: params, // JSON.stringify({ // "pid": "xxxxxx", // "firstName": "xxxxxx", // "lastName": "xxxxxxx", // "birthDay": "xxxxxx", // "laser": "xxxxxx" // }), }; const response = await remoteFetchAsync("https://xxxxxxxx", requestOptions); const result = await response.text(); console.log("Record updated successfully."); } catch (error) { conso

Hi,I am trying to run the following script based on my screenshots and I am getting an error “Your script exceeded the 512MB memory limit.”.What am I doing wrong and how can I fix this? Thanks! 

I am trying to add an AND statement to this formula:IF(     {Date Received} = "",     "Unsure of due date",     IF(        DATETIME_FORMAT({Date Received}, 'MM/DD') = DATETIME_FORMAT(DATEADD(NOW(), -14, 'day'), 'MM/DD'),        "TRUE",        "No match"   ))The AND statement I want to be if a cell does not equal a certain value from a dropdown. So I think on its own, the and statement should be something like:{Status} != "MoveOn"I just can't figure out where to put each piece and how to close the parentheses. The screenshot is my table without the AND part of the formula.Any help would be greatly appreciated!

Hi,I have an automation which sends emails reminders to a set of users every week. When it emails the users, it's setup that I get CCd on the reminder email also.After the email is sent, the automation updates a field of the next reminder date (which is a formula that sets the date to 7 days from the current reminder date).This works sporadically which is strange to me.Why might this happen? And what's the fix? 

Hi all,1. In my Interface dashboard, I'd like to be able to display the percentage of companies I got in touch with against the monthly goal of companies to contact. As of now, I visualized this as a bar chart, but I would like instead to visualize it as a progress bar.2. In my pie chart below, I get percent values with one decimal digit. Instead, I would like to display integers, but I couldn't find a feature to edit the number formatting.Do you guys know if what I'm looking for is possible?Thanks.PS: I saw that people had already asked a similar question, but since the threads were quite old I thought I might as well resurface the topic.

Hi, So I have two tables. One table has a bunch of clients that have been assigned a certain assignee/person. The second table wants to be able to keep track of how many clients are assigned to each assignee/person. How would I be able to do this? I've tried to link and lookup and count but nothing seems to work. Thanks. 

Dead link! 

Hello AT Community, I am looking for a formula that capitalises the first letter of every word before the " |"  in a string. 3 examples belowEXAMPLE 1The output for "ARCHITECT | Tom Jerry” to be ArchitectEXAMPLE 2The output for "BUILDING AUTHORITY OFFICER | Road Runner" to be Building Authority OfficeEXAMPLE 3The output for "CIVIL ENGINEER: Energy Performance Certificate | Bugs Bunny", to be Civil Engineer: Energy Performance Certificate Thanks in advance