Ask the Community

I’m averaging 3 columns, all rollups. Note that I have this formula in them, so certain cells are blank: IF(ISERROR(AVERAGE(values))=0,AVERAGE(values),BLANK()) The 4th column, where I want to average THOSE columns, has NaN if all 3 columns are blank. Which makes sense - I just can’t figure out how to get that 4th column to BE blank if the result is NaN. The column currently has this formula: AVERAGE({Value 1},{Value 2},{Value 3}) I tried to essentially mimic what I’m doing in the other columns but nothing I’m trying seems to be valid. Thanks!

Hello,I am currently running into the base exceeding automation limit and am trying to come up with a way to solve for multiple automations we have created by using a formula field or look up field.Currently, we assign users to certain tasks and we have another field that displays their phone numbers (long text field).  I am trying to set up a formula where IF a user is selected, it would then lookup/display from another table that user's phone numbers that are list on table 2.Is this process possible with Airtable?

Currently I have one apartment per row and the tenants #1 name, tenant #2 name, tenant #1 email, tenant #2 email as column name with the tenants info on the row. This hard to export the data this way or to sync to a crm with zapier. what is the best way to organize the contacts/ tenants in general so that easier to export or sync via zapier to a third party crm like cloze.   

Hi!I have an automation that runs through a few steps when a new record enters a form submission view (pictured below). I use the 'Find records' function to search a distinct set of contacts against email address -- if successful, the records are updated with new values. If unsuccessful, a new contact record is created. A few supplemental records are created as well.  The Find Records function is specifically looking for the Record ID to move into the update functions. In tests -- including test runs of the live automation -- everything works fine. It locates the Record ID, updates it in the next step, and everything is great. However, when I activate the automation and it runs live, it fails at the Record Create (or update) stage every time. And the error message is identical every time: 

Hi, new to airtable. I have several databases related to various types of inventories. I just want a simple interface to be able to select, for instance, a product. Then have the database properites for that product presented so I can edit them. For instance, adjust quanties. From the little bit of googling I have done it doesn't seem possible with airtable's built in tools. 3rd party tool implentations seems like a house of cards. I have tried this in Notion and it quickly becomes too complicated to be reliable. Are there any other ideas out there? Thanks 

Hi all - has anyone been able to bring a base back UNDER limit after going over? I’ve deleted over 10k records and emptied the trash without luck. So basically - we hit 50k records… got the “over limit” message. I went in and cleaned up some stuff - still “over limit”.

I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again.I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link).  I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time.  The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error.  The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter.Any suggestions will be greatly appreciated.Thanks,Ray Porter 

Hello, Our records number has exceeded the 1200 limit however we then deleted several hundred records but the records number doesn’t appear to have reduced and the account is still warning we are over the limit. Can anyone shed more light on this or ideally how to resolve it? We deleted the records and then emptied the trash but it hasn’t changed. Many thanks in advance

TIA for any assistance.I have table1 (vuln) and table2 (archive).  I have an automation that when the record is created a UUID is created in the vuln table.  Then, when the status field of a record in vuln is changed form "new" to "closed" it creates a copy of that record in the archive table. What I need is another script that does the opposite.  When the status field of a record in vuln is changed from "closed" to anything else (basically re-opened) it needs to find the record in archive based on the UUID field and delete the copy of that record from the archive table.  I have the trigger setup, but I can't get the script to return the record. It returns the query, but the filter does not seem to work.  This would be easy if I could just do a view, but I can't.  I need to do a weekly purge of the data in the vuln table, but leave the data in the archive data. Hence the data copy.Her

Hi,We're working on moving automation mail (Gmail) content from the automations themselves to a separate table, where other than admins can maintain text.In the mail content there may be markdown URLs with clickable "friendly names", e.g. [Book here](https://www.calendly.com). I copied the whole text from the automation to "Long text" fields with rich formatting enabled. This approach doesn't however produce markdown URLs, instead they print out the raw markdown syntax ('[Book here](https://www.calendly.com)').Remembering that using CONCATENATE formulas for URLs works in achieving the "friendly names" I tried chopping up the mail content, and using a summarising CONCATENATE field as input for the automation instead of a Long text field. This works, producing "friendly name" clickable URLs.However, we have URLs in various places in the content, so chop

This function is available for the base. When I search there, the scanner symbol appears.Is this also available for an interface or a similar solution?I can scan using a form and would also like to be able to scan and then edit the product.

Use Case: You have a table of assets (library books, conference rooms, etc.) that you want people to reserve, but don’t want people to be able to reserve an individual asset at the same time it has already been reserved. Solution: No-Conflict Asset Reservations script by Kamille. This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period. Potential Users: Event Planners, Inventory Managers, Librarians, etc. Demo:

