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

Forum Posts

Form fillout linked to two tables (SalesOrder, SalesOrderLines)

Hi, I am a new user of Airtable. I'm creating a new Sales Base for a carpet company.  I have two tables, Sales Orders and Sales Order Lines, which are linked one to many. I want to create a Form, Enter the Sales order information, and then be able to...

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

Suggested base/table design when each step has unique sub-steps

I'm creating a workflow/process tracker using Airtable. I have the following tables:WorkflowsStepsWorkflow RunsStep RunsThe Workflows table contains a list of workflow names, e.g. "New client onboarding workflow".The Steps table contains all the step...

ebbpum by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Add 'This Year' and 'This Month' to a view's filter

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems...

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

Workout Log Develop

I am trying to build a functioning workout log for this new workout plan I am planning to start.  I want to be able to create it on interface designer and be able to update it on my phone as I am in the gym.The workout is divided into 12 weeks with 4...

Drew_Nemer_0-1697824239493.png Drew_Nemer_1-1697824260107.png Drew_Nemer_2-1697824475398.png
Drew_Nemer by 7 - App Architect
  • 0 replies
  • 0 kudos

When to separate Squads and Teams into their own Tables

Hi there! I have a bit of a math problem I'm looking to solve:I manage a Department with about 85 Software Designers, which are assembled into 15 Squads, which support 3 different categories of software products. And about 1/3 of the work they do is ...

Why low res thumbnail with Google Drive sync?

I want to sync PDF files via Google Drive however this method renders a low res PDF and the important copy that I need the reviewer to approve is not readable.Is there a way to stop this or is loading the attachments manually the only option?Thanks!

kdburns by 6 - Interface Innovator
  • 1 replies
  • 0 kudos

calender across multiple projects

HelloMy company builds complex machines with many parts. A lot of these parts, I need to buy and keep track of delivery dates and whether or not the item has been deliverd.What is the best way to set up an airtable to show all the delivery dates for ...

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

Organising data

Hi there,To use data for a list Softr you have to have the data in the same column. How would I be able to put two look up fields (one displaying a percentage and the other displaying a $ amount) into the same column while maintaining their exact val...

bartdubs by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Can Airtable solve this situation?

Here's the situation. I need a base with 4 tables. Each table has inventory for 4 different types of products. Data for each record includes descriptors including single and multi-selects, text and most importantly the # available. The inventory mana...

Select Related Record Menu Options

When I go to choose a related record, I see the name of that record.Under it I see several other columns that provide more information, some of which are redundant to the record name. Is there a way to customize this to select the fields underneath (...

bcirce by 4 - Data Explorer
  • 5 replies
  • 0 kudos

Resolved! Syncing various bases to one with selected criteria

We are working with different clients on different Airtable bases. Also internally not everyone is working on every base. We do not want to change this (and include all client data in one base) also for security reasons.But for Management I am trying...

Helenelene by 6 - Interface Innovator
  • 3 replies
  • 2 kudos

Resolved! Point Tracking and Redemption

I run a volunteer program where we reward our volunteers with comp tickets to our events.   We currently use a points based tracking system where they get 10 points for every hour volunteered.   I was wondering if there was a way to create something ...

lterrazas by 4 - Data Explorer
  • 4 replies
  • 2 kudos

Line Items

Can anyone recommend a way to close or lock a record with linked Line Items when needed? We have a table to create Purchase Orders and within the record, Line Items can be created.  These Line Items contain the actual purchase details such as qty/hou...

Rita_Spanu by 5 - Automation Enthusiast
  • 4 replies
  • 0 kudos

Resolved! Adding a Date

So, I'm trying to add a day to the columns, but I need it to add exponentially... if you know what I mean.  It would be nice if we could click and drag like in sheets with this stuff.