Ask the Community

Hello! I have an idea for an automation and I'm not sure how to go about it. I have an automation (in zapier) currently where when the referral source is left blank when an employee schedules a client in our scheduling software, the client name and email is added to an Airtable base so that we have a running list of who to reach out to and ask for the info. I wonder if it's possible to send an email to the employee asking for the referral source. I was thinking it'd be great to just send an airtable form but I don't know if I can send a form that would update an existing record? The referral field is not always applicable so making it required isn't an option. The existing automation filters whether the referral source is needed. The process in my head goes like this:-New record is added to Airtable base that includes name and email. The record also has a single choice field that is left blank with the possible options.-An email is sent with an airtable for

Hey guys! Noticed a bug on the interface timeline view.Basically when assigning a record a color by condition. Sometimes it updates automatically and sometimes you have to refresh the page to see the update. The below Loom video demonstrates what I'm talking about.https://www.loom.com/share/6690d90b80f044d6910db33fc16883ea

I have a business plan.I have set sharing permissions for a new interface to 'general access' - ie anyone at my organisation can see interface. When i view as them in editor mode i can see the interface. However, when they log in they cant see it.Any ideas? 

Hi there, I'm new here, was hoping someone could help guide me on a small problem I cannot seem to resolve. I need a simple solution and instructions how to create a roll up of some designs in my list. So that when a design has more than one color, I can leave it rolled up, so when I am scrolling, I am not going through loads of the same design.So, as you can see [a] is the first one and any after that b, c, d, etc. will roll up underneath. I tried using roll up but really not sure what I am doing. I'm obviously doing it wrong and wondering if there is a simple workaround that I don't know of.I have many designs I want to do this for too.The second picture I have moved a, b, c, d, etc. from the SKU to a line of its own but unsure what to do next. I need a step-by-step guide, if possible, please.

I have a table (source table) synced via a one-way sync to a table in another base (target table). I recently changed the name of a field in the source table, and I noticed that the name of the field in the target table did not update to match the updated field name of the source table. Is there a way to automatically sync the field names, or do I have to manually update the field name in the target table? Thank you for your help. 

It won’t find the slack channel I need and when I use the “Find channel” option I can’t search for it either because when I type it into the search field it doesn’t do anything. If I hit return, it just picks whatever channel is at the top of the list and doesn’t search for what I entered.

I recently switched from google drive to dropbox for my content uploads and when I try to add a photo into the attachment from my dropbox integration it only shows me the content in my dropbox in a list view rather than a grid view. I'd like to see it in a grid view so I can see all the photos as is and not as the file name. Is there a way to change this? TIA! 

I can't believe a very simple feature in excel/google sheets is missing here in formulas when it comes to subtracting two numbers and if it's negative - show the number in one color, and if it's positive - show the number in another color so I have a pretty simple setupField 1:  Cal+/-Formula is: 2300 - Cal   results will be a number Less than 0, 0 or greater Formula is:  If({Cal+/-} < 0, ??, ??)What do I use in the ?? to show less than 0 in red  or 0, greater than 0 in green  

Trying to import an Excel file into Airtable with selections in Excel field.  Is this supported by Airtable's import function?  

Hello,I am looking for some help on an automation I am trying to run.  I am trying to use a make.com webhook with airtable so that when a new record shows up in airtable it sends the webhook to make.com.  I have the script that I am using and the connection and everything works but the webhook does not send the correct bundle of information.  It sends the record ID and then just generic information like 'header 'recipient', etc.  I am a school teacher and not a coder so I have been trying to get Chatgpt to help me with the script and I feel I am really close but don't know the scripting language enough to diagnose the problem.  Any help would be appreciated.let table = base.getTable("Injury Report Form");let recordId = input

Hi,I tried using != Blank() and NOT(Blank()) on several occasions for my formulars and have been getting different results. I'm not sure why.Is it because only one of the two works and the other is ignored by my formular? Or does it depend on the format that I am trying to evaluate (dates, integers, strings)? Any help on clarifying this would be greatly appreciated and prevent mistakes in the future.

Hola AirtableforceoneFirstly, if anyone wants to know how to extract helpscout images from threads and then send them to dropbox and then over to Airtable .  will share that here. Thats 8 hours of my life gone but it's easy now Iknow.BUT - one last question. Right at the very end. How do I fix this?I have Make/Integromat adding an image to an airtable row by providing a URL (Ps, I made a public one of course, used drop box yadayada).But when I upload the image, it deletes all the images in that row rather than just adding another. Cant find any switches of settings for it. Any ideas? Seriously, Make is so far more detailed than Zapier but this last piece is a killer.

