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 ...
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...
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 - ...
Hi y'all,So, I have a store on shopify were i sell products in stock and products that are on preorder. The variants in stock are defined by the word "EXPRESS" and a metafield in them, the rest of them don't have it. I'm using the AirPower template t...
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...
I'm trying to create an inventory management base. I have two products that use several parts to make. I want to be able to enter the quantity when I buy the parts, and then when I manufacture, have those numbers subtracted from the quantity of each ...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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, ...
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...
How do I have a formula based on 2 different multi-select fields, that will add a specified number to the resulting formula, based on how many options were selected for each multi-select field?Remember that each multi-select will be adding on differe...
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...
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 ...
