Builders Board

We are looking for someone to help create our new Airtable database from the ground up. We host hundreds of events each year both in person and online and are needing a centralized database that will include information about our events and have the ability to add the event date and it generate remaining tasks and assignments. If you are familiar with how to do this on Airtable just shoot me a note about your experience and rates at canaryk6@gmail.com Thanks in advance!

I need a ninja/guru/expert to build a base for my business. The attached map is a visual for what we need the base to organize. It would be a huge base, with lots of many-to-many relationships, and integrations via Zapier. I am happy to pay someone to have this done and done well. I am looking for someone who: completely and thoroughly understands Airtable, is available to focus on and complete the project swiftly, is kind, responsive, and efficient, and will listen to what we need, and then build the system to make it happen. I make jewelry, and sell via wholesale, retail and bespoke channels. I need a way to organize both the orders and the products, specs and sourcing so that when orders come in I can make sure the materials to make the pieces to fill them are available. Also, we need an aggregate of supplies needed across several orders at the same time. So, we need inventory management, order fulfillment, CRM, etc. Please reply if you think you could be our Airtable Ninja. GMA

We are an architecture firm wanting to track multiple projects each with multiple phases so that we can project and manage resources. I know that there are many project management templates available; multiple projects with the multiple phases with begin and end dates for each is out of my reach. Would like to discuss if this is doable, then if it is worth it.

I’m working on an international study of the environmental and social impacts of urban agriculture that involves creating a digital platform for farmers and researchers in five cities to contribute data on farm design and operations. I’m seeking a part time (up to 19 hours/week) research assistant to create an Airtable database from a list of metrics that we intend to measure. The research assistant should have experience designing and launching relational databases and have specific expertise with Airtable. NYC-based is preferred, though remote work will be considered. If interested please send a brief email cover letter and resume/CV that describes your database development experience to nevin.cohen at sph dot cuny dot edu.

Hello My base is begging for a PMT or Payment function, but there isn’t one I can find… I am hoping someone has found a workaround to calculate a mortgage payment. Kind of critical to our client and sales processes. I realize this is not a spreadsheet, but other databases can do it. I see there are plenty of math functions… is anyone able to put them together in a way to “make” mortgage payment function?: My Airtable Base is very depressed. a spreadsheet example looks like this: …where the field “MONTHLY PAYMENT (PI)” in the middle is the result I’m talking about… because to get that payment I must use the fields before it and a PMT function … like this So i ask, would anyone able to put together the mathematical functions in a way to “make” an amortized mortgage calculation based on %Rate, Term (in months or years), & principle… with the added bonus of a field for Extra monthly payment to add regular additional principle to the repayment.

Would love to find someone to help me build some smarter formes for my airtable based system. Does anyone have any suggestions? To be a bit more specific in the project: I have an AIR TABLE which we collect information on TV shows and Clients, buyers and Appointments and we use this info to send out HTML emails informing clients of upcoming appointments and update various Calendars on Cal. Lots of wasted time copying and pasting data that we’re collecting anyways, So forms need to be dynamic and pre-filled when possible, so we’re not entering in the same information over and over again. Rather making corrections and updates to data in fields. Also - if you can code some **great looking easy to use forms - we’d have so much more work for you. Fun stuff too! Super interest4ed in reverse engineering this into a google apps builder solution which would help me to learn it quicker on the programming side. Thought if Zapier and Airtable and Jotforms work, welll they are all great too! 323-81

I recently worked on a project that required loan calculations. This was easy in excel or google sheets but Airtable is missing these common financial functions. So, I brushed up on my math skills and with some help from the internet was able to reproduce those functions in Airtable. Thought I’d share with community: Airtable Financial/Loan Formulas: PMT, FV, PPMT, IPMV - Airtable Universe Excel and Google Sheets users will be accustomed to common financial functions used in loan calculations that are currently not available on Airtable. This... Formulas currently implemented: PMT, FV, PPMT, IPMV

We’re looking for a form that takes: Code Email address For 1, we hope to link to a table of promo codes that we generate (e.g. WJN103 etc). The user would have won a prize and be sent the code and url to the form to enter the code. The form needs to validate that the code they enter into the form is one from the table. 2, we also need their email address to get in contact with them to redeem the prize.

