Solved

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 function properly in this use case. This gives me a long and not-very-clear formula.Would any of you guys have a more elegant solution to suggest?2. Time Unit Count

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! 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. 

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? 

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

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! 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 

Hello therei have an automation that was working fine, now when i try to test it, i can't get past the trigger. the trigger works, but when i try to evaluate the conditions for the first action group (or any other action group) i get an error instead of an "yes, matches conditions" or "no, doesn't match conditions". strangely, this automation worked until now. is the error possible related to airtable general maintenance or issues and not to my automation at all. or do you guys know what kind of conditions throw such an error instead of getting evaluated. very strange 😞

Hello Airtable family, I’ve previously explored how to sort the linked records, finding the best approach was a manual sort using the ‘Batch Update Block.’ The purpose was so that when using our Airtable-based ordering system, when we clicked a customer record in the customer table, it would show linked orders sorted with the most recent orders at the top. As I’m not the only one entering orders, it’s become a bit tedious and/or unreliable to use this method. I’m looking for a way to do it programmatically, either with an automation, scripting, or using even using Integromat. In theory, I’m thinking the best approach might be an automation script that only triggers when a customers ‘linked orders’ array changes, though not sure how to set that up with views, triggers, ect. I can likely figure out the script part from pseudo code. Any suggestions or ideas to try, I’m all ears! (Or, eyes…?) Kris

Hi all,I'm building a List InterfaceIn that list, I have enabled the "Edit records inline" setting. Now, all fields, even the ones that have been locked in the underlying Base, are editable from the interface. How do I keep the locked fields locked in the interface?

Multiselect Field: Sprintcontainsrow 1: Sprint 24.01, Sprint 24.02, Sprint 24.04row 2: Sprint 24.04, Sprint 24.05, Sprint 24.06row 3: Sprint 24.03want a formula in new field called "Latest Sprint" to return the last entry in the Sprint fieldrow 1: Sprint 24.04row 2: Sprint 24.06row 3: sprint 24.03thanks for any help!-Mary

I am a real novice at formulas and I have been unable to work out what I have done wrong. Can somebody please tell me. DATETIME_DIFF(TODAY(01-11-2019),{DOB LInk},‘Y’) I am trying to return the age of a person based on the difference between the DOB and the date in the future. What I have here works sometimes but sometimes gives the incorrect age. The problem occurs if the dob is later in the year than todays date. Airtable AYM Festival test 2019 - Airtable Explore the "AYM Festival test 2019 " base on Airtable. Hopefully the link will show that the first age (for Jacob) is correct but the second line for (Peter) is one year out.

I have an automation set up to add an event to my google calendar. It is working fine except, the end date it shows on the calendar is showing up the day before it ends. I have the events with no time listed because i do not want a specific start and end time for them. When i have the all day box checked in the automation It is showing on the calendar as ending a day earlier. When i make the "all day" under configurations in the automation dynamic and pick the end date it gives the start time and end time as 8AM in google calendar.  Is there a solution for this? Thanks in advance for any help!

Hi, I have a table where I add any investment into a company done. So, each row contains a field which is  linked record that link the investment to a record in table "company".But we can invest several times in one company. So I want to create a view that could display the last investment made for each company. I thought creating a new "single select" field called "active investment?", and having "active" option automatically selected for the latest investment made for a company. But I can't figure out how to do this double condition (having the "company" in the "linked field" and being the earliest date). Does someone know how to do something like this? Thank you,  Have a nice day 

Hey,I want to help my father's business and automate it to be more efficient and save him time.The problem is that he is not technological at all and he gets a bit complicated and I am afraid that he will destroy or enter wrong data (enter empty records or accidentally click on things).I wanted to ask you how you would deal with it?I thought maybe creating forms to create customers, a form to edit the details of the customers, etc.is this a good idea?I would love to hear from you how you would behave.Thanks

Hi there I have this formula below where I need to also round up by 5 or round down by 5 ( e.g. 4556, to 45560 or 2333 to 2335) ({Original Price AED} * (100 - Discount)) / 100 Could anyone please advise how I integrate the round formula within the above formula? Thanks, Nathalie

Hi Folks,I have come up with a workaround for not being able to filter on query within scripting automations. Since you can query on a view but views can't be adjusted via the API either we use a view that has a checkbox and then check the box through update records and uncheck when done.  This is useful when you have a list of records from a linked field more than a dyanamic filter.  It is also still best to filter the records that are returned to ensure they do meet your criteria but greatly reduces the number of records returned.  First we use this async function to make the object for updates:   ​async function setAutomationFlags(table, recordIds, flagValue) { const automationFlags = recordIds.map(recordId => ({ id: recordId.id, fields: { "Automations": flagValue } })); await updateRecordsInChunks(table, automationFlags); }     updateRecordsInChunks is another function that takes an array and slices it: &

Hello !I am using Airtable for invoicing. Very soon, I will have to increase prices. Is there a simple way to implement the new prices without affecting the already existing invoices?

Hello!I would like your help to solve the following problem:We conducted a survey where people answered questions and received points. Now we need to filter the score value by colorThere are 3 colors for cells, which are colored when the following conditions match:Red: if a person scored a low number of points in 4 categoriesYellow: if there are no red blocks out of 4 and less than 3 green blocksGreen: There are no red blocks, more than two blocks are green out of 4Points: red if scored from 0 to 11 points in each categoryyellow if from 11 to 17 pointsgreen if from 17 to 25 pointsHow can automation be assembled so that colors are assigned automatically based on these formulas? Conditions in coloring are not suitable, since it only looks at 1 condition\Thank you very much in advance for your help

When someone calls through RingCentral and their name, or number match an Airtable record, is there anyway for that record to pop up?

I have a user that can't click an interface button which runs an automation. The automation primarily updates a field that is not visible through the interface. My user, who has access to the interface but not the underlying base, is unable to click this button. It is greyed out. Unfortunately I didn't get to see the error message you get when you hover over the button because another user 'helped' them and moved the workflow along.Is it the current expected behaviour that a user with interface only access can't run an automation that changes the base? Or is there something else going on here?

I imported (not thinking) over 1,000 .csv records into one of my Free dBases.What will happen to the excess records?

Hi, community! I'm sure you'll be able to give me some ideas to figure out the best way to accomplish what I'm trying to.I have a base with 6 tables: Check-in, Market, Business, Operations, Traction and Finance.Forms with data will arrive in Check-in table. Since is a lot of data for the customer to fill in one time, we had to split fields in 5 forms which collect the real values of customer business and 5 forms collecting projection values.Customer will answer this every month, so we have an Evaluation Month field in every table. Also, and that's one messed up thing, they need customer be able to send data in more than one form. So this would work something like, on first month, customer knows 4 of the 8 questions, he will send a form with these 4 answers; then, when he gets the other 4, he will send another form with the other 4 answers. Please, consider we can't ask our customer to send only one form per month, despite this was the easiest way to solve the problem.After that, we nee