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,508 Topics
121,968 Replies
100,931 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

3224 topics

Formulas

5850 topics

Development & APIs

Development & APIs

3599 topics

Interface Designer

Interface Designer

1267 topics

Other Questions

Other Questions

14341 topics

Builders Board

Builders Board

Show and Tell

994 topics

Product Discussions

Product Discussions

3 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

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

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?

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 :)

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

jmsheldonNew Participant

Other Questions

How to create a changelog of major changes in Airtable

I'd like to have a changelog, ideally in Slack, that gets added to whenever a base, table, or field is created or deleted, and whenever a field name or type is changed. However, I couldn't find any functionality to allow this. Has anyone found a workaround for it? 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!

0800-grizzlyKnown Participant

Other Questions

How to deal with migrating development changes to production base?

Hi,I'm approaching launch for my first Airtable application, a support/ERP/CRM system for my wife's business (two users currently planned). Is there an agreed upon best practise how to launch a production version but yet be able to continue developing the application?I have little real experience in application management, although I have managed some LAMP applications with SQL updates and diffing PHP. I thought I would keep the current base as PROD, make a back-up of it and assign that a DEV role and continue developing new stuff there. But how to migrate changes from DEV to PROD?Rgds,Björn

JeffJohnVolInspiring

Question about development vs production environments

I'm finally making great progress and haven't been frustrated enough to quit yet, so I think I'm going to be able to make this (along with fillout) to help support my makerspace.  I hope to eventually move from the free plan to Teams once I know I have all the major pieces in place.But once I do, and we're using it, I'm concerned that my future clugey attempts to add functionality might break operations.  Is there any concept of development, QA and production versions of a workspace?

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!

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

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?

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 :)

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

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!

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!

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?

BKRNew Participant

Other Questions

problème sur le type de champ "Nombre"

Bonjour,j'ai crée une table mais le champ type "Nombre" est absent de la liste des champs disponibles.. Avez-vous une explication?

sharmahrsh137New Participant

Other Questions

How to Migrate SharePoint Lists to Another Tenant?

Migrating SharePoint lists between tenants can be a challenging process, especially when dealing with large amounts of data or strict compliance standards. Whether it’s for mergers, acquisitions, or business restructuring, it’s important to have a clear and effective migration plan. While Microsoft’s SharePoint Migration Tool (SPMT) works for basic migrations, for more complex cases, using an automated tool like SharePoint Online Migrator is highly recommended to download. It offers features such as metadata retention, permission mapping, and incremental syncing, ensuring a smooth and secure transfer of your SharePoint lists with minimal downtime and data loss.

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