Ask the Community

Hi! I'm attempting to have an email going out to remind clients of their appointment time & details the before it happens. For example at 9am on the day of the appointment. I created a formula for "Is this today?" IF(IS_SAME(TODAY(), SET_TIMEZONE({Start Time}, 'America/Anchorage'), 'day'), 'Yes', 'No') The automation for "When a Record Matches Conditions" (When "Is this today?"=Yes) is used so that it creates an individual email for each appointment, rather than one email with all of them.  This fires at a weird time of day (5pm PST) so I'm sure it has something to do with time zones. I have attempted to modify the time zone this formul

Hi - I'm looking for help building a tracker for customers that sign-up for beta programs. I have a table for Customers. And I have a table with a list of Beta Programs.For each beta program, they will have a google form where customers can be nominated. Then I want it to the feed into Airtable. Each customer nomination needs to go through a process so their status can move from Nominated > Pending > Confirmed. Is it possible to have one table per beta program, then one table that has a list of all beta programs that gives a count of who many customers are confirmed?

Hi, I'm trying to make either a script or automation to update Table A from a list of values in Table B.Table A is a list of shifts in multiple clinic locations. I'd like to be able to select a clinic location in Table A (from a single select column), and have the address for that clinic populate in the Address column in the same table. In Table B, I have the list of clinic names with their addresses. I'm trying this script, and it will run, but it doesn't do anything to the Address column in Table A. Any help would be greatly appreciated- new at writing scripts... Thank you in advance!

I just created a budget table, and three fields(cost, products, and source) are integrated with the product table  (pulling the cost field from the product table when I choose a particular product from the budget table). if the cost field is empty or 0 in the product table, the integrated cost field in the budget table should be editable. But I have no idea since the cost field type is lookup or rollup. Is that possible?

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into some challenges with getting the formula to calculate correctly. Here's an example of what I am trying to achieve:Item A; Quantity = 10, Unit Price = $20, Discount = 10%Item B; Quantity = 5, Unit Price = $15, Discount = 0%I want the formula to calculate the total cost for each item taking into account the quantity, unit price, and discount, and then sum up the total cost for all items.Could someone please guide me on how to structure this formula correctly?Also, I have gone through this; https://community.airtable.com/t5/formulas/need-help-with-formula/

Real-time automation does not work. I select Trigger: When a record is created, there I select in which table the new row was created. Then I select Actions: Create record and indicate in which table to create a new row. In Fields I indicate in which line to copy the values ​​from which line.When testing automation, everything works fine, new rows appear in the table. However, when creating a new row, a new row is automatically created in the required table, but the data is not transferred.

All of my automations across multiple bases are consistently failing to trigger naturally, even though they work fine when I forcibly "test automation". They also worked fine a few weeks ago. This includes a few different trigger types (buttons, when a field is updated, when a record matches conditions, etc.). I'm losing my mind as AT support is taking ages to help me (one email a day or every other day suggesting things that are clearly not useful if they'd take the time to properly engage with what I've sent) and several processes across the business are failing. Any ideas?[Screenshots show the run history of just one of my automations followed by a screenshot from when I "test automation". They're ALL malfunctioning like this]

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:"This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uri"This is the URL I am using:https://airtable.com/oauth2/v1/authorize?client_id=1236efdd-af9c-492f-8885-4e5e08fa7890&redirect_uri=https://devtest.planr.io/ords/f?p=800%3A2723&response_type=code&state=436

Hi, I have been having problems with this for weeks now and cannot understand why my automation is not working. I work for a company that runs an appointment based service. I book the date it  is for and the status of it. When I put in the info, it is defaulted to "Booked". When the day AFTER the appointment comes, I want the system to find all record that match the given criteria (appointment yesterday, status booked) and update it to "Completed" I have tried a million different things but nothing is working.  Here is what my configuration is.. Someone please help me understand what I am doing wrong..

Hello everyone. I have a question here and would like to get your answer to it. If we have many bases in one particular workspace, and some are synced bases and some are source bases, let's say A is a source base and B is a synced base whose data is synced from Base "A". Again, all of them live in the same workspace. If we want to create a new workspace and move Bases "A" and "B" to that new workspace, will this workflow or configuration affect the current data synchronization from Base "A" (source base) to Base "B" (synced base)? Thank you. 

Hi all, I'm a fairly proficient AT user but I just can't wrap my brain around this current project. I make and sell jewelry pieces. I do a combination of "stock" items and custom items. For stock items I'll make 5-10 identical pieces that I sell as-is. But then there's the custom work. I want to create a comprehensive system that calculates MSRP for both stock and custom pieces, tracks orders and inventory, and tells me what stock I have currently on-hand. I can't for the life of me figure out how to structure the base to be able to handle both stock items and custom orders. Stock items would record details like size, color choices, weight, etc. But they are set per item. On custom orders those details are set per order, not per item. I've been toying with a base structure something like:Products Table for recording stock itemsOrders Table for recording cust

Im using the "Record Review" template for users to choose a record and then see all it's details.Each of my records has multiple date fields. I'm hoping to show these dates with a calendar element, however it seems I can only show dates for every record in the whole table or dates from linked records in other tables. Not actually just the one selected. I've tried to play around with filtering but that does not seem to get me anywhere.Is it really not possible to show one or multiple dates only for the records that has been selected?

