Ask the Community

Hi,I have table of properties, faults and professionals.When I have a fault, I create a new record in the faults table and select the property where the fault occurred and the professional who worked on the fault.If the problem has been solved, I change the status to "Done" and send an email (with the help of automation) with a request for payment (that the customer will transfer payment to the professional) for the work.I want that when I buy the materials to deal with the problem, I have the option to add it to the email sent to the customer.For example - if an apartment had to be painted and there was no paint, I went to buy the paint, now when I mark this task as "done" I would like the customer to receive an email with a payment request for the painting work (payment to the professional) and also for the paint (payment for the supplier) when sending a request for payment I send the customer the private bank details of the professional/supplier

Hi,I work for a property management company.I made a table for assets, faults, professionals and suppliers.When there is a fault, I add a fault to the fault table and link to the property where it happened.In addition, I add to the fault the professional in the fault.When the fault is over, an email is sent to the customer to whom the property belongs and in the email there is a request for payment for the fault with the professional's bank details (for bank transfer).So far it's working great!When we need to buy materials for the breakdowns.I wanted to do the same as with the professionals only with suppliers.I mean, when there is a malfunction for the purpose of the example - painting an apartment - and there is no paint then we buy from one of the suppliers, at the end of the malfunction I would like to ask the customer in the email of the automation to transfer payment for the supplier as well.It also works great!

Hello! I'm trying to figure out how to count the number of times that a linked record appears within a cell in a lookup field, but I'm completely stumped.My base contains information about hockey leagues and clubs. There are several tables, but the important ones for this problem are:Leagues: Each record represents a different hockey league.Clubs: Each record represents a different hockey club.Seasons: Each record represents an individual season played by each league.In the Leagues table, I have a lookup field that links to the Seasons table. This field (League Champions) contains a club name from every season, with some clubs appearing multiple times (e.g., the club Färjestad BK appears 9 times).I would like to be able to use this in an interface for each league, where I can use an element to create a table/list that shows how many times each club won that league (e.g., Färjestad BK were league champions 9 times, Växjö Lakers

Hey everyoneBackground: we are using AT as a CRM Goal: track who of our customers are at which eventsMy solution thus far has been to have a People table and an Events table within the same base. Within each event, there is a guest list field that links to the "name" field of the "people" table. The issue is, I want to be able to quickly link guests to events, i.e. by uploading a CSV guest list and then that automatically linking to the "people" list. Ideally, on the "People" i could create gallery views for each event. I'm sure something like this is possible  but can't figure out how to do so! anyone have any guidance?? 

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 idea

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

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

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(F

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 successf

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 greatl

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?