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

Forum Posts

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...

S-G by 4 - Data Explorer
Solved
  • 146 Views
  • 7 replies
  • 2 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)....

BetsyA by 4 - Data Explorer
  • 122 Views
  • 6 replies
  • 1 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...

jowan_qupty by 6 - Interface Innovator
  • 101 Views
  • 4 replies
  • 2 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

Sort in Rollup field results

Hey amazing people I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is...

Shannon_Bradley_0-1692677780365.png Shannon_Bradley_1-1692677816434.png

Weekly Business Health Check - Form, Data, Dashboard - How to do it?

Hi,  I'd like to create a "Business Health Check" Dashboard, and I'm thinking Airtable might be a good way to do it,  but as a new user I'm not sure how to start. Basics:1. Dashboard view:   Show changes to each category over the past few months (lin...

TonyD by 4 - Data Explorer
  • 113 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...

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...

scbates by 4 - Data Explorer
  • 83 Views
  • 1 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...

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...

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...

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...

Resolved! Linked Tables Lookup

Been a long time since I've used Air Table. Having trouble recalling how Linked Tables work.I have two tables, one Table is a list of all checks with primary field being a check number. This is a list of EVERY check related to a bank account.I have a...

stevenjo57 by 4 - Data Explorer
Solved
  • 243 Views
  • 2 replies
  • 2 kudos