Ask the Community

Hey everyone!I need to have multiple record pickers updating a list at once. I saw another post where someone commented on using a filter to group the record pickers, but its not really making sense to me. Im super new to airtable, a really detailed approach to this would be super appreciated! Thank you for any help! 

Hello, I need help figuring out what I am doing wrong. In the main table, I track daily work, and in the other table, I track inventory. There is created a link record from the main table to the inventory table. From the main table, I am selecting the available items for sale. What I would like the automation to do is find the records that I have assigned and copy the quote number from my main table to the inventory table. I know I can do a lookup the problem is that I have too many records that would have to backlog. Here is what I am trying to accomplish with the automation, but it keeps failing. After I update that Quote Number field and select the items from the inventory table, I am triggering the automation from the checkbox field. Main table view: Inventory table (Resale Items) view: It finds the records. Automation fails, even though it finds the Record IDs.

Hi, I'm sure this question has already been asked but still can't find an easy answer. It seems as though it should be quite simple but I can't wrap my head around it.As per the screenshot, I would like to automatically combine Linked Record entries from multiple fields into 1 field. The 1 combined field needs to keep this data as Linked Records, and not as formula text.The  Linked Records are from another Table in the same base.So basically, if this automation or formula was setup properly - the "ALL COMPLETED PROJECTS" field would contain 3 Linked Records: "Pen", "Pal" and "Pol".Is this possible?

Not sure if this would be a roll up field, script, or automation but I am trying to combine multiple linked record fields into one linked record field automatically. For example: One record has multiple linked fields “Assignment 1”, “Assignment 2”, “Assignment 3”, ect. and I want them to all be shown in an “All Assignments” linked field automatically. Is this possible?

