Ask the Community

I ran into a strange problem in an automation.I am using a script to gather some data from two tables and combine it into a rich-text field. In the next step, I send out an e-mail with the content of this field. Turns out the e-mail is sent before the script has updated the text field!Even adding a 3 second delay in the script does not solve the issue.Curious if someone has a solution in place?Thank you!

Hey guys,Is there any plans to make it so that when someone copies a base from a public share link, that the automations also get copied across?I create a bunch of systems and templates for people to try and get them in to using Airtable but this is big limitation when it comes to offering these types of solutions as the automations are really a big part of any system.Is this going to be possible at any point or is there a good workaround at all?

Hi all,Have been scouring the web, AirTable support and various AI platforms to get an answer to this, but no joy so far. I am trying to set up automation to sync changes between Google Calendar and Airtable, including updates and deletions. AirTable support instructed me to set up triggers for new events, updated events and cancelled events. I am doing this on an empty table at the moment just to test it out. However, I am hitting a bit of a brick wall with the Updated Events automation. I believe I have the Find records action set up OK, see screenshot below (although when I test the step at that stage, it says Found 0 Records but I guess this is because the table is empty currently...)My screenshot: Find records menu Where I’m really getting lost is with the Update record part. According to AirTable Support, “the ID of the action that gets the information to be used goes in Record ID, and should look like the below. “This is because this Integrated Trigger is not directly related to

Hello.My time zone is Israel.I defined the time zone of Israel in the Date and Time field. But when I run formulas or automation on it, it refers to the registered time, as if it were GMT/UTC and this disrupts all my automations.Is there a solution for this?

Hello hive mind geniuses! Bear with me, I’m not sure how to explain all this, so I’ll start with my use case scenario and end with my current setup so far.I’m trying to create a file folder/mail merge printing system for genealogy & correspondence names. The problem I’m trying to resolve is having to copy and paste information over and over into label templates, whenever file folder or mailing labels need to be fixed, reprinted, or duplicated.Currently, I have to copy and paste from within each name or address cell in my spreadsheet. Even if I rearrange the spreadsheet to display vertical columns rather than long rows of cells, a full copy/paste of multiple cells shows mini tables inside the label borders, instead of formatted text columns. It’s exhausting. So the urge is to save the label sheet for when new labels need to be printed as replacements, edits, or extra file folders or envelopes. But then every time you need a few or many new labels printed, you have to hunt them down

I have an automation set up with an Outlook email action that runs into errors after sending 25 emails successfully. When I run it at least 24 hours later, it will send another 25 emails. However I keep having to push the rest of the records that need emails sent to the following day. What is the term for this specific limit I’m running into with Outlook’s integration? Is there a way around it or to disable it?

Hello,Quite simple question : today when you mention a user with “@person” in a comment or a note, he/she gets notified by email. Is there a way to route these notifications in Google Chat, Slack or MS Teams ? I’d like to avoid kludge solution like creating a Zap or Make that watches over the mailbox and transform an email received into a chat message, this should flow directly from airtable to one of those 3 solutions, like a setting in the user specific parameters. 

In Interface, I create a grouping of my data based on warehouses. That works.The warehouse names appear as their own defined sections, great! Why in the world do I have to see the field name above every single group in my page??1-It’s the same (useless) information over and over2-It’s ugly Is there a way to just remove the grouping title? We can remove grouping record sums! Why not the title?  In this example I would remove the POSO WAREHOUSE text.(My fallback is to edit this for something like an Emoji or whatever, but I’d rather have nothing appear). Thanks so much folks!  

Hi, A few our users are starting to see an error on the interface for a graph. The graph is replaced by the error 'Cannot access this data' Nothing has changed and this can be seen with anyone with database access as far as I can tell. Anyone have a solutions?     

Hey guys, probably an easy thing to do but I want to name an entry according to the right “quarter candidate” field without having to create a super long “IF” formula (I want to update this table without having to update the formula everytime I add a new quarter candidate to the list)My goal : in an other base each new entry have the current date added to it, according to this date, I want to have a field with the right quarter candidate because the date is after the “input start date” and before the “Input end date” Thanks for your help !   

Hi everyone,I recently subscribed to the $120/month plan on Airtable to use the "Invite Interface Users" feature, with the goal of building a secure client portal.🔍 What I’m trying to achieve:I’d like each of my clients to access only their own project status and files (like contracts, invoices, etc.) through a personal and secure interface, without being able to see any data related to other clients.🚨 The problem I’m facing:After subscribing and setting up the interface, I noticed that: When sharing via a public link or inviting users as guests, they can still navigate across all records within the interface. There doesn’t seem to be a way to dynamically filter content per user, which means clients can potentially see information that’s not meant for them. here is the public sharing link : https://airtable.com/appDYt3YzQdpYcnOG/shrUpygqc5VuKVW4OHere is the link to the new "Invite Interface Users" feature: https://airtable.com/appDYt3YzQdpYcnOG/pagkFj34FIhwvysX2🔁 My question :Has

Hi everyone!I have created an interface to keep me organized, and one thing I would like to add is a table that would function like the data side, just within the Interface. For my specific example, I have various groups I invite to events, and it would be helpful to have a table with the group name, group contact, and then a checkbox for when I’ve contacted them. My interface is a “Record Review” interface.Does anyone know how I can achieve this? Any help is appreciated!

