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,483 Topics
121,874 Replies
100,871 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

3218 topics

Formulas

5847 topics

Development & APIs

Development & APIs

3599 topics

Interface Designer

Interface Designer

1264 topics

Other Questions

Other Questions

14337 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

warandcoNew Participant

Formula help for display options for a field with multiple linked records

I’m exporting data to a pdf via Typeflow. One of the fields is a Link to multiple records, which happen to be street addresses. When I export the data to a pdf, the default view is to separate each linked record by a comma. I’m trying to create a line break instead of a comma. I created a formula field with SUBSTITUTE(Addresses,”,”,”\n), however the street addresses contain commas, so this didn’t work. Any ideas for another work around? Huge thanks in advance. Current format:Record 1, Record 2, Record 3 Desired format:Record 1Record 2Record 3etc

dchalkerNew Participant

Mentee/Mentor Matching

Hello, I help run a nonprofit that has a mentoring program where both mentors and mentees apply and then we make matches between them, and this is the first year we’re using Airtable to help power this.I have two tables within the same base: one for mentors, who have filled out a form and indicated topics that they are interested in mentoring, and then another for mentees, who filled out a different form and indicated topics they would like to be mentored on. Both “topics” fields have the same list that fills in a multiselect field.I have a junction table (“Match”) setup to be able to link mentor+mentee, but I’m running into a lot of difficulties automating the process.Ideally, here’s what I’d like:An automation that goes through every entry in the Mentor list, and then for each Mentor, adds every potential Mentee match to the junction table if any topic matches, and A field for each match in the junction table that tells us how many topics match, so for instance we can manually review

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!

Bart_S06New Participant

Other Questions

Status Code Error: 403

Hi guys, I'm trying to connect Airtable with Make. My Make.com module is returning "Status Code Error: 403" and I can't connect up my Airtable. I initially had it working and then created some new bases, so I generated a new Personal Access Token. Not working. Have tried different permissions. Logging out, logging in (I know). Etc.  Any suggestions?

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

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?

PerniNew Participant

Interface Designer

Airplane working OFFLINE

Hi all, we had developed a nice data base application, but sometime users have limited access to internet, I’m trying to work around this challenge, so one of the Ideas are: Question:Can the final users in the field download the Airtable application on their Tablets and work on the database offline since there is poor or no connectivity at the sites. Then, when they are back in the office can they sync it to the main cloud-based database Ideas: Download the portion of the DB into CSV to the local PC, then updates offline and then upload it back to the DB, however and afraid the users enter wrong information or get confused by the layout. Install or add an extension to the DB but I don’t know which could be to let the users work offline. I will appreciate your ideas and thoughts …

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!

Pjero_KusijanovKnown Participant

Resize and compress images

Hello 🙂I am creating a scenario in Make(Integromat) to resize images, and compress if they exceed 5MB in size.Bellow is the screenshot of the scenario I have created, but it is not working as expected.   I use HTTP to check the resized image size in MB  From here on, I am no longer sure what I did wrong, but Get multiple variables does not give me the resizes and compressed image. If the scenario received two images, one being resized and other compressed, I get two same compressed images.  I would really appreciate help.Thank you, Pjero 🙂

Florian_Verdon2Inspiring

Development & APIs

Base64 conversion

Hi everyone ! I am trying to authenticate a request using Basic Auth. I then need to base64-encode my logins. (could encode them manually and then insert but would prefer to keep that logic in the code) I didn’t found how to achieve this “natively” without rewriting the entire encoding function. btoa() does not seems to work :confused: Can anyone help me on this ? Thanks

dchalkerNew Participant

Mentee/Mentor Matching

Hello, I help run a nonprofit that has a mentoring program where both mentors and mentees apply and then we make matches between them, and this is the first year we’re using Airtable to help power this.I have two tables within the same base: one for mentors, who have filled out a form and indicated topics that they are interested in mentoring, and then another for mentees, who filled out a different form and indicated topics they would like to be mentored on. Both “topics” fields have the same list that fills in a multiselect field.I have a junction table (“Match”) setup to be able to link mentor+mentee, but I’m running into a lot of difficulties automating the process.Ideally, here’s what I’d like:An automation that goes through every entry in the Mentor list, and then for each Mentor, adds every potential Mentee match to the junction table if any topic matches, and A field for each match in the junction table that tells us how many topics match, so for instance we can manually review

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!

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

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?

PerniNew Participant

Interface Designer

Airplane working OFFLINE

Hi all, we had developed a nice data base application, but sometime users have limited access to internet, I’m trying to work around this challenge, so one of the Ideas are: Question:Can the final users in the field download the Airtable application on their Tablets and work on the database offline since there is poor or no connectivity at the sites. Then, when they are back in the office can they sync it to the main cloud-based database Ideas: Download the portion of the DB into CSV to the local PC, then updates offline and then upload it back to the DB, however and afraid the users enter wrong information or get confused by the layout. Install or add an extension to the DB but I don’t know which could be to let the users work offline. I will appreciate your ideas and thoughts …

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!

E_KKnown Participant

Check if date falls into a period

I am trying to solve the problem with dates validation.The prerequisites are:A date field to check A text string where days of the week AND times of the operation of an establishment are stored. This string might have a format of:H24 or DLY 1500-0530 or MON-FRI 0700-2300 SAT SUN 0800-2300 or MON 0415-1415 1900-2000 TUE THU 0600-1300 1830-1930 WED 1800-2000 FRI 0415-2000 SAT 1400-1600 SUN 0415-0730 1200-1415 1900-2000I need to check if the date in the date field falls into these periods of time and use the result TRUE/FALSE. Any idea on how to create a formula will be greatly appreciated. Thank you

AlexFNew Participant

Other Questions

Rollup only including first value and omitting the rest

I have a table where you can chose a proposal number and in another column you can add an amount. In another table (linked to the first one) I want to be able to chose a specific proposal number and sum all the amounts related to that specific proposal number. In the second table I have a rollup but it only includes the first amount associated to the proposal number. For example if a specific proposal has 4 entries (same proposal number but 4 different amounts on 4 rows) it only includes the first amount and omits the rest. Any thoughts on why this is? Thanks!

BenFortunatoKnown Participant

Dynamic filter not working on self-linking relationship

This might be a bug or I’m doing something wrong. I have a self-linking field in the object_types table called parent that establishes a child parent relationship between types. In my part_object table I lookup the part’s parent’s object_type. The desired behavoir is that any part that is a child of an assembly will only display object types that are a child of that assemblies object type. When I set this up I’m not getting anything. Either I’m missing something or there is a bug with dynamic filters for self-linking relationships. Anyone have any experience with dynamic filters for self-linking relationship fields?

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?

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