Ask the Community

I am using airtable to manage information related to a landscape design and installation business.   For most products, we purchase them as we need them and don't hold inventory.  However, for plants, we sometimes order in bulk (lots of 32 or 50), hold them in inventory and then use them as projects come up.  Plants that I order in bulk come in size a or b.I would like to be able to visualize projected inventory at points in the future (2w, 1m, 2m) for each plant in the different sizes we can order it in.  (i.e. today I have 0 of x, but in 2w after a purchase of 30 units and sale of 20 units I will have 10)Currently, I am using the following tables and fields to track plant inventory in and out.  The plants table is linked to sales and purchase by the SizeAIn and  SizeAOut rollups.  It can then calculate inventory by SizeAIn - SizeAOut.  I can use filters so that it excludes proposed sales/purchases or filter by date.  Is this the most

Hello, Very new to airtable, I would like to create a weekly timesheet for all employees similar to the attached images, Is this possible? Thank you!

My automation has a conditional step that runs if these conditions are met:{Date Assigned GMT} is on or after 10/01/2024 AND{Date Assigned GMT} is on or before 10/31/2024I am located in the Eastern Time Zone. I am aware that automations do everything in GMT.How can I prevent this step from running until it is really 10/01/2024 in Eastern Time? 

Hello every one.I have, i thought it was a quite simple task, question.i have something i want to push to my airtable database, from nodejs server.For example: "QWETG$E%&$%&U%&UHHRE" it should be added to the database.It has only two colums: Name, and Date Created.Unfortunatelly i have no clue how to do it.I have a Token. basically i should simply force my server to to call a link with token and string somehow combined,..... I am very clueless.Thank you for the help

Hello guys,I'm trying to build a script to automation fetch the youtube video's transcript to Airtable via API keys or Oauth 2.0 via Make.com. But when i'm trying to retrieve the transcript and fetch the data to Airtable, i cannot do that via API, so I have to create OAuth in Make.com. This is a script i used, but Airtable noticed me an errorconsole.error"Error fetching transcript:"▶{code: 403, message: "The permissions associated with the request are not sufficient to download the caption track. The request might not be properly authorized, or the video order might not have enabled third-party contributions for this caption.", errors: Array(1)}Anyone has experience this issue or resolve it before. Pleases, let me know hownThank you so much

Hello, I am trying to automate Airtable with JIRA using microsoft Flow. At my company we have restrictions that imposes that I use the Microsoft Solution. I would like to create a JIRA ticket every time I created a record in my Airtable Table. In microsoft flow I need a trigger to start the flow. Can someone know how to get the airtable trigger for when a new record is created? Thank you

So I have makerspace with 100+ members. Thanks to airtable, we have a status if they're active or inactive (current members vs members who quit). Many of us make files that we share with the membership for lasercut SVGs, or 3D print files.  Within our airtable database we know their status, name, wiki account and wiki password. By wiki, we have a dokuwiki site that members have sign-in capability to. If they quit, we can turn that off.  So we can control if they can see the url to download, but this doesn't mean that they can't be sent the url by a friend to download, or have a saved list of links before they quit.So I'm thinking that legit members can use a form link to request a file, then we write an automation that gets the file and emails it to them.  Also, to complicate matters a little further, I'm thinking about storing the files on a google drive or dropbox to avoid attachment size limits on our airtable team account, but I am thinking this can be handled in jav

Hello, I am trying to use the “Update Google Doc” automation but I do not understand how to fill the “Content” section with the “Select field” option. I have created a google doc template with fields using the google add-on “Fillable Document”, but when I click on “select field” option in the Airtable automation, I do not see any field to select. Does anyone know how I have to set up my google doc template so that Airtble identifies fields from this file? Thank you Pascal

Hi guys,I currently need a way to convert a single/multiselect into a string that I can push through Make into a dynamic template on Sendgrid.I am bodging it with a SWITCH formula"SWITCH({brand}, "Brand1", "Brand1, etc,etcFirst it feels messy and I bet there is a easier way, and it falls flat when you turn on the option for a user in an interface to add their own input.I would rather keep it in Airtable, so someone in an interface could select a single select option and then edit the output if desired.Make.comI have tried to do this through Make, but I am getting some strange results with it picking it up the single select, able to convert it to a string and even output it on an email, but this only works for the value that was selected during the construction of the make. As soon as it in changed it doesn't work (no errors, just doesn't show up in the dynamic field).This has stumped me! Any advice would be great 

HiCertain users in my organization are using an interface to submit work order requisitions and getting a random and sporadic message on some requisitions mid-way through the submission, but not all users and not all the time. The message reads "Project Hidden, The project might have been edited, or your permissions changed." Any ideas what may be causing this or anyone else seen this message before? 

So I have a single Attachments field in a table that allows for multiple individual files to be attached to a record. I want to create another field that counts the number of files that have been uploaded/attached to that record. I then want to them pull this number into the primary field of the table to provide a quick way to see how many files have been attached to the record (e.g., 5 videos, 11 screenshots). However, the built-in ‘count’ formulas seem to be only counting the occurrence of an attachment for the record, not the number of individual files within the record; so as a result, it is only showing things as having 1 or 0 attachments, even though there are multiple individual files that have been attached to that record within the Attachments field. I came across an old thread about counting attachments (for some reason it’s preventing me from including the link here) but it seems outdated given the formulas now available, plus I could not get the formula to work at all. Any

Hi, I’m looking to use the interface designer or any other airtable solution to filter records with shared users in an easy way. Similar filtering to an e-commerce store like Best Buy. So someone could choose pull-downs from linked records to say they want a 1. “laptop”, 2. “white color” and the page would show all records that meet those criteria. I know this can all be done within an airtable base but I’m looking to simplify it for less tech-savvy users. Thanks, Jordan

