Ask the Community

I am trying to build a system for a one-man business so the owner will be the only user.  While I’m building at least, how do I restrict the owner from being able to edit anything other than what has been allowed in Interfaces?

Hi everyone,I’d like to know if, on the Business plan, there is any way for a user on the Free plan to update or modify a field in a base without incurring additional charges.Is this possible through automations or any other workaround?Thanks in advance!

Current Table Current Interface ViewCurrent “Start Tracking” button AutomationCurrent “Stop Tracking button Automation step two … unsuccessfulThis is my current table, interface and automation set up to try and create a time tracking interface. I am stuck on the “Stop Tracking” button automation. I can’t seem to be able to update the

I have a base with a single table that I’ve published as a library. I went to add that to another base and noticed that there’s a description that I had previously given to the library base, but now I can’t figure out where that description lives. I need to be able to update that text. Is someone able to tell me where that info lives? Slightly longer description of the text I need to edit:In the new base, I click on the plus sign to add another table, and under the ‘Add from data library’ I click on ‘View more...’  Then I see a few cards with the bases I’ve added to the library, and they each have a brief description that was obviously written by me. 

Hi everyone,I am looking to connect with 3 other committed No-Code builders who are serious about turning their skills into a business but want a "team" to practice with first.I’m currently at the Beginner/Intermediate level. While I feel confident visualising workflows and fairly confident building them in Airtable, I still feel that ‘imposter syndrome’ when it comes to the logistics of client delivery - managing permissions, handling live updates, and ensuring I don't break a production base.  And I also still have a lot to learn on the technical side. The Proposal: I’d like to form a small, consistent collaborative group where we can build a portfolio project together in both Airtable and SmartSuite.My suggested structure for the group (open to discussion!):The "Mock Client" Approach: Instead of just building in a vacuum, we could buddy

How do you think web data analysis will change the way companies make decisions in the next few years?

HelloI am a relatively new user of AirtableI am interested in using it to manage my life and work using the 12 week year approachI downloaded a base from the community for thisI am trying to understand how I can use this base week in and week out without having to copy and paste tasks repeatedly? Thanks

With all the new features within the last 2 year sure there is a better way for clients to update their own records. Although it works it is still clunky and would be great to streamline this process.  Context: I have been using fill out, where I send clients their unique URL and they fill info like dietary restrictions and it auto-populates/updates their row in Airtable. Is there a way to do it natively inside Airtable?Is there a simple way to say, like if they don’t fill the information in 5 days it sends them a reminder? Thanks everyone,Sonia

The precision of this error is completely useless…Google reported an error while processing this action: An error occurred while creating the Google DocIt happens +/- 10% of the time, always the same error, on different automation workflows.When I rerun, it passes every time, and doesn’t waste space to tell me it passed because it passed. I read it could be that it gets triggered while not all fields are filled, so I changed the trigger condition to “is not empty” for each of the relevant fields. I’m now out of clue, frustrated by this error description.On this community, I see other having “Mail service not enabled” or “Calendar usage limits exceeded” or “You’ve temporarily hit Google’s rate limit” Those are useful.But to report me an error for the reason that an error occurred.First time I see this.

I am very new to airtable so excuse me if I misunderstand some things.I am trying to use airtable to create a calendar of my bookings.I have two types of bookings. One that lasts exactly 30 minutes and one that lasts several days and start and end time are customizable.Because its a chore to pick a date and time exactly 30 minutes past the start time for my short bookings Im trying to run an automation so that anytime I create a record with no end date it will set the end date field to exactly 30 minutes past the start date.Is this possible?  

Hi AirTable Community,I’m looking for a simple vocabulary or terminology cheat sheet for Airtable that defines core terms like bases, tables, fields, views, records, interfaces, automations, etc.Does something like this already exist—either from Airtable or from the community? Ideally something that could help new users quickly understand the platform language. Thanks! Rebekah

Hello everyone,I am currently developing a base which will allow one of our departments to plan employee trainings (which will be conducted via Microsoft Teams).  Tranings can be planned and employees can be linked to events (via a Employee_Training table).Part of this solution should be, that after the event has happened, the business department wants to track, which of the invited collegues took part in the Teams meeting.So I would need a way to get the attendance list of a Teams meeting, cross reference this list with employee list in Airtable (propably via email) and then mark them as “show-up” if a match is found.Has anyone ever done something like this or has an idea how to achieve this? I appreciate all the support I can get. Thank you in advance. Best regardsChristopher 

This is really more of a development & workflow request for help. I have around 60k Shopify variants across 8 different vendors. I get the vendors/suppliers produc master data at the UPC level via a CSV file, which I can import into a base. I want the workflow to to use the CSV base to search for matching UPC’s in the supplier/vendor base. If a match is *not* found then the records needs to be added to the supplier base then synced to Shopify. If the UPC *is* found in the supplier base then the records needs to be updated. There will be many deafult values if a new record is added, and mapping rules which would be different for each CSV base.I would appreciate anyone interested in a project of this type. Thanks

