Base Design
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Creating an Address Book / Comm Log without Duplicates

My company has thousands of different contacts that we want to make a communication log for. The idea is two linked tables, an address book and a communication log. The issue is I don’t know a smooth and quick method to add new communications to the ...

Using QR codes to streamline concert check-in process

Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attend...

AndrewGreen by 5 - Automation Enthusiast
  • 5 replies
  • 0 kudos

Struggling to build the correct base

I have been using airtable for a few weeks now and I am struggling to build the correct base that allows all of my data to link correctly.I am coach of a sporting team.  There is roughly 50 people on the team.I have created a base for the playersProb...

ritzy43 by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Totaling multiple fields based on month

Hey Airtable community,My service business has multiple income streams, ranging from one-time to ongoing projects.I am attempting to create a table that can total both one-time revenue and requiring revenue for the month that income comes in. I am ha...

Dbucks by 4 - Data Explorer
  • 2 replies
  • 1 kudos

Forecasting for monthly targets vs YTD vs Annual

Hi all,I think I'm close, but I just can't workout how to get the forecasting base I'm building to show Monthly sales vs Monthly Forecasts when I want to track them across an additional split out by stream.I have this Monthly table linked to the proj...

Darcie_Tanner1_0-1676901164549.png Darcie_Tanner1_2-1676902034228.png

Custom linked record View when adding new linked record.

I have two tables (Table A and Table B) linked to a common table (Table C).When adding a new linked Table C record from Table A or B:I want Table A to use View 1 from Table C.I want Table B to use View 2 from Table C.View 1 and View 2 have two differ...

Enlil_Ragas by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Resolved! Calendar View - Single Day Events

Hello!I'm attempting to optimize my Calendar view, and I'm running into an issue.I have a table with tasks that fall in three categories:Multiple Days (Start and End dates are different)Single Day (Start and End date are the same)Deadline/Milestone (...

AnitaHallberg by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

Multiple projects view

Hi! We are a small visual artist company. We work on several projects at a time, repeating tasks on different projects, like on animation video production. We don´t know wether we need to create one base with all our projects, with a table for projec...

Resolved! Airtable Forms, is a Dynamic/Conditional input field possible?

Hi,As the subject line states, I am looking for a function within airtable forms that can allow me to change the available inputs based on the condition of a previous answer.The purpose of this, is to submit an attendance form of such.I am using a ta...

DennisTSS by 4 - Data Explorer
  • 3 replies
  • 2 kudos

Database structure design

Hi !Our company is working with Airtable for almost a year now, and I believe it can provide everything we need from a CRM / Dashboarding tool. But as our company grows, our Airtable base also is…  and we’re at the point of needing to evaluate the da...

Christi by 4 - Data Explorer
  • 2 replies
  • 0 kudos

One to Many to One

Hi there,I work in the film industry and am trying to create a base to help me track my work.I make graphics for sets.  A graphics might be something that hangs on the wall in a set, so it would be in every scene that's shot on that set.  Or it might...

Eric_Bryant1 by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Resolved! Organizing Bases

Hi, I'm new to Airtable and I'm setting up Bases for a company with multiple teams (marketing, sales, project management, asset management & finance). When I set up Bases, is it best to set up separate Bases for each team or to have one Base with mul...

MRC by 5 - Automation Enthusiast
  • 3 replies
  • 5 kudos

Resolved! How to avoid having to edit URLs when I copy a base.

Hi,We have three main tables.  Client table records have one or many Interaction Table records, which have one or many Outcome records.To make the process smooth for collaborators and to reduce errors, I have a button on the Client record which launc...


Resolved! Redesigning bases and workspaces....

I am a newish user on a pro plan and in the 5 months i've been using Airtable i not only learned a lot but definitely have learned how to make more complicated tables and ways that our organization can use it. However, now that more of our operations...

Limi by 5 - Automation Enthusiast
  • 4 replies
  • 0 kudos