I’ve attempted to follow the recommendations here to detect duplicates in a field but have not been successful and could use some expert eyes on what I’ve implemented. I did put a reply on that thread but since it’s a couple of years old, figured I should start my own question. Here are 2 screenshots from the 2 tables in play. Anyone see where I went wrong? TIA!

Before signing up, I’d like to know a couple things about Forms and Interfaces. For my use case, Forms will most likely be the most common data entry means. Interfaces will be the most common way my users will edit a record’s data. Can my users not go straight into the “Open form” view of a form from the main tables tab? I don’t want them to have to click the “Open form” button to use the form (and I certainly don’t want them to be able to edit a form’s layout, etc.) How about an Interface? Is there no way to launch an Interface from a table screen? Like, why isn’t there an entry in the sidebar like there is for all the other views for that table? Thanks!

Hello, I've got a Base where each record is a person. I'm trying to create an automation that will share that record as a URL with each person (using their email address in one of the Fields), but not ALL the Fields in the record. I know I could manually create and send Shared Views that had the Fields I wanted, but this is hundreds of people, so I can't do it manually and I'm looking for a way to automate it.

Hi guys, any help here would be great. I am trying to make a list of records automatically send to me every 24h, this list is based on status, all of this works, but my problem is I can't seem to get the list to be clickable?Tried both:[Link Text][List of 'Base record URL']and[Link Text](List of 'Base record URL')Any help to make these clickable would be great  

How can I have an automation (or formula) return only the first record in a manually sorted table or view? I have clients submitting tasks and manually sorting the tasks according to the order in which they would like them completed, and we only work on one task at a time. I'm trying to build an automation that changes the status of the next task ("next" is determined by the manual sort field) to "in progress" when there are no longer any tasks for that client in progress. How can I do this without creating views for every client? 

Hi, community! I need some help with this. I'm setting up a bank reconciliation in Airtable and need a column to record all the transactions from my bank account. Additionally, I'd like another column that shows the running balance for each transaction, reflecting the total income and expenses up to that point. I'm not looking for a single overall balance, but rather a balance that updates with each individual transaction.

For those who can help, would you please let me know how to count the number of attached files in the Attachment Field in Airtable?

I have two tables:Key Source FormulaSourcesWithin the Key Source Formula table I have a field called URL FormatAn example entry is:   https://www.website.com/search/?q="Company"&t=weekIn the Sources table I have a value called Company Name Texte.g. Apple, which I want to substitute into the URL Format. This should return a result like:https://www.website.com/search/?q=Apple&t=weekThe SUBSTITUTE formula I have is:SUBSTITUTE({URL Format}, "Company", {Company Name Text})It returns #ERROR.I have even used the Airtable AI to write this formula and it doesn't work.Any help much appreciated

I've created a table where I have a multiselect field, and then grouped the data by that field.The effect in my table is that each unique combination of selected fields from the multiselect column has it's own group. So for example, if one record has "A" in that field, and another has "A" and "B", I have one group that JUST has the record with "A", and separate group for the records that have ONLY BOTH "A" and "B" (so the first record with ONLY "A" is not included in that group).I know some people don't like this but I actually want it this way - and what's frustrating is that now when I'm creating a List Interface, it works the opposite! So my list of records is grouped in the interface by that same multiselect field, but now the records are duplicated across groups.So, the record with only "A" is showing up in the group that is labeled "A" only, AND in the group that is labeled for both "A" and "B".Is there a setting I'm missing to get the list view to behave the same as my table, or

I created a very mobile-friendly app using AirTable, had participants download the AirTable mobile app, and attempted to showcase the mobile interface with about 80 participants in a room. Participants complained of seeing completely blank screens or only partial amounts of data showing up.Is the Teams Edition insufficient for this use case, and do I need the business or enterprise version to handle this type of traffic? *P.S. The wifi was not the issue. 

I've developed a solution on top of Airtable tailored for real estate investors. This tool helps manage properties, units, tenants, and leases efficiently. Recognizing that each investor has unique needs, I am also offering customization services to fit specific use cases and requirements.My goal is to charge a monthly fee for using the solution, with additional fees for customization services. However, I’m uncertain about how to maintain control over the solution given it's built on Airtable. Specifically, I’m concerned about the following:Preventing Unauthorized Distribution: Is there a way to prevent users from copying my solution and distributing it for free?Access Control: How can I ensure that access is removed if a user stops paying?I would love to hear how others handle these challenges. Is it realistic to think that I can productize something built on Airtable? Are there any best practices or strategies for monetizing Airtable solutions that include both a subscription compone

So I’m a real estate agent and I use Airtable to keep track of all my deals. I have one block for rentals. In rentals it’s very common for a prospective tenant to want to see all my current active listings. I typically have 40-60+ rentals at any given time, some times more. Right now, when people ask for my list, I ask for their search parameters, go through the entire list myself, then respond back with a few listings. The problem is I have 25-75 people reaching out a day and 40-60 listings, plus an entire buy/sell side of the business. It’s becoming impossibly time consuming. So when I heard about the ability to create a shareable link to my up-to-date database, I got really excited. Especially when I realized I could hide fields that are for internal use only and I do not want prospects to see. But then I realized the primary field is the address of the unit and there is no way to hide this (but it’s really important to hide addresses for a lot of use cases I won’t get into right no

I’m currently selling my airtable base as a product. How to do that? Is there a way to create a user base that will be able to view the database? Collaborators would work best, but I don’t want them to see my changes and emails of other collaborators