Ask the Community

Hello All, I need help with a nested IF statement that references a formula date field. I'm not sure if this is causing my issues, but I can only get my formula to output two of the four values. In the formula below, "Expired" and "Missing" appear, but "Expired" is not accurate when I update the date.What I am trying to accomplish is:- If the date is past today, display 'Expired'.- If it is within six months of the due date, display 'Expiring'.- If it is greater than six months, display 'Active'.- If no date value is in the field, display 'Missing'.If anyone can let me know what I am doing wrong, I would appreciate it. IF( {H.I.P.S - Due Date} < TODAY(), 'Expired', IF( AND( {H.I.P.S - Due Date} >= TODAY(), {H.I.P.S - Due Date} <= DATEADD(TODAY(), 6, 'months') ), 'Expiring', IF( {H.I.P.S - Due Date} > DATEADD(TODAY(), 6, 'months'), 'Active', 'Missing

Hi my org does school lessons, we have lessons, teachers (who host the lesson), and our educators (who deliver the lesson). These are spread across 3 tables, with lessons having links to an educator and one or more teachers. I want to calculate the number of unique teachers an educator has reached. So I created a rollup field on the educator that uses COUNTA(ARRAYUNIQUE(values)) on the lesson's teachers. This works great if each lesson only has one teacher. But some lessons have multiple teachers, I tried a workaround using a lookup field and then a formula using ARRAYUNIQUE but that didn't work, as apparently the array formulas are just for rollup operations. Is there a workaround?Here's an airtable base demonstrating the problem: https://airtable.com/shrSGt3bifbnmwnLp

Hi all,Using Make, Airtable and an API, I built an automation that scrapes reviews of a cultural event from Google Maps. On Google, the date on which a user left a review is not given. Instead, Google provides us with a time period that matches the amount of time that elapsed since the user left his/her review (e.g. 'one year ago'). This type of data does not make it easy to sort reviews in a chronological order. Consequently, I went about transforming this type of data into dates.For this data conversion, I created intermediary fields – Time Unit Count, Time Unit Type and Search Date – that I then combine in a formula in the Date field. But I'm unsatisfied with 2 of those intermediary fields' formulas.1. Time Unit Type field: for this field, I used a series of nested IF statements because I didn't manage to use the SWITCH functio

Hello Airtable Community,I have a relatively complex use case.I have a table in which projects are created, a table for tasks and a table for project phases. Then I have a template table with standard tasks and a template table with standard phases. I would now like both the standard phases and the standard tasks to be created by an automation when a button for a project is clicked.I have created two automations for this, one for the tasks and one for the phases. Everything works fine. Both the tasks and the phases are linked to the project. However, the tasks are not automatically linked to the phase. The aim is that, for example, when all tasks in phase 1 are completed, the phase is also completed.Thank you and best regards.Mirko 

I am working on creating a system to track training for my company and am running into an issue I can't figure out. I have built the database and would like my "Ring Central Training" table to be updated once a feedback form is submitted so that way, we have an automated way of checking off when employees have gone through training. The Ring Central Training table will ideally have all of the employee names there now as well as what teams they belong to. The issue I am having is that once I created the automation I have the error that there is invalid inputs. Ideally I would like the "Scheduled" option in the Ring Central table to get change to completed once the form is submitted as well as the Date of Training to change based on when the form is submitted. Below is all relevant screenshots regarding my issue.

I have a table with a list of contracts that has fields for CompanyName (link record to a company table that lists all the companies) and ContractStartDate.How do I filter or find the oldest record for each Company based on ContractStartDate? A company can have 1 or multiple contracts.Thanks!

Hello! I currently am using Make to funnel in data from a webhook and then create a record in airtable. My goal currently is to be able to display Events per hour for each day of the week, I am essentially trying to recreate the table in the screenshot below:I've been playing with it for the last few days but am struggling with the best way to accomplish this. I believe one of my issues is that the "Date-Time" isn't explicitly coming from the webhook and rather just Airtables "Date" data type with the "Use current Date". Just looking for any guidance/nudges in the right direction on how I could accomplish recreating the table below. . 

Hi all!I am currently working on a base in which our staff members will be able to fill out their weekly timesheets. I live in Canada and here the standard hours of work is set to 8 hours in a day and 40 hours in a week.In our company, the standard hours of work for a week is set to 35 hours. Any worked time that goes between 70 and 80 at the end of each Pay Period (2 weeks) is put in a bank. I can't figure out how to properly sum those hours without creating an astronomical amount of fields so I need your help.In my base (which is in French) I have 6 tables :Feuilles de temps (=Timesheets) which is linked to Pay Periods, People, Days and Projects