Hellowe are a marketing agency and use records as ‘tasks’ which have time against them so that our team can resource themselves each week and we use the timeline view to check their % capacity and utilisation each day/week/month. some people have a handful of tasks (1 per customer) assigned to them each month, with a number of hours to spend on the customer, but how they actually end up spending their time is a little bit each week. the challenge we have is if you pick a start date and end date as start and end of the month for this task is spreads it too thin and doesn’t allow the guys to setup their days in a more granular fashion.I guess we could break down and have tasks each week but then that’s extra admin, more chances of things breaking, not distributing the tasks evenly on some months with 4 weeks vs 5 and so on. just wondering if I’m missing a trick before deciding how best to proceed in an efficient way 

Trying to create a automation. I want to have it when a occurrence is created, it will get a count, with date, and filter by user. And if criteria is met, it will send a email? Prefer not script has i dont have team right now

Hey all,I would like to generate a document using a template that uses formulas to change the data in that document, and then attach that to a contract (populated with information from Airtable also) which is then sent for e-signature.Any thoughts on how to accomplish this?

Hi all, we had developed a nice data base application, but sometime users have limited access to internet, I’m trying to work around this challenge, so one of the Ideas are: Question:Can the final users in the field download the Airtable application on their Tablets and work on the database offline since there is poor or no connectivity at the sites. Then, when they are back in the office can they sync it to the main cloud-based database Ideas: Download the portion of the DB into CSV to the local PC, then updates offline and then upload it back to the DB, however and afraid the users enter wrong information or get confused by the layout.  Install or add an extension to the DB but I don’t know which could be to let the users work offline. I will appreciate your ideas and thoughts …

I am trying to create a automation when record is updated. and column is delete reason is filled out, I want it to update 3 fields... Active to unchecked, remove by date to current and removed_by to user to logged in user... but it fails. Could you help?  

Hi all,  Sadly, when tagging @yourself, you do not get an email notification from Airtable. I was hoping to solve this with an automation. However, I am struggling to set up a trigger that can detect a comment, and further detect a comment where the user tags themselves. Does anyone have any experience with setting up email notifications when a user tags themselves? Any help would be greatly appreciated, thank you!

Hi Airtable Community,I have an interesting problem I did not forsee when we made a base to track equipment we rent to other contractors from time to time. We have a job (record) where we linked in individual records for different kinds of equipment and now that it has been returned, we need to be able to track and validate it is here. I have the individual records that were added inside an individual cell and it went in how we did it - meaning in no numerical order (we just grabbed a piece of equipment off the shelf, scanned it into the customers record and repeated. The issue with that is the individual records didnt go in in any discernable order. They each have a number, but I can't seem to sort by the record by that number. This creates an issue becuase in order to check the items back in (or rather validate that they made it back here) we have to visually scan through every item in the record looking for the right number. This won't work as it will take too much time as there are

Hello everyone! We build some Scripts with the Airtable Scripting extension and we’d like to trigger them externally via Make.com / API.Is there any way to achieve this?  Airtable Automations are not an option because we are at the 50 Automation limits already (why would you make this limit so low??) Any help would be greatly appreciated!   

Is there a way to add the description from asana card to be sent via script to airtable. I have a full script which is pulling fields but it wont pull the description 

I have a formula field that returns the URLs of an attachment field. If there's only one attachment, it returns one URL in parentheses. But multiple attachments take this form: "File Name 1 (URL 1), File Name 2 (URL 2)".Here is an example: "Screenshot 2023-07-03 141051.png (https://dl.airtable.com/.attachments/c53420d1c5692651db4f6c34e5ddc19f/8256aa0b/Screenshot2023-07-03141051.png), Screenshot 2023-06-23 130019.png (https://dl.airtable.com/.attachments/1d08cfcdd7ce28fa575f0c20738ae2ea/bc5c5421/Screenshot2023-06-23130019.png)".I want to write a formula that will extract only the URL in the last set of parentheses, no matter how many other files are listed in the cell (or just the single URL if there's only one file). In other words, I want to extract the URL of the most recently uploaded attachment, which is always the last one listed in the cell.

My Ask: What methods can be done to direct or redirect automation error notifications to other base users.For many of the builds, I create the automations thus all error notifications come to me when an automation fails. From what I read, if I want another user to receive them, they have to be the one that creates the automation and turns it on. I would need them to ‘duplicate’ the automation and delete the original.Most of these errors come with the interactive actions involving ‘humans’. A prime example is when a form submitter does not enter their email in correctly thus a confirmation email does not execute. These are operational details that the person I built it for can handle and address. I hate to be the go between for these errors or do something fancy with my inbox to forward them to other users.Thoughts in other methods or do the duplicate way? We are looking to get Zapier that might be a method toward a solution.

HelloApologies if this has been asked before but I can’t find a solution that works. I have a base where all times should be for UK/London (it is scheduling of spaces in a building), wherever in the world I am I want any date or time entered to be UK time. Thankfully Airtable have now fixed this in the normal UI, but I am struggling to find a way of achieving this for dates entered via a script in a script block (not an automation) - I have an input.text field and can parse the date and time, but currently that time will always be based on the time zone of my browser, not the base. Does anyone know of a good bit of code to sort this out - I wonder if I should use offset. but I worry this would not work for DST?

Hi all, I am new to Airtable and would be grateful if anyone can point me in the right direction. Here is my use case:I manage freezer inventory for a small family business. They bring it food items, vacuum seal them and place them in freezers. The issue is, no one can remember what or how many of any specific item is in the freezers.I would love to be able to create an item tracking system for them in Airtable. For entry, I would like a form that they simply enter an item description. Once submitted, an item number pops up that can be written on the item. (Ideally, if there was a way for it to print a barcode on a computer attached Brother PTouch label  maker, that would be incredible). But either way, after an item is entered, it provides an item number, checks the item in as “in freezer” and adds a date. For removal, I want it to be extremely simple. When a staff member pulls something from the freezer, I would ideally have an ipad with a barcode scanner. When the item is pulled, th