Chinara James – 5 Nov 18 How to paginate records in Airtable when using the API | Chinara James Airtable’s API is great and so is their documentation. However, I came across a small stumbling block while using it to build a simple project. The problem, Airtable returns a maximum of 100 records…

Hi there! I’m looking for help in setting up a system in Airtable by which I can track assets for my VERY small business as a personal chef. My db skills are rusty at best, but I can learn! Scenario: Personal chef service uses reusable/returnable containers for packaging meals. With each delivery, I drop off the current meals and pick up the containers from the previous delivery. Containers get lost in the aether and I end up with many missing and having to purchase more (which eats into my slim profits!) What I’d like to do: Assign unique barcode to each client and each container. Assign containers to a specific client via barcode scanning (scan the customer barcode; scan the container) Scan container barcodes upon their return to see which containers are still checked-out and to whom. Container records can contain the following fields: Container type, size, manufacturer, supplier, purchase date, purchase price, replacement price, assigned client, condition If you can assist with this

Hello! Is it possible to use airtable + zapier to find 1 email address (out of many) on a google calendar invite and match that to a record on the airtable people list? Ideally, the end result is that within Airtable, I can see when I last had an appointment with someone on my “people” list based on calendar events.

Chinara James – 19 Nov 18 Getting Started with the Airtable API | Chinara James Airtable is an easy way to get a database up and running for a side project or to quickly prototype an idea for app. I have used it to manage track projects, expenses, client contacts and more.

Hey there, I am in need of some help with airtable - I wish to create a simple custom CRM with airtable for tracking leads, campaigns and sales. I have the basics figured out but need help with simplifying and structuring base. It’s a sort of a student project so my funds are limited. All help greatly appreciated. Thank you.

Hi everybody. I am finally taking the plunge with Airtable! I am a small business owner that runs a series of classes a few times a year. I am looking to use airbnb mostly for organizing class registrations. Right now my current system is google forms, excel spreadsheet, gmail - it has been time consuming. I’m excited about the idea of something that could combine all these. Here’s what I’m looking for: Spreadsheet about students (name, email, which class they want, how much they will pay, access information etc) that my teachers can view but only certain details (such as name & access needs). Registration from that feeds to the student spreadsheet. Max limit on how many students can register for a class on the form and for the class option to be turned off as soon as it is maxed out. Automated emails sent to student right after registration with certain info about payment, class dates, attachments about the course, etc if possible. Calendar for classes that my teachers can view/ma

