Skip to main content

User Groups
Product Ideas
Events
Academy
Help Center

Welcome to the Airtable Community!

Ask questions, get answers and engage with your peers

39,507 Topics
121,976 Replies
100,935 Members

Get Started

New here? This is a great place to start

Ask the Community

Get support directly from your peers

Builders Board

Celebrate your Airtable wins

User Groups

Forge connections with other Airtable users

Events

Explore and RSVP for upcoming events

Announcements

Read the latest news the Airtable team

Check out the Enterprise Network ✨

Check out the Airtable Enterprise Network (or 'AEN'), the exclusive hub for Airtable Enterprise customers. Access private events, connect with peers, and ask your top of mind questions here.

ENTER HERE

Airtable Enterprise Network

What's New in the Community

The Community Digest

Categories
Recent Activity
Help Others

Welcome

Welcome to the Airtable Community! Check out our resources on this page to help you get started. Lets learn and grow together!

Getting Started on Community

Getting Started on Community

12 topics

Onboarding Resources

Onboarding Resources

12 topics

Announcements

258 topics

Ask the Community

Ask the Community

Automations

5003 topics

Base Design

3225 topics

Formulas

5850 topics

Development & APIs

Development & APIs

3600 topics

Interface Designer

Interface Designer

1267 topics

Other Questions

Other Questions

14339 topics

Builders Board

Builders Board

Show and Tell

994 topics

Product Discussions

Product Discussions

2 topics

Jobs Board

998 topics

Legacy Product Ideas

Looking for a post that was once on our legacy Product Ideas page? They're all viewable here. Note that all future product feedback must go through the new Product Ideas submission form here: https://community.airtable.com/p/product-ideas

Legacy Product Ideas

Legacy Product Ideas

2697 topics

Jill_HollandParticipating Frequently

We are using Airtable to organise our plant nursery. We need it to track the stock of plants in the nursery and match to orders etc. Its a bit different to normal stock tracking where we might track "current stock" by adding to stock when we get in stock and subtracting as orders go out because we have to grow the plants from seed and there are often plants dying, not being good quality etc. So we often have to go out and count the actual plants in good condition on the tables to get an accurate idea of stock count. But we also want to be able to subtract from the stock count automatically as stock is sent out. So we have a conflict between what we want to enter as our current stock levels - if we have a calculation in the current stock field - auto subtracting deliveries - we can't simply type in a number when we do a manual stock count. Any suggestions on how to resolve this ?

User251New Participant

XLOOKUP and INDEX Match Equivalent in Airtable

I have two tables, Table 1 and Table 2, with different fields. When a specific record is populated in Table 2, I want the values of some of its fields to automatically appear in a corresponding record in Table 1where the cells were initially empty, based on the primary fields of both tables, I’m calculating a total in Table 1 based on entries into records in several tables and need to have the total in Table1 automatically updated whenever the values change in the other tables. What is the best way to achieve this? IOW, what is the equivalent of XLOOKUP or Index Match in Airtable?

dcurmeNew Participant

Interface Designer

Lookup field in end-user interface?

Hi All – I have a large base which essentially functions as a CRM. The first field in the base is “partner name” and the subsequent fields are information about the partner - location, bio, Linkedin profile, etc. We use the base to track engagement and other touchpoints with the partners. I want to build an end-user interface while allows my executive director to input the name of an individual from the base and then have it return a few specified fields. For example, the ED has an end-user interface and is instructed to input a partner name. After inputting the name, the interface returns Linkedin profile, bio, and last-emailed (all fields that we collect and keep up-to-date). I know it’s possible to just make my ED an editor and give access to the entire base but we have 50+ fields and I want an more user-friendly experience. Privacy is not the concern here, rather my ED doesn’t need to see all the fields and details in the base. Is this kind of build possible with an interfa

Corosh ToshangNew Participant

Looking for an Airtable expert (with Make.com & Softr experience)

Hi!We are looking for a skilled individual or company experienced with Airtable, Make.com, and potentially Softr. Our goal is to customize a database solution tailored to our specific needs.We’re looking to: Optimize and structure our Airtable base Set up automated workflows with Make.com Possibly create a frontend for the database (using Softr or another tool) Connect Airtable with our website/backend Preferably, we would love to work with someone based in Sweden or who is comfortable working in Swedish, but this is not a strict requirement.If this sounds like something you can help with, feel free to reach out via DM or comment below. Looking forward to hearing from you!

vivranceNew Participant

Resetting fields on a "shift duties" board daily with 'update record'

Hello, I was hoping to get some guidance on what I’m doing wrong in regards to updating the “completed by” field on a salon “shift duties” board interface. My partner built the base/interface for her salon and has asked for help in making the automation work.The goal would be to change the drop-down for each task to “not done” every night via a scheduled trigger.I’ve found a few related topics and used those to guide me but I can’t seem to get past testing the actual record updating part.If I utilize the list of record IDs from the ‘find records’ step, I end up with ‘ received invalid input’ errors.My automation process:Scheduled Trigger → Find Records (Where “Completed By” is any of [all options selected]) → Repeating Action Group (Repeat for each in [List of records]) and → Update Record (Record ID is list of all records found previously - “Completed By” field updated to “not done”)A couple pics of my attempt:I would love to know what I’m doing wrong! 😑Pic of the interface for con

