Ask the Community

Hi there,I'd like to set up an automated weekly email for pending leave applications, but only if there are actually pending leaves. When I tried using conditions linked to individual records, it sent multiple emails. And when I used scheduling as a trigger, it still sent an email even if there were no pending leaves. I have an interface with this summary, but can't seem to use it in the automation. Has anyone figured out a solution for this?

Hey folks,I'm having a strange problem with updating records in my Airtable. I set up an automation where it checks if a record with a specific user ID exists. If it does, it updates the record, and if not, it creates a new one.I deleted all the records from the table. Now, even though the table is empty, the update is failing because the automation is finding two record IDs that don't exist anymore.Empty Table:Run automation :The update will fail as it refers to the previously deleted records' IDs. Is it a cache issue of some sort?Any ideas on how to fix this?Thanks!

I have a ticketing system built out in interfaces. Id like for people to have ability to "thumbs up" an open ticket. Almost like a community voting on which feature I should add next. Ideally, would love to only let each user vote once per record id but I know thats alot to ask for. Is there a way I could accomplish this via a clever button or something? On an Interface page I just display a grid of open tickets, and would be great if you could just click a Button field inside of the grid to vote up on it. 

Hi Airtable Community,I have a table with events. New events can be added via a form and various needs can be requested for the event using a multiple selection field.A record is generated in a second table for each need.I have currently created an automation for each selection option as I have not yet found a way to do this dynamically. However, as there are now around 30 different needs, I would like to make the automation dynamic. Any ideas for a solution? The problem is that the need has to be named correctly and I can't pull this information dynamically from the multi-selection field.Thank you and BestMirko 

We a long term property rental company in Thailand and we keep getting requests such as need additional towels, pillows or something broken to be fixed in rooms or cleaning to be done. We are a remote team and our housekeeping/technicians will fulfill these requests. Unlike normal hotels which have a dedicated staff within their properties, we have taken multiple rooms in multiple properties on lease. Hence a dedicated staff for each property is not economically viable. I want to create a form for each of our customers who would wish to get the services we want. These services can broadly be classified into three types at the moment:1) Need some supplies (like towels, iron boards, drying racks, coffee maker, etc.)2) Cleaning of rooms to be done3) Something broken/not working to be fixed (like Wifi, AC, TV, water heater, etc.)I have attached a pic which depicts the workflow. Need help in preparing a schema as well as a form which can establish the above explained objective 

I have 3 tables: plants, fertilizers, and schedule. In the schedule I set on a date certain fertilizers and plants. And also it has field "done" - planned or done.So I want a calendar view for each plant where I can see when and what fertilizer I have used.Could you please help, How can I do this? Thanks for any suggestions!

Hi everyoneI have an Interface built out that has a record picker with fields and such below. I'm wondering if theres another way to get a user to that page and pre-fill the record picker. If I let users just expand details via a grid/list/gallery it's not as in-depth as if I use a record picker + regular page combo, so I want to get users there another way. I tried using ?prefill but it didnt work. Maybe someone knows of a workaround? Wish you could connect a filter to a record picker, but ya can't. I'm just trying to make charts and graphs and have more than 2 buttons in a grouping 😭

Hi Community. I'm new to Airtable automations so apologies for what may be an overly complex workflow - any suggestions to improve it are welcome. Goal: send an automated email when someone "invites a friend" on a website. Email will say "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site", etc. How I've set it up so far: Airtable table with fields Friend's name, Friends email, User's name, User's email Concatenate formula to combine the above fields into a message something like "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site"Automation to send an email using the text from the Concatenate formula Problem: there doesn't seem to be a way to format the text so when the email sends, it's just a long string of unformatted text. Does anyone know a better way to set this up? 

Is this possible? If so, how?

Hello - I am new here and trying to create a base for following cash flows in my various accounts, cash or petty cash.Thanks to sources I found here, I succeeded to create deposit and withdrawal through two tables, one for accounts and one for transactions, and a rollup structure to calculate the balances of each account under the deposit/withdrawal transactions. However my concern is related to "transfer" transactions between accounts. When it is a "transfer" transaction, I want the rollup to subtract the amount value from the transferring account and add the amount value to the receiving account. I mean, when the number of accounts and the rollup transactions becomes two, I cannot find a practical (or sophisticated! 🙂 ) solution for such purpose, so that;(a) I select the "transfer" as the transaction type;(b) I enter the amount of the transaction;(c) I select the From and To accounts separately;(d) The amount becomes withdrawal for first account and deposit for the second acc

our airtable is automated in sending email notification whenever a new data is added in google calendar. however, i've noticed recently that it sends email notifications excessively and was wondering how to fix it. it's excessive to a point where if you just adjust the time in an event in calendar, it sends email notifs as seen below. the trigger to the action is "when a google calendar event changes"even though i can change the script logic to only add the guest if the change in event was a new guest, it will still run the automation and therefore count towards the number of automations run each monthis there a way to figure out why the google calendar events are changed? i can't see it when looking into it