Hi,I’m new to airtable and I try to make a script triggered from a button field. I need to get the selected record linked to the button clicked but could not find how to achieve this.I can’t believe there is no way to get the current record id from the script, what am I missing?Thanks.

Hello, I want to build something and need your thoughts on it.We have seventy technicians who need to conduct an inventory of their vehicle contents once a year. I would like to map this using Airtable. I have the data of the technicians in another database, which I sync into the new base. Now the contents from an Excel file (each technician naturally has a different one) must be copied and pasted into Airtable. The inventory should then be able to be conducted. Each technician should only see their own data (this can be done easily via the Airtable ID). The technician should confirm at the end that the inventory is complete and then no longer be able to make changes. I am only missing the basic concept of how to best structure the base. I have an idea, but I am not sure if it is wise. Therefore, I would appreciate brief bullet point input from you. Many thanks! // Update ;) I can answer the first question myself right away. I would filter the view

We use Airtable Interface to match caregivers to clients based on required skills such as Alzheimer’s care, hospice experience, and Hoyer lift. Multi-select fields are the best structure for this type of data because they are clean, scalable, and easy for our team to maintain.In the Interface, we use multi-select dropdowns such as “Skills and Experience” to narrow down caregivers. However, when selecting multiple values in the dropdown, the behavior uses OR logic instead of AND.For example, if we select both “Alzheimer’s Care” and “Hospice Experience,” the results show caregivers who have either skill, not those who have both.In real workflows, we often need to find caregivers who meet multiple required criteria at the same time, such as Alzheimer’s care and hospice. The current dropdown behavior makes this difficult and not intuitive.We understand there are workarounds such as adding multiple conditions or creating helper checkbox or formula fields for e

Hi all I have an automation set-up, that changes the status of a record. This is performed via interface/record picker view. As owner/admin I am able to run this automation when clicking the button, however my colleague who is also an admin, is unable to click this button. It’s greyed out.  I understand there are some limitations if the record is coming from a different base. Does anyone know a workaround please?  Hope I’m making sense here… Thanks!

Hi!I am looking for a workaround, where I can turn a single record with multiple dates into separate records with a single date… new records are created via FillOut.  we’re a charity delivering some programmes over multi week periods. An employee completes the fill out form, puts the dates they’d like us to deliver the programme on, and then submits the form. i can view all these dates via calendar view, but was hoping to view them via list view also but as they’re individual records it won’t work this way. sorry this probably isn’t making much sense but hoping someone will understand where I’m coming from…thanks!

Buenos días, alguien tiene algún ejemplo de como hacer un control de fichaje de empleados con airtable? 

Hello.  From a Jira filter, I was able to sync time fields and then it stopped working yesterday. Anyone have any ideas why?  I have a ticket in with support but have not received a response.

Hi all, I hope you’re well. I'm building a paid directory and I need to integrate invites link in my IT strategy.However, I'd like people who might stop paying the subscription to no longer have access to the directory (without deleting the invite link).Does someone know if this is possible ?  

The new custom interface feature is incredible, it’s unlocked so much functionality for my organisation but one thing that would take it to the next level is being able to place custom interface blocks inside of standard interface pages.Please add this one to the backlog 🙏

Hello !We have a list of contacts for each entity that we work with. Within this list of people, there are 1-3 people who are designated as authority contacts.I am trying to automate an email to send out periodic reminders to review their information. With a single auth contact, I have a working automation with links personalized to each person.This becomes harder when there are multiple auth contacts. I need the email to be sent to the group of people rather than individually. If I use a token to pull the URL value for the record, it’ll show duplicates of the URL in the email body. Anyone know of a way I can rework this or add to it to make sure that only one of the records’ values displays?

I currently have a table where I compare student scores to the national mean score. For example, I have 40 students and need to calculate the difference between each student's score and the national mean.I would prefer to do this without repeating the national mean 40 times in a separate column. Is there a way to achieve this with a linked, locked reference?In Excel, using the $ symbol locks the reference cell in another table (allowing you to only input it once). I know Airtable doesn't offer that feature, but I'm sure there's a workaround or method. Could someone share it with me and help?Example of what I want to accomplish in Airtable using excel logic:[Table B1: Student Score]-[Table 2: $B$2]  1550 - 1555 1549 - 1555 1540 - 1555 1536 - 1555 Where 1555 is in Table 2: B2, listed only once

Hi Airtable Community, I’ve got a sandbox running on one of my networked Airtable bases as I work on configuration to connect it to another platform, but I keep getting an error message when I try to apply changes made in the Sandbox to Production:  It’s the same error every time. I have creator permissions in both environments, as do the accounts of our external vendor working on the integration. I emailed Support, and was greatly disappointed to get an AI bot response. I’m hoping some real human beings can help me out.