KaRenNew Participant

Share permission

I have a digital asset management database with multiply artists. I would like to share only one artist’s assets with other people so they can edit on it, and the edit would sync back to my database too. I’m in Team plan currently.The solution I came up with is to create a View with only the data that I would like to share. Then create a 2-way sync and edit to a new base and share the collaborator permission of the new base. But that would require me to update go Business plan.I’m wondering if there’s a workaround with the Team plan?Thanks.

gelbNew Participant

Development & APIs

Creating a Tap in Tap Out system for a coworking space (Webhook question)

Hello! I’m setting up a community coworking space and would like to have a simple tap in/tap out system so we can log who’s visiting the space, how long folks are staying, and how the space is being used. My idea is to use NFC tags with unique webhook payload information stuck on cards that when tapped on a reader near the entrance, a webhook is fired into Airtable with the unique information about that tag. Within airtable we’d then set it to log the taps and workout if someone is ‘in’ or ‘out’ (with the ability to override of course). My questions:Does this seem like the best approach or would anyone suggest a different way to go about it? I’ve searched the forums and aside from some discussion around RFID I haven’t seen anyone talk about setting things up this way. If so, what’s the best way to configure the webhook to fire when the NFC tag is tapped? We’ll be using an office PC with an external reader, and I’m not sure what the best route is to go from ‘tap’ to ‘webhook fired’.Any

XingKnown Participant

Other Questions

How to Archive the Base

hi dear folks, I’m wondering, if I build the Base according to a specific project, once this project has been completed, how could I archive it? For instance, if I start from a Base on “house hunting”, after serval months, when I found the house, literally I shall not use this base anymore, it is no longer make sense to keep it on the workspace as well, and what’s the solution for the archive it in the local disk? Or do I need to archive it? Thanks for any pieces of advice.

Mike_LauferParticipating Frequently

Other Questions

How to Export Table Structure

Is there a way to export the structure of a table to csv, JSON, etc.? Specifically, I’m looking for a way to export information about a table, not the data itself. Some method that will give me an output like field 2 is long text, field 3 is lookup, field 4 is date, field 5 is single select, etc.

Markus_WernigInspiring

Development & APIs

Can CSV exports of tables (backups) be automated?

I try to create CSV backup exports of all my bases as often as I remember. However, going through everything manually is a lot of work and leads to “not doing it” more often than not. I wish there was a way to automate this important backup process. Can this be done through an outside service maybe? Thanks in advance!

User251New Participant

XLOOKUP and INDEX Match Equivalent in Airtable

I have two tables, Table 1 and Table 2, with different fields. When a specific record is populated in Table 2, I want the values of some of its fields to automatically appear in a corresponding record in Table 1where the cells were initially empty, based on the primary fields of both tables, I’m calculating a total in Table 1 based on entries into records in several tables and need to have the total in Table1 automatically updated whenever the values change in the other tables. What is the best way to achieve this? IOW, what is the equivalent of XLOOKUP or Index Match in Airtable?

dcurmeNew Participant

Interface Designer

Lookup field in end-user interface?

Hi All – I have a large base which essentially functions as a CRM. The first field in the base is “partner name” and the subsequent fields are information about the partner - location, bio, Linkedin profile, etc. We use the base to track engagement and other touchpoints with the partners. I want to build an end-user interface while allows my executive director to input the name of an individual from the base and then have it return a few specified fields. For example, the ED has an end-user interface and is instructed to input a partner name. After inputting the name, the interface returns Linkedin profile, bio, and last-emailed (all fields that we collect and keep up-to-date). I know it’s possible to just make my ED an editor and give access to the entire base but we have 50+ fields and I want an more user-friendly experience. Privacy is not the concern here, rather my ED doesn’t need to see all the fields and details in the base. Is this kind of build possible with an interfa

Corosh ToshangNew Participant

Looking for an Airtable expert (with Make.com & Softr experience)

Hi!We are looking for a skilled individual or company experienced with Airtable, Make.com, and potentially Softr. Our goal is to customize a database solution tailored to our specific needs.We’re looking to: Optimize and structure our Airtable base Set up automated workflows with Make.com Possibly create a frontend for the database (using Softr or another tool) Connect Airtable with our website/backend Preferably, we would love to work with someone based in Sweden or who is comfortable working in Swedish, but this is not a strict requirement.If this sounds like something you can help with, feel free to reach out via DM or comment below. Looking forward to hearing from you!

vivranceNew Participant

Resetting fields on a "shift duties" board daily with 'update record'

