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

Forum Posts

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 1 - Visitor
  • 10 Views
  • 1 replies
  • 0 kudos

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
  • 10 Views
  • 0 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
  • 45 Views
  • 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
  • 41 Views
  • 1 replies
  • 0 kudos

Looking for someone to create a Sales KPI Dashboard

Hello  Here's a Loom of our vision / needhttps://www.loom.com/share/9aab3ac7462e4340bf67314b63289bd3 If this is a project you'd be interested in, please email go@beyondthepeak.co 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
Solved
  • 109 Views
  • 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
Solved
  • 353 Views
  • 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...

Assistance with conditional logic needed to set field values

Hi AT communityI once again appeal to you for assistance, please.We are a performing arts company who provide entertainment for events. An event can book one or more performances which can be of the same type or different types. These types are impor...

nefiger by 6 - Interface Innovator
  • 244 Views
  • 3 replies
  • 0 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...

Margaret_Picker_0-1675072496010.png

Resolved! Count number of expenses by month

Hi!I have a table with freelancers, I have another with expenses associated (payment info & dates that went to each freelancer). What I am trying to do is pull all expenses linked to each freelancer by month. So I have columns labeled with the months...

Multiple Variables Record Linking

Hello community!I have a base I created to manage all tasks across multiple real estate development projects (>700 task records per project). There is a table that holds the Master template of all tasks required for each project, they’re linked to a ...