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

Base Design Activity

Select multiple records at once in a linked records field

I'm working on tracking progress for multiple offices and their checklists. Currently, I have two tables - 1 with the Checklist and 2 with the Progress Report. The Progress Report is setup where the first column is the office name and the linked reco...

  • 32 Views
  • 1 replies
  • 0 kudos

Connecting multiple fields between two bases

I'm a new enough user that I don't really know if this is a Base Design, Automation, Sync, or Formula question - apologies.I use Airtable to manage a golf travel business and I have one Base that is a client list with 2 Tables (Names and Past Trips)....

  • 122 Views
  • 6 replies
  • 0 kudos

Help with Dynamic filtering in linked record fields

Hey everyone,Really excited about the new dynamic filtering feature that was just released. I’m trying to implement it on one of my bases but I’ve hit a bit of a snag trying to make it work in my use case.Here’s the deal: I’m with a company that hand...

  • 101 Views
  • 4 replies
  • 0 kudos

Sort Roll-up List of Simple Values

This is a basic hack to sort a simple list of pre-determined roll-up values (e.g. 12 months) without a script or 3rd party automation.In the example below, month values from the Sub-items table are rolled up in Items table / Unsorted column.  Columns...

Screenshot 2024-03-15 at 5.18.01 PM.png
  • 110 Views
  • 3 replies
  • 1 kudos

Resolved! I want to roll up only the n-th of the linked record

Hi,I have a table named "Customer" whose field is "Address"I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is...

  • 84 Views
  • 2 replies
  • 0 kudos

dynamic filtering option not appearing in a particular base

I have two existing bases in the same workspace on a Team plan. The new dynamic filter option appears in one of the bases as an option for new and existing linked record columns. It does not appear as an option in the other base, either on existing l...

  • 151 Views
  • 4 replies
  • 1 kudos

Resolved! Kit Inventory Management with parent and child components

Hi, just trying to get some advise on how to start creating an inventory managements base on airtable. We provide kits with have their own unique indentfying number - and each kit contains devices which we record the serial numbers of - they belong t...

  • 146 Views
  • 7 replies
  • 0 kudos
S-G by 4 - Data Explorer
Solved

Employee/Job Assignment

We assign employees (N=65) to Job Type (N=5) and Job Title (N=many) every six months.Before we begin, we know the employees and the job titles.There are two phases: assignments and distribution.Assignment:I assign individual employees to individual j...

  • 83 Views
  • 1 replies
  • 0 kudos

Resolved! VLOOKUP style matching

Hey guys, Really new to Airtable and not an excel expert either. I have been trying to create a Master Catalog / Master SKU table which contains fields like SKU variations, Amazon ASIN, Category, sub-categories, landed costs etc. I have also assigned...

  • 71 Views
  • 1 replies
  • 0 kudos

Field Permissions

I have a table that was transferred to me over a year ago and now I am the owner. I recently upgraded to the Team plan. I can input data into the template but now matter how I change my field permissions, when I try to delete a row is says: "this tab...

  • 76 Views
  • 1 replies
  • 0 kudos

Resolved! "Edited by pasting"

I developed a table that looks up records from other tables in a base. My colleagues all say that they have never touched this table, yet revision history of multiple records in the Linked column say that they were "edited by pasting." I have searche...

  • 72 Views
  • 1 replies
  • 0 kudos

Kanban View Based On # of Weeks Enrolled In Program

I currently have a formula running for # of weeks someone has been enrolled in the program.  Is there a way to have a Kanban view with 52 columns (1 for each week of the year) and have the clients auto populate in those columns based on # of weeks en...

  • 66 Views
  • 1 replies
  • 0 kudos

Monthly Totals Table

Hello - I'm trying to create a table with my KPIs that combines 'campaigns' and 'clients' into a monthly view that sums up the total of all the campaign KPIs for that month separated by clients.I've recorded a Loom that hopefully gives the needed con...

  • 91 Views
  • 2 replies
  • 0 kudos