Hello, I was hoping to get some guidance on what I’m doing wrong in regards to updating the “completed by” field on a salon “shift duties” board interface. My partner built the base/interface for her salon and has asked for help in making the automation work.The goal would be to change the drop-down for each task to “not done” every night via a scheduled trigger.I’ve found a few related topics and used those to guide me but I can’t seem to get past testing the actual record updating part.If I utilize the list of record IDs from the ‘find records’ step, I end up with ‘ received invalid input’ errors.My automation process:Scheduled Trigger → Find Records (Where “Completed By” is any of [all options selected]) → Repeating Action Group (Repeat for each in [List of records]) and → Update Record (Record ID is list of all records found previously - “Completed By” field updated to “not done”)A couple pics of my attempt:I would love to know what I’m doing wrong! 😑Pic of the interface for con

KaRenNew Participant

Share permission

I have a digital asset management database with multiply artists. I would like to share only one artist’s assets with other people so they can edit on it, and the edit would sync back to my database too. I’m in Team plan currently.The solution I came up with is to create a View with only the data that I would like to share. Then create a 2-way sync and edit to a new base and share the collaborator permission of the new base. But that would require me to update go Business plan.I’m wondering if there’s a workaround with the Team plan?Thanks.

gelbNew Participant

Development & APIs

Creating a Tap in Tap Out system for a coworking space (Webhook question)

Hello! I’m setting up a community coworking space and would like to have a simple tap in/tap out system so we can log who’s visiting the space, how long folks are staying, and how the space is being used. My idea is to use NFC tags with unique webhook payload information stuck on cards that when tapped on a reader near the entrance, a webhook is fired into Airtable with the unique information about that tag. Within airtable we’d then set it to log the taps and workout if someone is ‘in’ or ‘out’ (with the ability to override of course). My questions:Does this seem like the best approach or would anyone suggest a different way to go about it? I’ve searched the forums and aside from some discussion around RFID I haven’t seen anyone talk about setting things up this way. If so, what’s the best way to configure the webhook to fire when the NFC tag is tapped? We’ll be using an office PC with an external reader, and I’m not sure what the best route is to go from ‘tap’ to ‘webhook fired’.Any

rkingNew Participant

Interface Designer

Allow users to show/hide fields in Interface view

Hi all,Longtime lurker, infrequent poster. This might be a very simple issue, but it’s causing me grief & I can’t find any other posts about it.I have a table with my org’s class schedule (& all associated data) for multiple campuses. This is shared with the org in an interface. I’ve made a few different specific views, but mostly I have our users filter/sort/group the data in a way that suits their various workflows & bookmark the newly generated URL for future use. The customization option works great, and saves me from having to create a million views for all our teams. However, I can’t figure out how to allow users to show/hide fields, like they can in shared views of tables. Examples:Shared table view (with Hide Field option) Shared interface page (no Hide Field option) Is this feature hidden somewhere I’ve yet to find, or is it missing from interfaces?We’re on the Enterprise plan, by the way! Thanks :)

mbrinkleyParticipating Frequently

Interface Designer

Copy Record Detail Layout

Hey everyoneMaybe I dreamed this, but I thought I could copy\transfer the layout of one existing Record Detail to another Record Detail.I know I can duplicate an existing Record Detail layout to a new Record Detail layout. That creates a new layout which I want to avoid since I would have to reference the new layout to replace a depreciated layout. And I have a lot of those that I need to clean up. Updating an existing Record Layout by using a different record layout is pretty useful.Is that possible? Was it ever possible? Thanks everyone!

lindsayweNew Participant

Time Zones in Email Automation Grid

I'm building a base to track volunteer sign-ups for a project. Table 1 stores Volunteer info Table 2 contains available Timeslots When a new volunteer signs up via a form on the Volunteer table, an automated email is sent confirming the timeslots they’re registered for.The issue: When I include a grid of timeslots (using a Find Records step in the automation), all of the times are showing in UTC. I need them to display in EST.Here’s what I’ve tried: I created a formula field to convert the time to EST using SET_TIMEZONE, and also tried A single-line text field that gets updated by a separate automation But when I try to include either of those fields in the grid, the grid shows the correct number of records, but all the cells are blank.Has anyone figured out a way to include times in the correct time zone (EST) inside a grid in an Airtable automation email? Would appreciate any tips!

Farrukh SheikhInspiring

Other Questions

How to change the default email program

Hi,Clicking on the email address opens Microsoft Outlook Live. How can I change the default settings to open Microsoft® Outlook for Mac?

Welcome to Airtable Community!

Make sure to register or log in

Please read our community guidelines

Join one of our user groups (+ events!)

Help others in the Ask a Question area

Community Events

Leaderboard

Airtable Academy is free for all Airtable users and plans.

Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.

Sign up for Airtable Academy Get Airtable Certified 🏆

Powered by Gainsight

Terms & Conditions

Platform Platform Overview Integrations Extensions App Building AI Connected Data

Solutions Product Marketing Operations Human Resources Sales Finance

Learn Airtable Academy Events Video Center Demos Customer Stories Webinars

Resources Partners Services Developers Community Templates Airtable Universe

Company About Careers Blog Status Newsroom Try Airtable For Free

Security API Sitemap Privacy Terms Do Not Sell/Share My Info Cookie Preferences

Sign up

Already have an account? Login

Login with SSO

Log in with Airtable SSO

or

Username *

E-mail address *

Password *

I accept the terms of service

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

Log in with Airtable SSO

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK