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,491 Topics
121,902 Replies
100,883 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

4999 topics

Base Design

3220 topics

Formulas

5848 topics

Development & APIs

Development & APIs

3599 topics

Interface Designer

Interface Designer

1264 topics

Other Questions

Other Questions

14340 topics

Builders Board

Builders Board

Show and Tell

994 topics

Product Discussions

Product Discussions

2 topics

Jobs Board

997 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

sean_hrtnNew Participant

Unique Quantities For SKUs in PO Tracker

The problem: Our manufacturer will ship the contents of a Purchase Order as they are made and ship the remaining products when completed. We have had several occurrences of not knowing what’s coming and what is left until it arrives and we open the box. (We have a middle man, there is no direct comms with the supplier). My goal: Build an interface that the manufacturer can open, select the PO number, and input how much of each SKU is in the upcoming shipment, and put in the tracking number. Where I’m at: I have a Master Products Base with all of my SKUs in one table, and purchase orders in another table. I can add my skus from the products table into each PO, but I can’t assign each sku an order qty within the PO record.The other nuanced issue is that sometimes PO’s overlap and we will have the same SKUs on multiple POs. I want to be able to assign different order quantities to each SKU in a PO, and keep track of how many have been shipped from each PO.

cls404New Participant

Reformatting Titles

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

Farrukh SheikhNew Participant

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?

MagPageNew Participant

Prefill a field and lock the content

AT community, Yes I have searched and used AI and I’m not getting a good answer on this question. I have a pre-filled form to advertisers. I want some of the prefilled fields to be locked so that the content cannot be change. Has anyone found a workaround for this and be willing to share step by step on how to do it. I’m very new to AT and want to learn!Thank you!

DjuwNew Participant

Call Center Traveloka

Hubungi Call Center Traveloka 0897-777-7764

K_B1Known Participant

Scripting: Convert Attached .TXT file to Long Text

Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed?We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed?I have see some notes on it, but we need scripting help to achieve it.Thanks for any advice.Kevin

TheTimeSavingCoBrainy

Custom colors for field / column headers!

