Ask the Community

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

Hi All! Can anyone provide some scripting advice - I want to create a script that changes a field type from Multiple Select to a Text field when it runs, and another script to do the reverse. Thanks in advance for any feedback!

OpenAPI is an API specification format which provides a way of creating a standard format to represent a given REST API. There’s a large community of tools built on top of the OpenAPI definition, including mock servers, schema visualizers, and SDK generators for a given language. Using Custom Blocks and the OpenAPI Schema UI we can create block which reads a base’s schema, generates the corresponding OpenAPI definition, and then displays the resulting documentation. Users can then export this schema and run it through any of the open-sourced OpenAPI tools. The Swagger UI also provides a way to make API calls from the documentation, so it can also be used as a playground to experiment with the Airtable API and see those changes immediately reflected

I am helping a friend's small restaurant create a drink menu that can be viewed from iPads in the restaurant.There are many types of beverages that are updated in the master Airtable.I just want a view-only way for customers to glance at that list on provided tablets. The main data types are, - image of the drink-price- descriptionswhat's the best way to do this?  If there's a good plug-in that adds to the viewing experience beyond the basic features, we don't mind paying for that too.

I have a table that I created to track resource allocation, and use that information to then report out to a graph in my interface to show based on the allocations, how much I would be expected to spend each month. The setup for this is a bit of a workaround to solve for not being able to have multiple fields reported into a chart.  This is working how i need, but it is prone for error if I do not manually link the months in the linked field. I'm trying to create an automation, or solve this in any way that doesnt require me updating both the linked field and the fields that determine if a resource is active or not. My hope is that I could create an automation that would check the Month Fields, and if a Month is set to active, it would then enter that Month into the Linked Months field - this way i could just update the allocation fields, and my report would always be insync with wh

Hello,Alright, so I've been trying to automatize a duplication of a worksheet in a Google Excel document, I've tried through Make as well, but I can't seem to make it workAnyone could point me where or how to do this?Thanks,M

I have 4 Tables (Payments, Receivables, CostCenters, Extract)The Payments and Receivables records are linked to CostCenters records.The Extract records are linked to Payments ou Receivables records ("If it's a receipt, it will be associated with an account receivable, and if it's a payment, it will be associated with an account payable.) So i want to make a formula field with an IF to get a cost center from Payments if the record is linked to a payment if not it will get the receivable costcenterIs it possible?

Hi Airtable - Can I please get some help in resetting my automation runs? I just ran out of automations for the month (due to a runaway automation that we have now resolved), but nmy business is non-functioning for the rest of the month because we have no more automation runs.Can anybody please escalate my emergency support request? My Airtable support reference # is 00762406.PS - Are there any intentions to allow us to automatically purchase more automation? Feels unfortunate to be locked in without options.Thank you! 

Hey all! I am trying to set up a form that is being sent out to about 200 people for the purpose of tracking time allocation for employees. To do so, the employees will fill out a form at the end of the week, selecting the projects they worked on throughout the week. After selecting multiple projects they worked on, I'd like for the form to auto-calculate the % of time they spent on the project. For example:If a person worked on 4 projects, the formula spits out that they spent 25% of their time across all 4 projects.If a person worked on 5 projects, the formula spits out that they spent 20% of their time across all 5 projects.After doing this, I'd like the user to be able to edit the percentage tied to each project, and then automatically adjust the other percentages to total 100%. Thoughts on a solution here?

I'm wondering if this platform offers app creation (front end GUI).

Hello All,Is it possible to implement a Lazy Approval function using Airtable Automation?

I have an automation set up to find records based on a view. In that view - there are 17 records. When I test or run the automation, it only returns 10 records. I can't figure out why this is dropping 7 records. I've tried recreating the automation, and I still get the same issue. I was thinking there might be an extra space. But I can't seem to find it. 

Hi community, when I try to add extension I get this tooltip. How to solve the problem for this dashboard? (I can still add extensions to other dashboards)

I am trying to create a scheduling tool in Airtable to book appointments with outside clients. I created a form that is linked to schedule availability and includes name, role, email, etc. At the bottom of the form, they can choose a date/time. Is there a way to include a location with the date/time?For example : some meeting slots are 30 min. but are either in-person or virtual as labeled in my table. However, the person filling out the form cannot see the options 'in-person, virtual, etc.' and I would like each day/time to be associated with its corresponding location (in-person, virtual, etc.)Is there a way to do this?