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

Forum Posts

struggling to combine tables and create a summary

My goal is to combine 2 data tables into one, and then get a single output sum value for each "agent" within the respective table. Right now, when I combine the tables and syncing, I am getting limited or no data to transfer across. The goal would be...

Screenshot 2023-03-30 at 6.49.28 PM.png Screenshot 2023-03-30 at 6.49.39 PM.png

Resolved! Use one field to calculate another and vice-versa?

We're using a base to track actual work done on multi-project invoices, but the invoices from different vendors format the info differently - some tell us a percentage of the time worked spent on each project, while others tell us $ amount subtotals ...

How to automatically fill in empty rows

Hi all,For a table as shown above, where only field "item nu" and "Scale" have distinct values for each row while other fields share the same information, how can I automatically fill in the other fields with the common information as shown below? I ...

raeno19_0-1680014945448.png raeno19_1-1680015092879.png
raeno19 by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! linking 3 tables

I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. whe...

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

Primary Field Allowing Non-Unique Entries

Hello, I'm working on a new database and one of my tables includes various types of barcoding equipment.  Each record should have its own unique Serial Number, so I made Serial Number my Primary Field for that table.  I thought that, by default, the ...

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

API: Filter formula when you have a linked ID

I have a table I need to search through and pull records from.That table has a column that is linked to another table.  I have that link ID.  It's set to a single link (not multiple items).Here's the item from a list that I have retrieved.  I have th...

Jed_Davidow by 6 - Interface Innovator
  • 2 replies
  • 0 kudos

Reverse of Linked records?

I have a CAMPAIGN tab where each record is a Campaign. For Example: May, June, July. Each record has a Channel field. that i populate from a linked tab called Channel Type)For example one record is: May marketing campaign and the channel field then l...

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

Looking for someone to create a Sales KPI Dashboard

Hello  Here's a Loom of our vision / need If this is a project you'd be interested in, please email with the Subject line: I'd like to make your Epic AirTable KPI Dashboar...

Resolved! Count to create a unique record ID

Hi all...I'm sure this has been asked before so apologies for asking again. I have searched but any article I think might give me the guidance I need ends up getting confusing...possibly due to my lack of understanding but I think at this stage, my b...

Ar_Ad 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

Linking tables - formula and automation

HiI have two tables - Registration and BookingsBoth tables relate to the same customers.Customers submit their Registration forms and they are updated at least annually. There is an automation that links new or updated Registration records to another...

Resolved! How assign a number to a single selection value

Hello everyone,I am new to airtable. I have a survey and each question has a single select field option for the answers with a certain amount of points. How can I assign a number to each single select field value e.g. a=0, b=1, c=2 and d=3 so I can a...

Jerrel by 4 - Data Explorer
  • 7 replies
  • 0 kudos

How do view all assigned tasks from multiple bases?

Hello,our company has been playing around with airtable for our project management and tasks management. Our company runs marketing and branding for multiple brands. So we have created 1 base for each of the brands. In each base, we have multiple mar...

help with database structure

working on developing a better crop plan. each year, i have spreadsheets and my planting and harvest information never gets added so i'm trying to make a better workflow. REF reference file where most of the basic data about each crop goes. when it's...