I wrote a Tampermonkey script to allow us to customize the colors of the field headers!(Tampermonkey lets you install scripts in your browser to customize and add functionality to a site, in this case, Airtable! https://www.tampermonkey.net/)To use it, you'll need to set up the exact field IDs and colors that you want those fields to be in this bit: const colorMap = { "fldI5EIoOG25a85F7": { r: 255, g: 224, b: 204 }, "fldxj4ka7M2FwkJAP": { r: 207, g: 245, b: 209 }, "fldAPHkUW98PsaZV3": { r: 255, g: 234, b: 182 } };  For the colors, just google 'Color Picker' and a bunch of options will show up (when I did this Google actually popped up its own Color Picker actually)For the field IDs, right click the field header and click 'Copy URL' and then paste it somewhere, and it'll look something like this: https://airtable.com/appbvEVTtJoARHXPM/tblkT2pj3Ouz1wQRQ/viwKoIZQGVZEAfOap/fldI5EIoOG25a85F7That last bit is what we're looking for 'fldI5EIoOG25a85F7'---Let me know

PeteFordNew Participant

How do I compare dates to return the lowest?

Can anyone tell me how I would write a formula that will return the lowest date from a series of dates? this would be very simple in excel, but it seems impossible

Nick_RobinsNew Participant

Automation of assigning tasks to users in airtable when records are created in softr via API

I’ve just started some work as a freelancer for a company who have an eco system where airtable is the referencing hub for projects. Softr is used to create records linked to projects and the API pushes through the records to sit in Airtable. I’m searching for a way to create workflows easily:Generate automations whereby records that are imported from Softr to Airtable are automatically assigned to people in user groups on a sequential basis to spread workload Create a dashboard on progress for each user and user group to track progress.NB- this is entirely project based and therefore each step must be complete before progression. Thanks alot in advance for your input and advice!

maugeriNew Participant

Interface Designer

Prefilling a Field in Form Builder?

I am new to Airtable and created my first form a few days ago using the new Form Builder interface. After the fact, I realized there was a field I hadn't included that I'd like to prefill. I read through all the various instructions on prefilling by altering the URL - all makes sense to me - but I can't figure or WHERE to do the URL edit in the Form Builder interface? I can copy the form URL to the clipboard, but WHERE to I put it where the alteration to the URL will be pulished and saved?Any guidance would be greatly appreciated. Thanks!

sean_hrtnNew Participant

Unique Quantities For SKUs in PO Tracker

The problem: Our manufacturer will ship the contents of a Purchase Order as they are made and ship the remaining products when completed. We have had several occurrences of not knowing what’s coming and what is left until it arrives and we open the box. (We have a middle man, there is no direct comms with the supplier). My goal: Build an interface that the manufacturer can open, select the PO number, and input how much of each SKU is in the upcoming shipment, and put in the tracking number. Where I’m at: I have a Master Products Base with all of my SKUs in one table, and purchase orders in another table. I can add my skus from the products table into each PO, but I can’t assign each sku an order qty within the PO record.The other nuanced issue is that sometimes PO’s overlap and we will have the same SKUs on multiple POs. I want to be able to assign different order quantities to each SKU in a PO, and keep track of how many have been shipped from each PO.

cls404New Participant

Reformatting Titles

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

Farrukh SheikhNew Participant

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?

MagPageNew Participant

Prefill a field and lock the content

AT community, Yes I have searched and used AI and I’m not getting a good answer on this question. I have a pre-filled form to advertisers. I want some of the prefilled fields to be locked so that the content cannot be change. Has anyone found a workaround for this and be willing to share step by step on how to do it. I’m very new to AT and want to learn!Thank you!

DjuwNew Participant

Call Center Traveloka

Hubungi Call Center Traveloka 0897-777-7764

K_B1Known Participant

Scripting: Convert Attached .TXT file to Long Text

Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed?We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed?I have see some notes on it, but we need scripting help to achieve it.Thanks for any advice.Kevin

PeteFordNew Participant

How do I compare dates to return the lowest?

Can anyone tell me how I would write a formula that will return the lowest date from a series of dates? this would be very simple in excel, but it seems impossible

Nick_RobinsNew Participant

Automation of assigning tasks to users in airtable when records are created in softr via API

I’ve just started some work as a freelancer for a company who have an eco system where airtable is the referencing hub for projects. Softr is used to create records linked to projects and the API pushes through the records to sit in Airtable. I’m searching for a way to create workflows easily:Generate automations whereby records that are imported from Softr to Airtable are automatically assigned to people in user groups on a sequential basis to spread workload Create a dashboard on progress for each user and user group to track progress.NB- this is entirely project based and therefore each step must be complete before progression. Thanks alot in advance for your input and advice!

Farrukh SheikhNew Participant

Other Questions

Sales CRM template. Not able to see the account (potential customer) in Interactions

Hey AT community. I downloaded the “Sales CRM” template and created an account (a potential customer), but I am not able to see it in Interactions, so I cannot add any interactions. https://airtable.com/appIirQcIOaiJSq0w/tblpZMgRZq8MVJaGi/viwSC4OGJxNSvEex2?blocks=hide. The account I have added is SunRise, if you are able to see it in the link I have provided. Can you please help with this? Thanks.

jonathanshanksNew Participant

Interface Designer

How to add a table to an interface

Hi everyone!I have created an interface to keep me organized, and one thing I would like to add is a table that would function like the data side, just within the Interface. For my specific example, I have various groups I invite to events, and it would be helpful to have a table with the group name, group contact, and then a checkbox for when I’ve contacted them. My interface is a “Record Review” interface.Does anyone know how I can achieve this? Any help is appreciated!

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