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

Forum Posts

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
Solved
  • 429 Views
  • 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
  • 48 Views
  • 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
Solved
  • 80 Views
  • 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
  • 150 Views
  • 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
Solved
  • 1631 Views
  • 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
Solved
  • 1262 Views
  • 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
  • 477 Views
  • 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
  • 171 Views
  • 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: https://airtable.com/appKiBFGhHOgFeXf2/shrrTAISY39Rx8mL5)We 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
  • 164 Views
  • 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
Solved
  • 267 Views
  • 2 replies
  • 1 kudos

Assign a value to first linked record only

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the...

artichokejoe_0-1696237373572.png artichokejoe_1-1696237431877.png

Resolved! Bulk Editing Records

Hey Guys! Hoping everyone is well. I'm finding myself wanting to bulk-update records by a specific field and I'm wondering if this is possible? Does anyone know? Is there a script or anything? See the two fields? "Goes out to" and "Status"? Both are ...

Screenshot 2023-09-29 171423.png
folklore by 5 - Automation Enthusiast
Solved
  • 588 Views
  • 5 replies
  • 3 kudos