Hi,I need some help with an issue I'm facing. I have a formula field called "Order Quantities" and a "Meal Quantities" field (Long Text) that references it. I'm using the Fillout form to gather customer information. However, the quantity field in Fillout is not connected to my Airtable.To address this, I created an automation to pull the quantity details into Airtable (see the attached file).I'm looking for a workaround to sum all the quantities of each meal for all records in the "Order Quantities" field without changing the structure of my table, as I need to launch this system this week.Thank you!Here is the formula I'm using for the Order Quantities: CONCATENATE(  "Lamb Keema: ", IF(    ISERROR(SEARCH

Hi! I'm trying to create a formula for the following columns:1: First Name2: Last Name3: Pen Namewhere If "Pen Name" is blank, use "First Name + Last Name". I keep getting stuck somewhere and getting invalid formula errors. 

Is there a way to see/track who has made edits to a formula or field? This feature is very helpful for viewing individual records, but it'd be even better if I could view who is changing formulas.

We are a medical practice and often use fax as a way to communicate securely to our referral network. Is there fax capability built in Airtable? If so, how do I do this? If not, is there a way to setup faxing via a third party application? 

Hello,Everyday I have a script that scrape IG accounts. I want to add "Followers Gain" which is the current number minus the previous number of followers on this account. I've played with automation without success due to the fact that there are different IG accounts. 

Hello everyone,I am modeling a Plastic-Injection Production & Order Management database on Airtable with external Forms for data entry. In plastic injection, each physical Mold has a number of physical Eyelets which produce a digital shape called Pieces (Component). Components, which are respectively, Pieces, Outsources, Workmanship, come up together in a joint table named Product Recipes and make up Products. Each Piece comes up as a Piece Model from the machinery, as it takes a specific Raw Material and a Color.I have managed to work this with CRUD (Create, Read, Update, Delete) operations implemented. Now there comes a difficult task

Hi Airtable Community,I have two table named "Task Assignment" and "Employees". I have linked the Employees table to the Task Assignment table using a linked record called "Assignee". Now I want to send an email every time I add a task inside the "Task Assignment" table. I have added a lookup field in the "Task Assignment" but is is not available in the automations.Please let me know how to tackle the issue. Thanks

 Is there a way/hack to select the same object multiple times in multiple-select? I'm collecting information about tickets and some individuals' have multiple tickets of the same type. Thanks!

I’ve created a dizzying array of lookups, rollups, and formulas to finally arrive at a result, which is in a formula field. I want to copy this text string result into a text field that can be displayed and edited on a public form (long text or short text). I know how to “pull” results into a new field using formulas, lookups, and rollups. But how do I assign a value to a text field that can be used in a public form? How do I “push” my result into the field? Thanks!

Hi everyone,I work for a higher education University using an enterprise account. For approving communications and other projects, it would improve our workflow if I could share a view and allow the Stakeholder to click a button that would approve the project/communication and move it to the next stage. Another option would be if there was some sort of "reply APPROVED" option to an email that would automatically insert "APPROVED" into a field in Airtable.Is any of this possible?Thanks!Nick

I have a base that has a number of junction tables. For example a product links to a product assembly item that links to a product assembly with multible product assembly items which links to an estimate.Its very cumbersom to have to go through each of these tables and use the forms to add data to each indivdual table. I wanted to create a single form that lets a  user select products and then creates all the related junction tables.I was wondering if anyone had any work arounds for being able to add data to multible tables from a form.  Right now forms do not allow for record creation or buttons with scripts, making it hard to create a new junction table entry that relates to the record being created.The only work around I can see is to create a seperate dummy " input table" that has a number of records related to each ipnut action I would like. Instead of creating a record users would just be editing the record through an interface. There would then

Here's a weird one. So I had am automation set up using the airtable "Slack: Send a message" action and it always worked great. I add the slack workspace account, authorize, then it shows a chanel list of all chans, I pick my chan in the workspace. Good. We created a completely new slack workspace since our product got split to another business and now I need to make this message get sent to the NEW Slack workspace. Simple. Go into the automation, remove the old Slack workspace integration, add the new one with the NEW slack URL and new user/pass, and then... wait... It is showing the OLD slack channel list from the old workspace. The channels are totally different so I must have made a mistake. I remove the "Slack: Send a message" action completely, then to Account -> Integrations section to remove the integration from my entire airtable profile. I notice that this integration DOES show the name of the NEW company, which isn't looking promising (since that mea

Hi all,I'm here again with my automation not working correctly. The last time I was having this problem, it was because the automation was set to trigger on "Create new record." Having learned from that, I created this automation using a checkbox field update as the trigger. I just cannot see what I'm doing wrong.I'll admit there's a problem with my trigger table - the Primary field is not being used properly. It was set up by my designer and I can't change it mid-season. Is that the problem? Is there any workaround?It's just creating blank records.

I'm getting a redundant record when using the For Each [multi-select] create record on a Form is created trigger. Simply delete or is there a better way?Fee Table, 'Add Fee' Form has a multi-select 'Fee Type' field (advance on signature, advance on delivery, advance on publication, royalty)Automation trigger 'When a form is created', with a  For Each [Fee Type] create record. Works beautifully apart from the initial record which has all of the multi-select options. I used Kuovonne's delete record script to delete this redundant record which is clean and fast.But feels like a workaround - like I missed a lesson at school. Any pointers?  

Hi folks,We've been linking records with a barcode scanner for several years and it abruptly stopped working as of last week. I haven't checked the scanner settings in a long time, but my recollection is that in essence the scanner reads out a string and does a carriage return to simulate hitting enter. We scan into linked fields, which have records matching the string names. If I copy a failed scan result out into a text file I can paste it back in and the same thing happens. If I open the "search" option in the link field and paste the result, it does pull up a matching link that I can select and then it works correctly. I suspect something changed about Airtable's behavior, as we had no problem with this before. Anybody have advice on how to address this? I will try to change the barcode scanner to not do the carriage return, as hopefully that will let us do the link match manually. That will certainly slow down our workflow though. Reg

Hi!I'd like to view at a glance the date a base last updated. It's impractical to create a "modified time" for every single field on every single table, since I don't know which field would last have been touched in a given base. Is there somewhere I can see that information?Use case? I'm new to the org and trying to clean up a bunch of data sources. I don't always know which team created the base and whether or not it is actively being used.Thanks!

Hi! very new to using Airtable. I am trying to find out if it’s possible to use Airtable to populate users profiles for a small 30 members community. I am trying to display name, title, image, etc.. or would I be better using something I am more familiar with like Supabase. any thoughts or advice would be appreciated. Steve