Ask the Community

Hi,I have a table called Launch Calander that I link records from other tables like Email task, Website tasks and Digital & Print tasks.The lookup fields for all the other records show fine in the Launch Calander except for Email.I've tried deleting the linked record for email and starting over by creating it again from within the Launch Calander, then creating Lookup Fields and making sure they are linked to the Email Linked Record. Yet, nothing shows up. 

 Hi,For a property management company, how should I go about creating the next quarterly report?I have organized a board for:AssetsFaultsClientsEvery quarter, I aim to send each client a separate email containing a report detailing:The income generated by their assets (income for each asset is recorded on the Assets board, and a client may have multiple assets)The expenses associated with each asset (expenses for each asset are recorded on the Assets board)The expenses related to faults that occurred during the quarter (these are recorded on the Faults board).Subsequently, I wish to display to the client the total income minus the total expenses.How can I provide this data to the client while ensuring that I do not share information pertaining to other clients?Thanks.

Hi community, I’m building up automation with Gmail sending records to the mail address of the person who filled out the form. I used the Rollup field to pull the email address from the other table. I’ve run 50+ times testing trigger and all the steps which showed no error, but it never succeeded while actually performing the automation after submitting the form. I’ve also tried to delete and rebuild automation for 3 times but still in vain. I also assured that every cell of mail is not empty. I attached some screenshots of the conditi

I am mapping out the content in an academic program with the following levels:Program ObjectivesCourse ObjectivesModule ObjectivesAssessmentsI have a separate table for each of these levels.Starting at the bottom, an assessment in one of the courses is connected up to one more Module Objectives. Each MO is linked up to one or more Course Objectives. Each CO is linked up to one or more Program Objectives.I'd like to visualize these connections. It seems the flowchart extension is what I need, except it only works with self-linked records. In other words, I would need to combine all 4 levels into a single table. This is problematic because I need the levels on separate Tables. I considered copying/pasting the primary fields and the fields that link each to the other level over into a new Table that I could use for flowchart purposes. I haven't tried it to make sure it would work ye

Hello AT community, Can we embed Airtable interfaces (dashboards) to website or Notion for exemple ? Thanks

I've used Airtable for several years and have a workspace with approximately 80 bases.  Prior to one of the "upgrades", I had organized my bases in a way that was easy for me to find which base I was looking for and that made sense to me.  Now that the workspaces are sorted by opened by you, alpha, or last modified, it is very time consuming to find the particular base that I am looking for.  The "upgrade" may have been great for many people, but it was horrible for me.I have looked and can't seem to find a way to manually sort my bases so that they stick.  I suspect that this is no longer an option for me.Does anyone have an answer?I tried to contact support, but it has been several weeks and the only communication that I received from them was asking if I had received an answer yet.  Of course, I had not, because no one had answered. Thanks! 

I need to be able to export a airtable views from the mobile app. Do I have any options?-It doesn't appear that there is any functionality for this currently in the app- It doesn't appear possible with automations- There doesn't appear to be any extentions that do this- There are third party apps, but as a small charity we can't really justify paying for one for this use

Im trying to set up a BOM (Bill Of Materials), but i have thousands ind different categories and subcategories. I though it could use the use the new dynamic filtering in the the link fields, but as there a many seperate sub categories depending on the material it ends up being quite messy.So I thought I maybe can rig something up in a script extention to have the user run through a bunch of questions to filter out all the irrelevant records to finally be asked to choose from a narrowed down list (as if the user would be choosing records from filtered view). Is this possible with the script extention?

Hi, Airtable community!I'd love to pick anyone's brains at how I've set up my base.The issue I'm trying to solve feels rather simple. I want to display my attendance record when it gets marked.My current set-up:I have two tables; One with a record of all my lessons, and one with a record of all my students. These tables are linked twice. One link shows students scheduled for the lesson, and the other shows students who attended. I have automations that let me add students from my scheduled link to the attended link with a click of a button in an interface.I'd love some thoughts on how to display the attended students. I could have an empty "attended" field on the side that fills up as I run my automations, but I'd like it to be displayed directly on the students already displayed with the "scheduled" field.Here are a few of my current thoughts. I could try colour conditions, but to use this accurately seems t

I designed some simple list based interfaces for my database. when loading them in app on android or iOS, I get an error message:"this page is not currently supported on mobile. open the page on desktop to view it"Not sure why this wouldn't be supported. each page is just a list element with some filters. a couple use groups, and a couple have a filter element. apps are all current (6.4.0 on android & 10.7 on iOS).

I have a simple Zapier automation running creating a record in Base2 after certain criteria met in Base1, this is working fine. But I need to include a User in Base2, and Zapier doesn't seem able to do that unless I have a corresponding User field in Base1 -- but Base1 has no Users fields! I can't add everyone on my team to Base1 just to be able to do this automation, besides that it's adding them to a Base they never need to use and wasn't built for User Fields at all, it also will cause mayhem from the useless "you've been mentioned on this card" emails everyone will get. I just need a corresponding Name (linked record text field) to correspond with a User, without actually utilizing a User Field in Base1. Any advice? Airtable support doesn't help with Zapier and I didn't find any existing articles on this.  

let table = base.getTable("Orders"); let field = table.getField('Order Info'); let record = await input.recordAsync('Choose a record', table);I know that if I make this script, I can press the button and then select the record to run the automation.But what I wanted was to press the button and the script would already get the record without me choosing it.Is there any way of doing this?

I want to create a formula fields equal to now() with specific hours and minutes. My formula must return a date equals to today at 18:00. Exemple today is 05/06/2024 16:12 -> 05/06/2024 18:00Thanks

Hello everyone,I'm a beginner on Airtable, I don't really know where to post this message, so sorry in advance if it's in the wrong place, I have some ideas for resolution but it could be in automation, base design or then formulas, I chose to post in Other questions.I couldn't put a screen shot because the data is sensitive. 🙏I'd like to know how it's possible to keep the previous information that filled a field.Let me explain:We're doing a small CRM.So I use the Kanban view based on status and when a customer record hasn't been modified for 4 days, I've been asked to set up an automation so that the customer record goes into "Action Required" status.The aim would be to have an action to return the customer file to the previous status once the action has been carried out by the sales person.The problem is that we have 7 different statuses, so the previous status can be 6 different statuses.I thought of a button, but

HelloI've creating a function to act as a rudimentary web scraper to grab some meta data like the page title, description etc using the `fetch()` api. In an automation, this works perfectly as expected. But in a scripting extension, my `try...catch` throws an error message of "Failed to fetch".Are there some restrictions/limitations between automation scripts and extension scripts when it comes to using `fetch()` ?

I am aware it's possible using Zapier/Make/n8n/BuildshipApp etc, but this is all external apps, too much work to configure. Google Gemini has a very generous free API plan and I would be keen on getting it to work but I have no programming experience. Wondering if anybody figured out a way.

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 establis

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?