The field in question is an Attachment field.This is what my POST looks like (from Power Automate Desktop. Note variables are enclosed in %s). The field in question is highlightedI receive this error{"error":{"type":"INVALID_ATTACHMENT_OBJECT","message":"Invalid attachment object for field Lawsuit Docs - PDF: \\"https://drive.google.com/file/d/1Y_4OYYb7NjIKremnh3aiuFFEh6smESFK/view?usp=drivesdk\""}} TIA   

Hi, I have a column where the tax of products is being calculated and in the field I have the formula to calculate the tax since it is the same for every product that can be taxed. I have certain products that do not include tax, so how to do write out a formula, or override my current one so these products do not automatically calculate the tax. Thanks!

I have a Purchase Order table and an Expenses table that when records are created and automation pulls the records into the Budgets MASTER LIST using roll up and look up fields. Each Budget is allocated to a department (Autism Liaison, Events, IT & Comms etc etc ) so the Primary field for Budgets MASTER LIST is a forumula using IF to pull in the lookup Budget ID from each entry so I can group the entries by Budget ID. (hope this makes sense so far).I also have another table that lists all Budget Categories (called Annual Budgets) that contains the annual budget amount and on this table I need to show running balance - remaining budget etc etc (don't worry about that I have already set that up), BUT it relys on having the linked field in the Budgets MASTER LIST to do this.So, all I need is each time a new record is created in Budgets MASTER LIST, rather than me having to manually select the linked field 'Annual Budets' and select the budget related to it, is there any way I can say

Hello,I am assessing Airtable as a method to store data that will be used to control a contact centre system.This system will use REST API calls to retrieve data in JSON format.This works ok but I am a bit confused about the Checkbox record type, which seems to be a boolean type, does not act as such for API queries.If the Checkbox is ticked the JSON response contains the filed name and a value of true. If the Checkbox is not ticked the JSON response does not contain the field name. My expectation would be that the JSON response should contain the field name and a value of false.Not having this will cause the parsing of the JSON response to be more complex than I would like. I will have to code for the key:value pair being missing rather than a simple true/false situation.Is there any reason for this working the way it does? How have others coped with this design quirk? 

i have a script step in an automation that i have been using for many weeks. it has been working as expected- with many runs per day. i've been rebuilding some automations, so i've been running them a lot as i test them. just now, the automation stalled out and finally failed:FailAn unexpected error occurred, please contact Airtable support.When i tried to test the script, i received this error:ERRORThere was an unexpected error while executing your script.the script in question is: output.set("date", new Date().toISOString()) I started using this script in December to replace having a "Today" field that used the Today formula. I use the script to update a field that displays when the last automated activity took place. it is used in many automations and all are now failing. Any suggestions on how to resolve this?

Hello,I am trying to link a cell in 1 base to a cell in another base. Due to formatting differences, I cannot have it be a full column linked to another full column.Thanks!

We are an Enterprise user and heavily dependent on Airtable Automations working.On Monday, Airtable automations had an unreported outage and performance issue spanning over 12 hours that went unreported on status.airtable.com.Support made us aware of a fix after 12 hours.Now, 2 days later, automations are now failing again and pending.This is unacceptable to Enterprise users and we expect issues like this to be resolved within an hour at the latest.  This is a commercial solution, and our entire business operation is at a standstill due to this.We have used only 20% of our automation runs budget allocation, and these performance issues are unacceptable.

I am trying to send emails using the Gmail automation. The field I am using to route to the "To" field in the automation is an email field. The problem is, some of the emails were inputted with a space before or after them, which I suspect is preventing deliverability.I tried using a formula field to trim the email field, but I route the formula field to the "To" field in the Gmail automation, it shows up blank as though there is no text in the formula field.What is the best way to eliminate spaces in a field you intend to use in the Gmail automation's "To" field?

For the last couple of weeks, we've been running into an issue when attempting to scroll down stacks in Kanban views.  The view will not scroll when using the mouse scroll wheel or when clicking the scrollbar.  It happens at random times, too, with no noticeable pattern.This is happening with multiple users and multiple Kanban views so it doesn't appear to be an isolated issue.On a related note — at the same time that this issue started, we also noticed another issue where it takes much longer to scroll down stacks that are of considerable length (i.e. hundreds of records).  This was never an issue up until a couple of weeks ago.Is this a known bug that is being fixed?

I have made a stock taking system in airtable. And I have a whole list of items with current stock values. I would like to the end of every financial quarter take a snap shop of the current stock value. Is this possible?I've tried to play around with scheduled time trigger and the repeating group action, but I don't seem to be able to find a way to tally this up. Is there a good way to do this?

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided municipality and local chapter. This information we gather from a Typeform. I have matched the options in my Typeform and Base/Field as a single choice. It works well until den, but how to make it work in Airtable is the next step. This is not in the US. There are around 5000 post numbers that are going to be distribute in 15 "municipalities". Some chapters allocate more than one municipality.Is the single choice the best one for this purpose? Would an IF formula work?What is the most effective way to do this with that amount of data? 

Hi everyone,I'm looking to create a use case catalog to help me define the functional requirements of my clients, such as data and system integration.The catalog should include a unique identifier for each use case category and allow me to choose which categories to include in a report and which to exclude, depending on the client's needs.The ultimate goal is to create an environment for the client to experiment with the use cases and required functionality without exposing them to the full repository of use cases and their categories.The goal is to eventually generate summary insights through a dashboard/summary table that shows the use cases by data or integration slices.Has anyone come across a solution like this? Do you have any ideas on how to approach the topic?Thanks in advance for your help!

Hi there - I've set up a table that I want to use to 'score' certain projects by quarter. I.e. at the end of Q1, Project 1 received a 50 score, Project 2 received an 80 score, Project 3 received a 100 score, so on and so forth. Currently in my table, the projects are separate records, and I have four columns - Latest Score, Q1 Score, Q2 Score, Q3 Score, and Q4 Score. They are all number fields. I've inserted a photo below.Is there a formula that would enable the Latest Score field to automatically reflect the current quarter we were in without me having to update it manually? Thank you!

Hi all, I am using Airtables to set up my cost database for my cafe.For each dish, the items can come from 2 sources. 1 -  A raw material table - i.e. chicken, eggs, which i have already listed it's unit cost. 2 - From a Prep material - i.e. like pasta sauce which we make in house. This table, I've already calculated the cost per portion for each item (making reference to items in table 1) Now to build a recipe, I need to pick items from both table 1 & table 2.   I am not sure if this is possible to have a selection field that reads from 2 table.  or I need another way around it? Thanks!

Hello,My team and I have many due dates scattered around as we are show managers.I recently built in a formula based off of weeks out from show time that the item needs to be completed, and how long it takes to complete it to in order to find out when we need to start the task.I'm currently trying to send a weekly Monday email at 8am that sends to each assignee informing them on the upcoming start task dates coming up within the next week but have run into an array of issues and I don't know which angle to take it on.Is it possible to automate this or is this too many fields? I have been reading a bunch of community forums but all have one part of what I need, but not completely.Please note:Some tasks have multiple assigneesThis is for a view within a viewAny insight helps as I am fairly new to Airtable's automations and feel like I've done everything.Below are the column fields on my base.Once again, I'm trying to complete the following automation:Email individual Assignees every Mond

Hello,I'm working with the following table in Airtable:My goal is to create another table that simplifies the data. Specifically, I want to generate a single row for each unique ID, where all the text from the 5th field is concatenated into a single cell. Here's an example of the desired output:"Consider installing a longer bath handle. Doesn't completely rest on the bathtub.""Repair chipped tile due to shower column installation. Replace the shower column with a wider one to conceal the defect. Alternatively, replace the tile.""Adjust bathroom cabinet drawer."Important Note: I have thousands of IDs, each with multiple text entries like these. I need to concatenate them to streamline the process of sending email alerts. I've tried various formulas, but I'm a beginner in Airtable.I appreciate any advice or guidance you can provide. Thank you in advance !

Hi, I wonder about how to setup my base for the following?I have a simple Table with a series of records, and each record has a 'SPECIFICATION' field (basically a "YES" / "NO") indicating if we have the spec. for this item:I would just like to somehow summarize if *ANY* of the records there have a "NO" in them? I don't need a count or anything like that, just a flag or note or something to say if ANY items are incomplete? Is this possible somehow? Can I show this another 'Summary' Table in some manner?thanks for any suggestions!@Ed12_p_may

I have a list of elements in a single table I want to be able to demonstrate many-to-many relationships between them. I created a linked record to select elements, but it doesn't update in the record for the selected elements. How do I get it to appear in both places?In the screenshot below, when I link "Element A" to "Element B" and "Element C", I want "Element A" to populate in "Element B" and "Element C" records too.But "Element C" also needs to link to "Element A" and "Element D" and "Element D" needs to link to "Element E".How do I set up this kind of relationship within a single table? 

This is Conditional Logic that is very simple, one of the conditions is the "has any of" and that is selected from the single select field as  "CTC" and then it just fails and shows the result from that field as [object Object}. What is causing this? See attached screen shot.

I guess this related to an integration, but it's not an integration-specific question. We have records that typically accompany a unique number. Sometimes, we will have a record that doesn't have a number. To identify them as records where we've thoughtfully considered them to be records associated with no number, we want to use 0000 as the default, where a single 0 might mean we just forgot to enter the appropriate number. I'm using a Number field currently -- and I think the field needs to be a number field for the integration. Is there a way to get a Number field to display 0000 instead of 0? 

I have a synced table which I would like to not sync anymore, but I want to keep all the data currently in it.  I know I can just duplicate it, but that would mean I lose my interfaces and automations.  Anyone know if there's any easy way to turn a synced table into just a regular table?