Ask the Community

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. 

Hello,We are trying to replicate functionality from a system we are phasing out.  The function allows the user to view a list of accounts, filter based on fields, and then send an email to the resulting filtered list.  I'm wondering if there is a way to do this via the automation builder or scripting.  I understand how to do this for a static list of filter parameters, but I want to create an interface (or some other mechanism) to allow users to determine the parameters themselves.Inputs:   Users select parameters from a set of drop down fields in an interface or some other UI element (Stacker, make, etc.)  (E.g. User role, Department Name, etc.)Process:  Automation system parses those user inputs to generate a string of email addresses that matches the criteria from the user input.  (E.g. If the user selects "Role = Admin",  the system would return the list of email addresses where the user record has a role of Admin

I have a base template that was duplicated from a separate workspace (WS-A), reworked and overhauled in the dev workspace (WS-DEV). On the original base WS-A were two previous users who had workspace-level permissions THERE, but zero shared access on the dev workspace where the duplicated version was developed into its new form. The duplicated base was NOT shared with those two users from WS-A, and they do not appear as users in that workspace (WS-DEV). Once the new base was ready to move into its next production workspace environment (WS-C), those users do not appear in the User type field for assignments in the dropdown. So far so good.HOWEVER when I create a Kanban view stacked by the User (Assignee) field, those users DO appear, like shadow options. I'm not able to delete them from options in the User field type, they do not appear as having the base or workspace shared with them on WS-C, etc.See screenshots.Admin help to resolve appreciate

I would appreciate to have any assistance in finding a way to sort a grid of records in an email automation.It is really frustrating this functionality is not available, so need to find a workaround. I have an automation that sends email with 2 grids of records that I need to sort. Without sorting the grids are senseless and useless. I am not familiar with scripting, so any help in that (if it is the only way) will be appreciated and paid.We do not use Integromat or other 3rd party solutions, so need to do it by Airtable instruments only.Thanks in advance.

Hello again! I am trying to create an email report where I use the automation flow below: At a certain time > Find Records > Outlook: Send Email I’m using the “Find Records” action to search for where a checkbox is flagged, then using those records to input a grid or a list into the email. The issue is that I can’t reorder the fields or sort the list/grid it creates. Is there either, another way to do this WITHOUT A THIRD PARTY APP, or is there something I’m missing that allows you to sort records/reorder fields?

Hi there, I am somewhat new to Airtable, and need some help. I have built 90% of what I need already however I am stuck with one final challenge. I have created an automation that will send a weekly digest email with all of the logged activities over the past 90 days (calls, emails, meetings etc) that I can share with my clients, specific to their project. The email that is generated (preview) sorts these table records based on the date/time that they were INPUT TO AIRTABLE instead of the date that they actually occurred (sometimes I log activity a few days after the fact). I have created a date field which has the actual meeting times and would have preferred the automated email to sort results based on that date field however I don’t know how to do that. Automation info: Runs every week at Friday 6pm Action 1 : Find records where date is within past 90 days. My table is called “Activity” Find records based on Condition (where date is within

I’ve created a base for managing a complex calendar at my institution. I’ve created simple table and calendar views for collaborators, but I also have a table view that is strictly for exporting csv files so I can upload the events to our website since there are strict rules for formatting, etc. All of the events have to have categories, some of which have up to three. I’ve created a multiple select field (“Category”) so people can select the appropriate categories. But when I export to csv, there can only be one category per column. I would rather keep a single “Category” multiple select so I don’t have three separate fields that people have to figure out. Is there a way to write a formula for this? So the logic would be this: I would create three fields (Category 1, Category 2, and Category 3). Category 1 would find the first option in the Multiple Select field “Category.” Category 2 would find the second option in “Category” C

Hi all, Quick question to understand if unicode is supported in Airtable. Currently I have Vietnamese, Chinese and Japanese that I wish to import into my airtable app. Vietnamese seems to have some issues. So just want to find out the supported languages. Thank you. 

Hello,I have a problem performing calculations on numbers from rollup's columns. When I do additions and subtractions, I don't get any errors. However, when I try to do multiplications and divisions, I get an error. I tried adding value() to convert the text to a number (despite the original values being numbers). Although this no longer generates an error, the calculation doesn't work. I was trying to check if the divisor is greater than zero, but despite the tests, it doesn't work.I need some help 🙏Thank you,Angelo

Hi, I am wondering how to display approaching deadlines based on a dates that are 1 month out and 2 weeks out to be displayed on an interface dashboard but I am unsure how to make this happen.  Thanks! 

I’m trying to create a weekly meal planning base (and app? Just starting with the base so far). For each week, I’d like to choose several recipes to make from a Recipes table, and I’d like to be able to check them off as I go.Linking multiple recipes is easy — this would just be a “link multiple.“ What’s not as obvious to me is how I might indicate completion status for each one.So far, I’ve ended up making another table called “Days,” in which each record has a link to a recipe and a checkbox for completion. Then I link multiple days in the week, instead of linking the recipes directly. The problem is that this gets pretty complicated when I just want to quickly plan a week. Can I work around this with clever app design? (Hi, I’m new here! 👋) Or should I be approaching the base design differently?Thanks!