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

Forum Posts

Time changes date

Hi all!Here's a question... I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.Values in {Due Date} look l...

ARiios by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

Resolved! Line Item Support Help

Hello!This is my first post, so I hope I'm posting in the right place.I am trying to use Airtable as a production board for my company. When an order comes through Shopify, I have Zapier tell it to upload the information with Line Items, but my team ...

ebefort_DDP by 5 - Automation Enthusiast
  • 6 replies
  • 2 kudos

Campaign Stage Duration Tracking

Hello, I am a newbie to building out AirTable bases and am mainly working off of AirTable's Marketing Campaign Tracker base to make my life easier as my new team gets more and more campaigns in various stages.AirTable's Gantt view with field dependen...

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

Resolved! Copy Attachments from one table to another

I have two tables: Table 1 with companies and their data and table 2 which is synced from box that has the details on company logos as png images for each company. I have managed to use airtable sync to pull in the logo images from box to airtable - ...

cshenoy86 by 6 - Interface Innovator
  • 2 replies
  • 0 kudos

Tradeshow Schedule and Deliverables Base Design?

I am looking to build a base for Tradeshow scheduling, deliverables, budget, attendance, and post show statistics. For context we are a manufacturer who attends other tradeshows with a booth and a set of products. My role is to make sure the marketin...

Summary / roll-up by two dynamic conditions

Hi everyone - I feel like there should be an easy, elegant solution to this challenge, but I can't figure it out nor find a similar solution that applies and it is driving me nuts.I have a personal expense transactions table with some basic fields: d...

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

Another VLookup question (no solutions working)

I have spent conservatively 3 hours reading posts and watching videos on linking records, lookup fields, etc. It seems that an enormous number of Airtable users are facing something similar - the need to automatically relate to tables but pulling dat...

Extracting information from Table and performing equations

Hello All, I'm somewhat stuck when it comes to transitioning to Airtable, so any help would be appreciated. I have a Table, called {Pricing} and another called {Quote}. My intention is to extract multiple entities from {Pricing}, perform conditional ...

Resolved! Dependent Single Select Lists

I'm trying to do this exact functionality from excel, within airtable: Dependent Drop Down Lists Essentially, the single field drop down list will update depending upon the input to another field, as seen below Fruit & Vegetable have two different li...

sal_3-1680879544623.png sal_2-1680879529938.png
sal by 5 - Automation Enthusiast
  • 7 replies
  • 1 kudos

Resolved! Avoiding duplicate values in lookup fields

Hello'I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.Based on the customer interested events...

Sri1 by 5 - Automation Enthusiast
  • 3 replies
  • 1 kudos

Base Design Help

I have been using Airtable for a little while and can get the basics of what I need.  However, I'm now getting much more complex with multiple bases linked together and I'm having a hard time figuring out the best way to link my tables together.   In...

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

How to map out product components from SKUs and bundles?

Ok, I'm trying to build a product catalog and inventory management Airtable. I'm trying to work out the basic structure before I get too deep into adding all of my stuff.We have components, with a Part #, which are sometimes sold on their own as a SK...

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

Rolling up a numerical lookup with MAX

Hi all! Here's what we're trying to do, and what we tried that isn't working:What we're trying to do: (example table: run an exam, and have two tables:test_takers - each person who is taking...

Resolved! Range between two dates

Hi everyone,I have a start and end date field in one of my tables and I am trying to find a way to get airtable to tag each month within the range. Essentially I want to know how many were active between 8/30/2019 and 7/31/2020. I haven't been able t...

Volunteer database

Hi there!  We're setting up a volunteer shift database for a large festival. I assume we can let volunteers sign up for shifts using forms, but is there a way for them to change/drop shifts without having to email us to do it on the backend? If not, ...

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

Resolved! How to use Rollup on a lookup field

Hi (newbie here),Can you do a rollup on a Lookup field in a different grid?I have a table of employees.  There is a table of Trips where we look up the employees from the employee table.  Then I have a Departures Table that pulls in the Employee info...

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