Hi, is there an option to stop the Formula Helper dialogue box appearing when I click in the Formula edit box?The thing obstructs visibility of the formula when I'm trying to edit.   I'm having to click out of the formula edit field to close the dialogue in order to see all parts of the formula. 

Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields:  Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, Fail 4/17/24.  I want to use a multi-select tool so if/when they retake the test, I can note which date they passed or failed. Fields:Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 I would like another column to say, if the fields contain pass, then count it as one. If a student passes 4 out of 6 of the tests, I would like the column to have the total = 4. I am stuck combining the multiple fields. Airtable provides the following equation to count for one multi select field: IF({YOUR MULTIPLE-SELECT FIELD NAME},LEN({YOUR MULTIPLE-SELECT FIELD NAME})-LEN(SUBSTITUTE({YOUR MULTIPLE-SELECT FIELD NAME},",",""))+1)Is there a way to create a formula that will count from multiple field

Hi,I'm looking at trying to create a simple invoice e-mail to be sent out as a result of an automation. I can basically get all the needed data in, but struggle with getting visually at least semi-appealing ;).I read the manual about markdown and that some html can be used. I also looked at the instructions regarding including images in the mail. However:with the limited html on offer, has anybody been able to build any form of layout (other than vertical listing 😉 )? Could CSS and <span> be used to, say, get a right side header column? Or should I try to build views of the relevant tables and insert the data as grids?if I include images (one top banner, one logo) as attachments from a table, they are not just plain images, but have some frames around them. They are also clickable links, which is not good. Based on the instructions I can't decipher if it's possible to have inline images *that are not linked*, but actually a part of the mail, and without being links?Thank

Hopefully useful for someone. If you set a variable called ‘Shorten’, then you can use this script to pull the URL and turn it into a bit.ly link which you can then use to automate something else! Feedback always welcome. let inputConfig = input.config(); let response = await fetch('https://api-ssl.bitly.com/v4/shorten', { method: 'POST', headers: { 'Authorization': 'API CODE FROM BITLY GOES HERE', 'Content-Type': 'application/json' }, body: JSON.stringify({ "long_url": inputConfig.Shorten, "domain": "bit.ly", "group_guid": "THIS CAN BE FOUND IN THE URL OF YOUR BITLY ACCOUNT" }) }); let bitly = await response.json() output.set("bitly", bitly)

Hello!We have former users with Creator permissions that we would like to move to non-billable to save funds for a nonprofit.When we disabled a former "Creator" user, other users were no longer able to manage rows through a particular view or interface.How can we locate (and bulk move!) all created/permissioned collateral like automation, views and interfaces from one user to another?I could do this with a regular SQL database, however the nonprofit prefers for data entry using Airtable and thus I need some assistance to work within existing management tools provided 🙂Thank you!

Hi, I'm new to automations on Airtable and am facing an unusual error:"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".Here you can see a successful test, when a match is found:It is also successful when no match is found, BUT when only "name" is used, and not both name and email, finding 0 results (expected behaviour).  BUT when adding the email condition bac, when there are no matches, it gives the error: This seems like a bug to me, can you advise? Thanks!!

I’ve added Multiple Select field to my base. In the Fields section on the API page it displays all the Possible Values this Multiple Select field as an array. Is there a way to grab this Possible Values array upfront or do I have to loop through the records and build this array based on each record’s selected value(s)?

I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a date dependency to calculate the end date for the subscription. Is this possible?I already figured out that i can convert it to duration using a formula field but then i can't use it in a date dependency...

To any formula ninjas, A column has multiple keywords/values. I need to add a pre-fix before each of the values. From: column: Colour values: White, Black, Blue To: add the prefix “Colour_” to each one of the values in the colour values: Colour_White, Colour_Black, Colour_Blue I created another column with the prefix Colour_, and then a basic concat, but the result is (of course): Colour_White, Black, Blue I don’t know how to add the prefix to each of the values individually, and if concat is the right formula. Detail: not all columns will have a value, so need to consider an empty cell. If anyone has a good idea… much appreciate it ! Christie

Hi,I find myself needing to change at least single select values, and would like to know if there's a way to do that without breaking automations and interfaces?I e.g. have names of event types that I need to change, for example from "Discovery" to "Discovery call" or status kind of values like "Ready" to "Ready for invoicing". Any of these are used in interfaces and automations as discriminating variables to either activate automations or filter what is shown.When attempting to edit one, I get a warning of dependencies, but I can't understand whether the update would actually break the listed dependencies.Thankful for any help how to do this safely. I have a ton of changes to make....Rgds,Björn

Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that? 

I’m comparing two currency values in a table, and attempting to flag if there is a mismatch. The way I’d do this in gSheets is pretty obvious: =IF(field1 = field2, TRUE, FALSE) - then conditionally format on TRUE or FALSE to get a visual indicator. I actually like that there is no range-based conditional formatting in airtable, since these are meant to be DBs - but I still think a coherent display of true/false values (As a checkbox!) is reasonable and I shockingly don’t see a way to do that here. Yes, I could do something idiotic like represent it with an emoji, but that’s a nasty hack if I want to query for items in my table whose cost-match is FALSE. Thanks!

Hello! My gmail automation email is going to spam. I created an auto responder using gmail and airtable automation. All my emails are going straight to spam. Is there a fix for this ?

I am looking at a way to deplete inventory of items when adding a kit to inventory. For example:I have 1 kit that contains 2 A's 4 B's, and 1 C. SO when I add a kit to my inventory, it removes 2 A's, 4 B's, and 1 C. How would I make this work? Thank you for any help.