If anyone has experience and feels comfortable implementing AirPress (AirTable WordPress plugin https://wordpress.org/plugins/airpress/) please reply to this message or direct message me at email address: henry at concise [[dot]] ac Thanks!

We’re looking for assistance automating our workflow for one fundamental task. I can explain more, but I’d like to hear from a few Airtable experts out there that have experience automating with Airtable.

My company (Safari Telecom) has recently become a user of AirTable. I’m starting the process of seeing what tools/individuals are available to help us get integrated and trained within the system. We’re looking for someone who can understand what we do and how AirTable can best be utilized to create efficiencies.

I need to see if it is possible to create an inventory system for our subcontracting company and then integrate the purchase orders, receipts, and invoices into Quickbooks. We design a system, order material (some finished and some that needs fabricated), fabricate, and deliver to a jobsite. We order 10-15 times a week and each order has as many as 50 items and each item can have a few hundred parts at any time. I want to put in our items based on the vendor’s part number and use their barcodes. I also want to make packing lists when we ship. The packing list should create a single barcode for the multiple items that are in the shipping order. When the receiver in our company receives the shipment for work, they can see what is in the shipment. I want to see if we can create an inventory where items that are ordered specifically for a certain job don’t go to our inventory but to the job’s inventory.

Hi, We have used Airtable to store all of our data and need help building a user-friendly and responsive Website. The wireframes and specifications are in the following documents: Specification document: https://drive.google.com/file/d/1qXDSzZaEdC6X7Djve-0fh2SooDZsILVg/view?usp=sharing Screens: https://drive.google.com/open?id=1apeuZGiypC87HH5HdDDz8xd2o-PvqXrM All of the data populating the website is in Airtable. For read-only access to our current base: https://airtable.com/invite/l?inviteId=inviesiRd1QGNbnGU&inviteToken=f1ab2d05385fbaa5c0539ab9c93de07517a5baaa1cc203a9307def21b308b797 Please check our Mockup: https://projects.invisionapp.com/share/S4NI7T8YX7U#/screens/314220428 The following third parties are used. It would be great if you have You experience in all of them. Airtable Acuity Scheduling Google hangouts Our current goal is to launch by November 19th. Any introductions would be greatly appreciated. Thank you for taking a look.

I am seeking an Airtable expert to write several formulas per the below description. Zapier will be feeding data into Airtable, so I would like to get these formulas in before developing Zapier workflows. Link to Video Describing Requirements: https://www.useloom.com/share/facdd62943c44a578329e631bed17a85 Since, I cannot attach anything, below are the requirements as discussed in the above video link… Within ‘Operating Table_Main Client Record’, the following formulas need be written: – “Hours Since Proposal Sent” should count the number of hours (set as an integer and rounded up or down to the nearest whole number) since the proposal was sent relative to the current time (time zone = EST). If “Proposal Sent” is blank or set as “No”, then this field should be blank. Also, if “Proposal Accepted On” is not blank, then this field should be blank. – “Days Since Proposal Sent (Actual)” should simply divide “Hours Since Proposal Sent” by 24 and be expressed as a decimal with one digit of pre

Hi, I run a product importing company and need help designing our database. I’ve built a rough airtables database but I know it can be so much better. I’m looking for somebody to: Briefly understand our business and the workflow Look at the current airtable database Make suggestions to a redesign and/or features we aren’t using Execute on the redesign to the extent it takes any special skill Here’s a rough idea of the business: -We’ll have 50-100 orders (POs) -About 12 factories -Each shipment has lots of documentation that can be uploaded (PO, Bill of Lading, Packing List, Invoice, Shipping invoice) -Each shipment has a lot of information that can be extracted (value, type of goods, duty code, cost of shipping, ports etc. ) -We’ve been using it to track the status of each shipment (ordered, ready to ship, booked, on the water, delivered, etc). There might be some integration available with shipping data using the ship number or HBL, but that might be an overkill. Manual updating is

I am looking to empower my managers to take care of customers. Whenever a customer has a problem, they usually call the restaurant and let us know of an issue. This is great- we love the feedback, however there is a small percent of customers who take advantage of our good nature and call us regularly for a refund or credit. For example, a customer calling the restaurant six times in one month saying they received burnt food (hey, im not saying it cant happen, but really?). I would like our managers to use airtable on an iPad when receiving a complaint call to enter customer name, phone number, date, and a brief description of the problem. Ideally, when the form is being filled out by a manager who is on the phone with the customer, the new entry would either: (preferred) Automatically attach previous customer contact records stored in the complaint database (based on similar name and by phone number) to the new entry. This will allow us to see a history of complaints and issues by t

Is there any trick to get the menu “Hide fields, Filter, Sort” in other languages like French ? Could we add something to the iframe code to replace these specific words? Unfortunately, there are submenus or criteria fields in English as well. The best solution would be a parameter that would make the app displaying these words in a chosen language… Benoît

I’m trying to create a product listing directory with user accounts. Here is how the final result should look. I do not need the shopping cart, just the listings and user accounts. What’s the easiest way to do this? Can Airtable help? I’m seeking a consultant or peer who can help with this. Thank you.

Hello, I owned a ecommerce store in the art supplies niche. The first step of our workflow is Product Research --> then it we select the products we want to launch based on the numbers we see in the market research (sales volume and market demand) Quoting --> Once we select our product to get a quote on, our sourcing agent will send us mutiple quotes from different suppliers. This infomraiton should be capture Supplier Selection / PO --> ONce we have a supplier selected, we issue a PO. This is where we have a database with the product name and a item number , UPC code should be created by then along with (Costs, estimated shipping etc) . Invoice / Payment --> Once supplier receives our PO, we get an Purchase Invoice, now we track payments 30% downpayment, 70% remaining, etc, and bank details, payment date, next payment date for CASH FLOW projection. Shipment / Inventory --> We plan shipment based on container loads and different suppliers, every month we send one contain