Builders Board

We are setting up AirTable to help track and approve Invoices on behalf of our clients. We are looking for help to build some checks into AirTable (or via Zapier or other) to make sure the invoice fits into the clients budget and that the client has approved the invoice before we export it to Xero. We will also need to get the client’s approval of the invoice and plan to use SMS for this. We have some of the database already built and some connections working using Zapier. We’re looking for someone familiar with AirTable and api’s. Some basic programming experience is essential. Would you please get in touch and explain your experience in automating checks and workflow with Airtable and possibly Zapier. thanks Elisa

I am currently setting up a job production system to have orders from our accounting system flow into Airtable and manage our manufacturing jobs. 70% of our jobs are pretty straight forward and have the same parts for each job and Airtable is looking like an EXCELLENT tool to assist us in what we do. About 30% of our jobs are much more complicating and have kitted parts, with assemblies inside of job methods which throws off my simplistic vision for this system and I’d like to stick to the vision as close as possible. I need an Airtable consultant that I would pay for the project of helping me design for this 30% of complicated scenarios. Airtable expert and database mind required! Please message me if you have interest!

Hi AirTable Users! AirTable is a fantastic tool that can be used in so many different ways, just like any out-of-the-shelf-spreadsheet-toosl, but easy, and in even more ways, especially when you are online! So for all BI developers out there, targeting all Qlik Sense Developers - I have find a way to integrate AirTable with Qlik Sense - I¨m sure it is possible to do also with other BI tools…such as Power BI and Tableau, as long as they are web-based. Example. Inside the Qlik Sense App in a simple Widget, you can embed a AirTable Form, allowing Qlik Sense Users to give feedback into an AirTable database. Then, you can load this feedback back into the Sense application presenting the overall feedback. The complete concept without ant coding or paid licenses! Amazing! The solution can also be used for Budget-processing, or any kind of solution where a Qlik user must be able to give back Data for further processing. Link to part 1 of 3 on my blog post on how to do this. //Robert

Hi everyone, What a lovely product airtable is! I’m looking for a help with my school and inventory airtable DB. I have some logical issues that I can’t solve on my own. Few examples: how to record biweekly attendance of 300+ students for 10+ different classes better payment records then current create inventory management and… create automated inventory management (if someone takes something, that item should decrease in my stock) add complex logic based formulas to fields review overall setup, and work to improve flow & efficiency We can do this with upwork, skype or something else, whatever work well with you. Feel free to email me at: davorbudimir9@gmail.com Who is ready to take on a challenge? :smiling_face_with_sunglasses: :blush:

I’m trying to create a few tables that would allow me to keep some information hidden from a client, while still allowing them to collaborate as fully as possible. Am looking to pay someone for a few hours work to make this happen…don’t anticipate it will be too complicated but it’s just more than I can figure out. Happy to chat more about the details if you’re interested. Owen

Hi All, I wonder if you might be able to please help me, I am trying to create a formula to sum amounts based on the status of a persons deal (think sales pipeline for lines of business). I’m trying to Sum a series of If statements (I think!) As you can see from this example, there are 3 types of incomes, and each person/customer might be Open or Closed under each line of business. So what I am trying to do is Sum all income types If the status is Open (I.e. to create a Total amount for Open deals). In this example Person 1 is only income type A and Open, so the desired outcome is to produce a $1,000 result. Person 2 has income in 2 lines of business, but 1 is closed, so I want it to only sum the Open one, again $1,000. But person 3 has income from lines of business A and C, and both are Open, so I want it to have a $2,000 sum. I have tried with If, Sum and Or statements, but I just have no idea what the logic is I’m supposed to use for what may be fairly straight forward for an e

I am looking for a contractor to help with the Blockspring Script feature of Airtable. I am looking to write scripts to import data into my project, in part via API and potentially with some web scraping. If interested please email me at rkaplan@kaplan.rehab – Richard Kaplan

building out a database for our art gallery, integrating some data, and creating some reporting. Nothing overly complex in what we need - I’m just struggling to connect databases/tables into single views and reports. We’ll probably need to start with some analysis since I’m still trying to wrap my head around the amount of data I want to capture and how much needs to be integrated. Thank you Karen

Hello! I’m looking to get some support building out my Airtable to monitor capacity for my boutique PR agency. I know what I want it to do, I just need someone to help build it for me pretty quickly. I’m available to speak with someone as early as today. Taylor Ray Orsbon

We are film & TV distribution company. We are looking to build a database of film and TV titles in to a rights management database and layer in features from airtable that could assist with workflow. The ideal candidate will be both a consultant and ‘doer’, with database experience an knows airtables inside and out. if there is a way to incorporate our database in to our web site so people could also view our films/library that would be great. Please send CV and references to: info@syndicado.com and let me know what platforms you work out of. Thanks,

Hello, I need a database for my small business, currently I use an excel file and a word document for everything from inventory to pricing to producing print documents. It needs to have a really simple UI as my business partner is not computer savvy and uses the iPhone for everything. The company is a gift basket business so you can imaging many component items going into a few main products for sale - and every product for sale gets a printed sheet with the contents. Tasks or outcomes I’m looking at. -Inventory - receiving. # of items, landed price paid, lot # expiration date etc. -Inventory Alerts - stock alerts 45 and 15 days to sell by date -Inventory tracking - parent gift basket is sold and all child / component items are reduced in the inventory. This needs confirmation and editing as items are added or subtracted to each sale. -Pricing out items for sale - using the inventory to add products together and save as an item sold. Once saved and confirmed the inventory would update

I’ve had a play with Airtable but due to my time constraints I would rather brief someone with experience of building a dashboard. I’m looking for someone who can build a dashboard for us within the next 10 days. I can create a brief but I’d also appreciate some thoughts / feedback to help us create the best dashboard for our needs / based on our workflows If you are interested, email me. I can then send you a brief with our workflows and requirements. sarah.marshall@condenastint.com