Hey Everyone, I am working on a project that brings together data from a number of tables, text and images that are trigger by a web hook in a web app using softer. The web hook is used to tell zapier what data to search for airtable. Then in Zapier the data is parsed into the Google slides document, which is then converted to a PDF, then printed. It is an amazing no code rube Goldberg situation! The method that I am pulling data from Airtable is using the Search, the search provides URLS for the images, but when they are linked to in a. browser, it says that the URL is expired.Airtable support suggested that when  you use the "New/Updated Record "method to pull records, that there is a "Include File Contents" option that will pull the PNG information into the zap making it useable in Google Slides.In an effort to not overcomplicate things, I was wondering?is there another way to get the PNG data from airtable using the "Search" meth

Can you make a single line comments within a formula?

 I have a database with 3 tables - clients, line items, Invoices.I would like to have a form where a client can add line items and then at the end of each month an invoice for each client would be created (if possible automatically add a record to the invoice table) including a rollup of only the items that were added that month and for that client.I haven't found a way of doing this so any suggestions would be much appreciated! 

Hi everyone,I have a table for customers, a table for assets and a table for faults.Each client can have several assets and each asset can have several faults.When a fault is closed, an email is sent to the customer with a request for payment for that fault.I have clients who are divorced and they are paying for the same property.Their email column is a lookup field from the asset table (which connect to the client table) in the faults table and it looks like this now - "email 1, email 2"And the same for the column with their first name it a lookup field from the asset table (which connect to the client table) and it show - "first name 1, first name 2"I can send each client seperate email with the "repeating group" automation.the problem is that i cant seperate their first name in the email body text.how can I send each client private email with his first name?

Hi 😊 I'm trying to create an inventory system that works a bit like a CMS. I want to be able to create an automation when if I add a new item in Table 1, another table is created (duplicating fields from existing tables) and then if possible, linking the new table in a column by the new item in table 1. To make it easier to visualise, Table 1 is like a directory, and then Table 2 is a like a log of that item. Currently I have to: 1 - add a new item in table 1, create a SKU number for it, then duplicate table 2 (which has different field values) to create a new table for the new item. I then copy and paste this new table into a cell on table 1 that coincides with that same item.Screenshots attached that show Table 1 with item catalogue, and then Table 2 with item 1 listed. You'll also see the duplicate tables of table 2 along the top, and the links to these in table1. Thanks in advance!

Ok, I think this is pretty simple, but I just haven't worked with Airtable programming/automations enough.When closing or leaving a record's interface page, if a specific field is blank (empty), I want to pop up a dialog that says "xxxxx Cannot be Empty"  or something like that.TIA!

Hi everyone,I have a table for customers, a table for assets and a table for faults.Each client can have several assets and each asset can have several faults.When a fault is closed, an email is sent to the customer with a request for payment for that fault.I have clients who are divorced and they are paying for the same property.Their email column in the faults table looks like this now - email 1, email 2And the same for the column with their first name - first name 1, first name 2Is it possible to send an email to each of them separately when a fault is closed?

Just wondering if this is a bug or is intended.If not a bug, how would I go about fixing the issue?

Hello, I am trying to take one column with a day/hour field (Start Date) and use a Single-Select (Time zone) to create an updated day/hour column. Currently, I use New York time on all the other dates but I need to be able to see a different version of the time in cases when I am collaborating with people internationally. Time zones would be ‘Africa/Laos’,‘Africa/Maputo’,‘Africa/Nairobi’ etc. Any help would be much appreciated! Edit: I have looked at this sample base and get what it’s trying to do, but I don’t know how to alter it for my purpose.

I need to have the master table unmodified and only its duplicate to register my changes so I can compare the two. How can I do it?

I am trying to set a simple automation but for some reason It does not work and I cannot make anything out of what the error is giving by Airtable: Updating the record failed.For more context, I have a formula field that is concatenate from multiple text fields and I want to have a multi-select field that is pasted from the aforemention formula field. The purpose of this is to have tags type as well as remove the duplicated tags.Let me know if you have any suggestion. Thanks!

Wonder if anyone has something that works for this... I'm creating discrete events in a base, and I want to automate the process of turning the data points into a .ics file and attaching it to the record in an attachment field. It's a bit like this walkthrough  but instead of using Make to attach the .ics into an email, I want to return the file to the Airtable record's attachment field. Then anyone who has access to the record can download and save the calendar entry to their own calendar. Per that walkthrough I was trying to get Make.com to do this but I keep running into Bundle Validation Errors, and I'm wondering if there's a way for Airtable to handle this inside the base via scripting. 

I have an "Applications" table that tracks contacts through various stages: expressing interest (TYPE = EOI), applying (TYPE = Application), and other scenarios for a specific session.I want to determine how many contacts who expressed interest (TYPE = EOI) in a session ultimately applied (TYPE = Application) for the same session. This will help me calculate the conversion rate between expressing interest and applying.Is there a way to calculate this?For example, in the provided screenshot, contact records 14 and 15 both expressed interest and applied for the same session. Other contacts may either only apply or only express interest.In the "Sessions" table, I have created two lookup fields: one for contacts with TYPE = EOI and another for contacts with TYPE = Application. However, I’m having trouble figuring out how to identify which contacts appear in both lists. Is there a simpler method to achieve this?I have hidden any contact names.