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 ...
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...
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...
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...
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...
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...
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...
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...
My plant names table has these three fields: Taxon Name, Name Status, Accepted Name, and Synonyms. Here's the table: https://airtable.com/shrHB9evyZmBawj0CTaxon Name is for all possible plant names. Some of these are "accepted names", meaning they ar...
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...
Hello! I am currently at a standstill. To make my long story short... I have a database that keeps track of vehicles and equipment. This included Maintenace records, mileage, locations, etc. (Keep in mind I am not the only one who uses it) Because I...
Hello there,I have a base where we are taking job hours and rolling up all the hours into monthly payroll. I attached screenshots of the sample base.Basically, I am trying to create an animation where if {Payroll Link} is empty, then copy and paste ...
Complete newbie here so go easy. Table_A contains 2 fields: 'Name' and 'Status' (Active or Expired)How can I automatically pull all 'Names' with only status 'Active' into a field in Table_B?I want it so that any changes made to the 'Status' in Table_...
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...
New'ish to Airtable and feel like I'm running into a super'noob question and just missing something. The point of my base is to share resources across a team, though not every resource to every user.In my base I have a Resources table, and a Users ta...
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...
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...
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...
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...
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 ...