Hi there, We run a home staging company and use airtable to log and track our staging inventory. We love it BUT We need to simplify our internal workflow and are in need of the following capabilities not currently offered: We need an easy way to sync Airtable records to a web store interface - strictly for internal use only - to add a shopping cart to generate a “pick list” so our warehouse crew knows what items are being picked by the designer, for what job, and where they are being delivered to at the client location. It needs to accurately reflect stock levels at the warehouse and current location of furnishings. When a property is getting ready to uninstall, we want to be able to mark ALL items in that property now available for picking without having to go through and manually assign it to each record. Each item will be assigned a sku/barcode/ qr code (format doesn’t matter at all) that our crew will check as it gets loaded to the truck and scanned via iphone or ipad app when it

I need to build an asset database similar to the asset database template that is available. I have the data setup already. I need help linking to a maintenance sheet to keep track of the maintenance performed on the assets. After that I want to make an Employee Database.

I just discovered Airtable as I have several projects it seems perfect for and need someone to help me and my small team get off to a fast start building out many things we have need for right away. If you have Airtable project experience please email with that and you’re near-term availability to: fcupgrade a/t gmail.com Thanks, mb

Here is what I want: I want a formula to multiply the Total Units by 1.95 if OOM? is not checked. And if OOM? is checked, I want Total Units to be multiplied by 2.70. Let me know if you need anymore info from me. Thanks in advance!!

Hi all, As far as I can see, there is no out the box facility to create an XML feed out the back of Airtable. I have also looked into Zapier which only seems to provide an RSS feed. Is anyone in here able to help me create such a feature? We’re a real estate company that wants to provide our property listings via XML. I can also provide a more detailed brief once I identify this is possible. Many thanks in advance Harvey

I am new to Airtable and have a pretty good grasp of it capabilities.I need help setting up my tables in the most efficient way to maximize ease of use and data management/processing as well as to sit down with our team for a quick lesson on how to best use it. If you are in the Los Angeles area, I would like to meet and learn from you, and get my system up and running smoothly based on our mission. Please respond via email. I will pay for this service. Bradly Palmer- bradly@qualityctrlmgmt.com

Hello, I’ve developed some Access VBA code which reads and writes to the Airtable API quite nicely using a module to parse the JSON. My own use-case scenario is to generate printed labels with QR Codes and make sure that my base stays synchronized when new labels are printed, but the code could be developed to nearly any need, and most especially if you have an Access DB that needs to be uploaded to AT, this could would also work very well for that. Are there others who would find this code useful to share? Or, can I help anybody to convert their data for a reasonable fee? Let me know! –Jon

I need a fairly advanced Airtable database set up and automation created based on the Airtable database for a subscription box company that delivers different items in each box based on customer preferences - no two boxes are alike. Box Dimensions Medium box: 27.9x21.5x14 cm (11x8.5x5.5 inches) volume: 8397.9 cm Large box: 30x30x15 cm (12x12x6 inches) volume: 13,500 cm Box types and cost of goods Regular - should fit in small box only, cost of goods is $10 More Loot - should fit in small box only, costs of goods is $15 Figurine, should fit in medium box but can also fit in large box if required. Cost of goods is $30 (this is the only box relevant to this job currently) What I want to accomplish using Airtable, HubSpot, and external scripts (if required) HubSpot contains all of our customer records and their item preferences. Airtable contains the database of all products that can go in our subscription boxes. Products have an associated cost to us, as well as their dimensions (L

hi there, i run a construction and property management company. just starting using Airtable. first task is to get someone to convert our ugly excel sheets into Airtable bases next is to consult on how to setup other bases for our business thanks!

I need a fairly advanced Airtable database set up and automation created based on the Airtable database for a subscription box company that delivers different items in each box based on customer preferences - no two boxes are alike. Box Dimensions Medium box: 27.9x21.5x14 cm (11x8.5x5.5 inches) volume: 8397.9 cm Large box: 30x30x15 cm (12x12x6 inches) volume: 13,500 cm Box types and cost of goods Regular - should fit in small box only, cost of goods is $10 More Loot - should fit in small box only, costs of goods is $15 Figurine, should fit in medium box but can also fit in large box if required. Cost of goods is $30 (this is the only box relevant to this job currently) What I want to accomplish using Airtable, HubSpot, and external scripts (if required) HubSpot contains all of our customer records and their item preferences. Airtable contains the database of all products that can go in our subscription boxes. Products have an associated cost to us, as well as their dimensions (L

Relatively simple project for our medical marijuana farm - but need some help. Specifically - we need lots of different reports but I’m not sure how to produce those easily in Airtable. Thanks!

We are looking to build a project. Create a Contact/Lead management system that not only houses all of our contacts/leads, but can “Merge” the db fields into simple Form Letters of choice, that can then be printed fro mailing. Kinda like a we can with Filemaker Pro. Is this something anyone can help us with?

I’ve been using Airtable for a while now on a limited basis. I really want to deploy to my entire company as a project management tool (one base with tables for Clients, Departments, Projects, Tasks, Notes, Events, etc), but two key features are missing for me: A Dashboard- What I’d like is a kind of “me view” that any user can use as a home page for the base… it would automatically display (in some simple grid/block form) everything related to a given collaborator… every client, project task, message, etc, that they are associated with… with clickable links to the actual record in Airtable. This is far more than a custom Airtable “View”, because it involves data from more than one table. A Reporting Tool - Basically, we need to be able to (at a moment’s notice) generate a printable project status report from a given Airtable view (a grid/spreadsheet-style view of dozens of projects, ideally with page headers/footers, numbered rows, labeled columns, and all the other features you’d