Hi all, I’ve been reading through a ton of different conversations about Airtable and recipe managers. and have found some amazing info on here. I’m currently a little blocked so maybe someone has more info on the following topic. Overall, I’m trying to create a database that has recipes where I can understand both the cost per recipe and the macronutrient breakdown for each recipe. Where I’m getting stuck is breaking down the nutritional values because some ingredients are in cups and others in tbsp. I’m trying to convert measures to grams but am having trouble connecting the conversion info to the recipe info. Generally my table is structured as follows: I have the following tabs within my doc Meals - it’s the meal planning tab Recipes - this is an overview of the recipes that feed in

How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week. For Example:I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates. Then I need records for 10/14, 10/15, 10/16, etc. To be starting week of 10/14.I also have the: WEEKNUM({Created Date}) formula, so if there is an easier way to turn that week number into the starting date of the week, I can use that as well.

Hi allI've been working on SAP Integration Suite for connecting to airtable and perform CRUD operations. I've created a integration flow for PATCH request in my suite and wanted to test it through POSTMAN by hitting the endpoint of PATCH iflow. The issue here is that even though i'm sending my json payload in the format of airtable PATCH request postman is throwing 500 error.My table in airtableNote that EmpID is also Single Line Text hereBelow are my configurations of the integration flow i've created to perform a PATCH operation through POSTMAN.Json payload i'm sending through postman to suite{            "id": "rec6jjMo9lBFpfI62",           

I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If today is 11/19, something due 11/18 should be Past Due by -1, but it shows -3. Given that it works for current/future dates, what am I missing here for the past dates?   

Hi,In our CRM we have several different situations, where reminder mails should start going out to contacts. Many of these are chained so that if the contact doesn't respond (e.g. sign up again after an event they cancelled), there will be reminders 1, 2 and 3 with some days time in between.Originally I created these as separate automations, it was simple and easy to overview. The triggers were "When records match conditions", like this (simplified):Reminder 1 - When record match conditions: "status = cancelled"Reminder 2 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 2"Reminder 3 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 5"But having several of these situations split up into separate automations eat up a lot of the automations quota, so I tried to integrate reminders 1-3 into one automation. So I used just o

Hi, I am trying to make a custom Slack script for my team where I can send the invitations to the users once the form is filled. For that I am trying to make a script that has an input field like Slack action where you can connect your account, select workspace and send the invitation. But I am not able to find how can I make those custom drop down? Do I have to code that out or can I use some pre-built things?

The goal is to have two options using an NFC tag:Assign EquipmentScan the NFC tag to assign "Tablet 1" to Employee X.Check Assigned ProfileScan the NFC tag to see who "Tablet 1" is assigned to and open their profile.Additionally, the NFC tag should always display the information "Tablet 1" visibly.

Hi all,I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number. For the checkbox fields it's clear: If it's checked, then value1, if not, then value2:IF(logical, value1, value2) + IF(logical, value1, value2) +  But how can I add the weighted values from the drop down menu in the formular?For example IF option1, then 3, IF option2, then 2, IF option3, then 1, otherwise 0)IF(logical=1, 1, 0) + IF(logical=1, 3, IF({logical=2, 2)) In detail, this is the formular which is not working:IF({easy to implement?}=1, 3, IF

I’ve searched high and low and can’t seem to find a really easy to use template that allows shift scheduling in an easy to use, drag and drop way like Sling or When I Work. I really don’t want to throw another app at my staff (I’m getting them used to AT as it is), and it would be nice to work within the AT ecosystem so I can use my existing staff info tables. Anyone have something useful? The ones in the existing universe are…not friendly.

Hello I started exploring using Airtable native AI fields; I would like LLM to read and process an attachment documentin PDF but the relevant field {Attachment} seems not to be available in the prompt design. Is it possible in some ways or do I need to resort to using OpenAI APIs and scripting? Regards and Thanks !

Is there a sequential order when a new record is created through a Form view? Can you define/control the order?

Hello!Let me first paint the picture of what I am working with:1 base, 4 tabs: "🧍‍♀️People", "🏝️️ Absence Management", "🏝️️ Leave types" and "📅 Public holidays"Relevant columns:In "🧍‍♀️People" one column has the staff "Name" and the other column has a "Leave Location" (which refers to the location they are based in and to which public leave should be based on)In "🏝️️ Leave types", we have a choice of "Leave" called: "🌞 Holiday", "🗓️️ Public Holiday", "🌞🗓️️ Holiday + Public Holiday", "🤒 Sick".In "🏝️️ Absence Management", we have date fields with leave "Start Date" and "End Date", linked fields to "🧍‍♀️People" taking "Name" and look up "Leave Location", linked field to "🏝️️ Leave types"In "📅 Public holidays" we have a

I'm trying to make a small CRM. Two of the main datatypes are Contact and Company. Clients work for Companies. When I get a new lead, I enter the Contact's information. When I do that, I'd also like to be able to create a record for their company if it isn't already in the Company table. So, bottom line, I should be able to either select a company, or type in the company's name and have it create a new record in the Company Table.I've created a simple interface to create a new contact, but as I understand it, interfaces only insert into one table. Is there any way around this? I thought about trying to add an automation, but it seems like the interface templates for adding new rows to a table don't support what I'm trying to do.