We have a form that we use to calculate current enrollment of a program, this number will change periodically.  We have an interface that shows a bunch of other data points as well.  How can I display the last entered data for currently enrolled?

Hello, I want to add a calendar to my website with the scheduled events, which the volunteers can then sign them self up for (or basically just put their name down or click attending) to the particular events they wish to participate in. Any info on how I could do this would be HUGELY appreciated. Or if there are any suggestions on a better solution to this issue. Thanks in advance!

I have created a Google Calendar integration for Airtable. However, the Google Calendar I created shows up in “Other Calendars” as apposed to “My Calendars”. This means I cannot choose “free/busy” in sharing permission in Google calendar. My hope is that people on my team could events in Airtable to block off time in their own calendar so other team members could see they are busy and not schedule meetings with them. Is there something I am missing? Is there a way to get access to the integrated calendar so that I can show as “Free/Busy”? Thanks!

Hello! I found a few other posts on this topic, but none that contained a solution, so trying again. I have created an operational calendar in Airtable, which I would like to sync with my organization’s Google Calendar. As far as I have found, there are two ways to do this: by creating a calendar in GCal from the Airtable URL, or by using Zapier. I’ve tested both methods and they both work well initially. But neither one seems to handle updates well. With the URL method, there can be a lag of up to 24 hours to show updates. With Zapier, you can only create a new calendar event when the Airtable record is updated, rather than updating the existing calendar event. Has anyone found a workaround or a better solution?

Hey, I want to create a link inside my long text field with rich text formatting enabled by zapier. But when I write [Airtable](https://airtable.com) in Zapier I don’t see the Link as a hyperlink. I just see the text:

Dear All,We have an digital product manufacturing line and we are using airtable to assign an order.Right now, they couldn't filter any data on airtable while it is opened on iPad. Before update it is working and they reach relavent data by using date filter.Besides, it effects not only list interface but also on any other interface.Could you please be so kind to get any help how can I overcome this issue? or which overaround solution can be implemented?Thanks in advance.Umut

https://www.loom.com/share/75e6d81b7dc7414d9bdd62eba0e7f791?sid=a551b367-107b-4d5e-b2e3-c5573874cf5cSteps:Enter a role required to be at an eventFinds people associated with that roleUpdates people required at the eventWhen I delete the role required, the automation seems to run twice and deletes the people required, but then adds everyone associated with that project, and when I check the Run History, it only runs once.Any idea what's going on?  Thanks in advance

Hi Support,I have a Team Plan with one collaborator. I paid an annual fee last month but I was just billed again another annual fee. Can you please help to understand what is happening?It is unfortunate Airtable has been giving us quite an unique experience. Two months of activity and two major issues. Hopefully it will improve soon enough.

I'm brand-new to Airtable, and I'm trying to use it for managing an upcoming burlesque show. Each record will have all the details for each act, and then I'll create interfaces for each relevant team member (stage manager, sound board operator, host) that has the information they need for each act, in the order that each act will be going on stage.The most important thing is that the producers need to be able to rapidly change the order of acts in the show, if performers drop out at the last minute or something like that. So what I'm looking for is an easy way for them to be able to change the order of acts in one place -- preferably by drag-and-drop, but entering a sequence number manually will also work -- and then the order of the acts automatically updates in every other interface. Example: The first act is supposed to have performances from Hezzy Tate, then Amber Dextrous, then Trisky Business. So everyone's interfaces have all the information in that order.

Hi I am building a simple CRM. I have a Company table and a contacts table. On the Contacts table there is a Checkbox marking a single contact as the “Primary contact” I’d like to show this specific contact when I view the Company, effectively “just the contact flagged as primary” Can’t figure it out, any help appreciated Thanks Mike

I've created a form. Originally I had it emailing a specific user (me) under the form's Submission options. I've since removed that and republished the form, but it won't "stick." Every time a user submits a new form, it emails me. And when I go back to the submission options under Email responses, I've been added back.No matter how many times I remove myself from receiving responses, I still get them. I’m doing this under Interfaces/Forms view where I create and edit forms. The selection is in the right sidebar.I will uncheck my name — I’ve even tried Clear all, even though I’m the only one selected. Then I republish the form. It will show that I’m no longer receiving email responses. I can leave and go back, and it still shows correctly. But once someone sends a form, I get the response anyway. When I go back to the forms interface, it shows me as receiving responses.In short: When I disable my receiving responses in the interface view, it won’t stick. I

hey guys,I have a huge database of customers in metabase.comwhat i want to achieve is a script that will access metabase via api, query the bookings table and based on some criteria return value from field ID (booking id).https://www.metabase.com/docs/latest/api/card#post-apicardcard-idqueryNow, this is what i've done so far:1. I managed to create my session token via postman2. I run this script in airtable:  const METABASE_API_URL = 'https://CCCCCCCCCC.metabaseapp.com/api/card/AAAAAAAA/query'; const METABASE_TOKEN = 'BBBBBBBBBBBBBBBBBB'; async function fetchMetabaseData() { try { const queryPayload = JSON.stringify({ type: 'native', native: { query: "SELECT id FROM booking

Hey guys, I've been using Airtable to track my fitness results for well over one year now, and looking to see if it's possible to send people templates they can use and implement into their own Airtable accounts. All they would have to do is "sign in", or accept. Is this possible? How would this work? Please let me know. Thanks