Ask the Community

Hello,I've created a database with a form and applications that allow each employee to make holiday requests.They can apply for leave over two months (example: from 10/08/24 to 16/09/24).My requirement: I need to know, for each employee, how many days of holiday they have taken each month.Additional information:I have the date of the first day of leave + the date of the last day of leave + the total number of days of leave (excluding public holidays and weekends). If they only take half a day, the number of days off is 0.5.What can I do?Thank you for your help.

Hi Can anyone help please? I am trying to find a way to count linked records in the same table I think someone may have found a work around but am going around in circles trying to find anything I can understand. Thanks, Maria

Please help I need a formula for reoccurring seasonal milestones.  We have seasonal launch dates and milestones in each season that occur at intervals;  -130 wks, -80 wks, -56 wks.  I want to calculate the due date of the milestone based on season launch date  & milestone -wks (-50wks) to generate the due date for that milestone.   Please help! 

HelloI would like to know if there is a possibility to add lookup field data from two different tables to a third table and have them appear in the same column?  Thanks in advance!

I want to preserve the setting from a search on an interface page, this needs to be dynamic, so a view does not work as I don't have access to the setting from within the interface page.Below is an idea of the search, location, age, gender etc... In this case a Filter connected to a grid inside a interface page shared amongst users. Rather than copy and email the link to them it would be great to name it and save it.If I copy the page url for this search the parameters are contained in the URL. I want to be able to save that url into a 'Saved Searches' table that we can refer back to a reload said search. 

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