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

Forum Posts

Auto fill field based on cliend id

I have a 2 tables Events and clientsI have a form based on events table that clients submit their event requestsi want to when they open the form to have an id field based on clients table  that once they type (or choose from a drop down list) All th...

laks by 4 - Data Explorer
  • 242 Views
  • 1 replies
  • 2 kudos

Tracking a single task for multiple units

Hello, I'm using Airtable to project manage a fabrication project where multiple units will be built throughout the year. One scenario I would like to track is when there is a single task that needs to be done for each unit, but only when that unit i...

Datetime format for an upload

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to...

Resolved! 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
Solved
  • 720 Views
  • 2 replies
  • 1 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
Solved
  • 1813 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
  • 219 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 7 - App Architect
Solved
  • 425 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
  • 357 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
  • 2333 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
  • 2568 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
  • 764 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
  • 463 Views
  • 1 replies
  • 0 kudos