Builders Board

Hi there! I’d like to hire an Airtable expert to teach me a few things. Rather than poking around the learning curve of Airtable, I’m seeking someone with experience with manipulating a large volume of data in Airtable. It’s a bit of an unusual situation with just over 40,000 contact records, many of which are duplicates, and I’m wondering what my options are for tidying it up. I need to remove duplicates, isolate records that have no email address, and allow someone else to go through and fill in those blanks. Once the data is clean, I want to set up Airtable to add functionality to our company’s processes, which I’ll need to learn as well. Thanks in advance, look forward to hearing from you!

Hi Everyone! Please read and let me know what your turn around time and fee would be here…I need some help with the following: If created date is in the last two weeks, and between the 1st and the 15th, payment is due on the 15th. If created date is in the last two weeks and between the 16th and last day of month, payment is due on the last day of the month. If payment is due on the 15th, payment will be issued on the 19th If payment is due on the last day of the month, payment will be issued on the 4th. So fields are: submitted (created at date), Due Date (formula/date), Issue Date Submitted: 4/3/2018 Due: 4/15/2018 Issue: 4/19/2018 Submitted: 5/22/2018 Due: 5/31/2018 Issue: 6/4/2018 Submitted: 2/16/2018 Due: 2/28/2018 Issue: 3/4/2018

Hey all, I’m looking into the possibility of creating a crypto portfolio tracker based on the CMC API. Something similar to this: docs.google.com Copy of Portfolio manager Example Portfolio Version 0. 13 Alpha release, Last update: 03/ 11/ 2017, Suggestion& Feedback, cryptofolio@ tutanota. com, READ IT To start your own version, just" make a copy" from the File menu. You also will need to allow permission if you... However being much more visually accessible, with easier access to store notes/research and rate upcoming projects based on fundamentals. A second potential addition to this may be a trade journal using APIs from crypto exchanges. If think this is possible and are interested in working on something like this please let me know below and I’ll get in touch. Thanks, Oli

I recorded this video of a system I built using Airtable, Lob, and Zapier for automating & managing physical mail campaigns. I hope it is useful to anyone who is interested in using Airtable to manage this type of business workflow!

My firm has created a custom project management system using MS Access, a SQL database, and some Joomla stuff for a web interface. We started this in 2011, so it has become very tired and complicated. We are looking to move this functionality over to Airtable, but need some help doing this since we no longer have the guy in-house who built our current system. Please advise if interested, thanks.

I outgrew google sheets and am needing to quickly get up and running in airtable. The system I want setup will be for three events. It needs to have a master list of attendees, a list of event-specific attendees, and an event-specific transportation manifest. I also want to be able to track our hotel room block utilization.

Looking for somebody to consult with my organization around best practices and database structure. As we start to move all our project management and data into Airtable, we want to ensure we’re setting things up successfully for now and future use. We handle a lot of video publishing on YouTube and Facebook and are also interested in having somebody help build API integration to streamline analytics collection from the platforms into our records. Our offices are in Burbank, CA, and we prefer somebody who’s able to consult in-person/on-site, but open to remote consulting as well if needed. Interested candidates please send me a PM with contact and rate info. Thanks.

About me: I am the Company Director for a photo experience & photo marketing company looking to switch our complicated (but effective) Google Spreadsheet over to Airtable. I have above average skills in spreadsheets, so I’m not coming in blind. I have imported an older version of our Event Database into Airtable and played around with it for 5-10 hours or so. I just have a few hangups in terms of seeing what we’re doing in Sheets translate over to Airtable. We are currently using Sheets for: Event Management (850+ events in 2017) Data dashboard (using FILTER functions to SUM revenue, COUNT most popular products, etc) Invoice records Contact database Integrations We are currently running Zapier automation to automatically pull information from new bookings into the spreadsheet We’d love to automate more, so open to suggestions for other integrations (though this isn’t the highest priority) I would like to set up a consultation meeting with an Airtable expert to review some of th

Starting a new business and I need help either adding formulas or just someone to do the whole database for a price. Please contact me as soon as possible. Gabrielaj@aol.com Thank you!

We are looking to hire someone to help build an integration with Salesforce // Zapier into an AirTable base. Purpose is for finance reporting. Looking for someone with a background in AirTable and also a problem solver and thinker! Message me if you are our person and we can discuss the details in more detail!

I am looking for an airtable consultant that: Can review our current base tables and make structural and data integrity suggestions. Can help design an automated solution using the Airtable API/scripts, and Google Sheets. Has experience with connecting Airtable to third-party data visualization software such as Tableau. More details provided during an initial call. Looking to get started this week.

We are an e-commerce company and sell physical products online in various online marketplaces. We need an online database such as Airtable to store and share data with other collaborators. We are attracted to the Airtable due to the visual aspects of the software, the ability to host image url’s, the formula’s that can modify the data, and the API which allows access by external programs. We also like the ability to simply drag and drop images from the web or our desktop into a field in Airtable and it convert those images into hosted image url’s. The product data we gather is what is initially made available to us by the manufacturers. We’ll call this “raw data” and store it in one database. Raw data will be manually imported or entered by a specific team. In essence, we need to be able to produce several product export files that conform to several different file formats which contain specific headers. We ultimately will be importing all of these product files into our inventor

I love Airtable, but its not perfect. I also love Zapier. I wrote a blog post about how to combine the 2 to overcome a shortcoming of airtable: Medium – 30 Mar 18 Airtable Dynamic URL to Attachment Using Zapier – Dan (Danny) Fellars – Medium Today’s zap includes just 1 solution: Airtable. Airtable is quickly becoming my new best friend. However, its not perfect. I wanted to… Reading time: 3 min read Enjoy!

I’m looking to engage someone for a few hours of consulting regarding an Airtable project. Here are the broad strokes. I want to over time, create multiple databases focusing on a niche community. Typical fields would include contact info (single line fields) and fields that support media (photos, etc) Databases will initially be seeded with a certain amount of records, then subsequent entries would be inputted by external community members In terms of scaling, I want to be able to create a database on the fly and have it be connected to the front end experience along with the other connected databases I want to explore how these databases can be connected, with a front-end experience that begins with a simple search field. I’ve read that Airtable is not suited to serve as a database for major external applications, but I’d like to explore what is possible in terms of a custom front-end experience utilizing Airtable APIs, with an experience along the lines of what I’ve outl

Hello, I recently came across airtable and believe that it is the perfect tool to use to build a request management system for my office. The database would be used by out concierge team members to see all incoming requests. Request forms would include event meetings, badge requests, restaurant bookings, same day requests, lost and found, car service and so on. We would also like to build reports and understand all incoming request better. I was also wondering if it’s possible to somehow send notifications and meeting invites to an outlook calendar. Please let me know if this sounds like a project you would be interested in. Thanks, Dina

Hi Folks, We have set up AirTable to track client engagements and want to do two things: First, attach Gmail emails to tasks in Airtable. Right now we don’t see a Chrome extension that makes this possible the way SmartSheet or Trello does this A lower priority is to automate emails out to clients with next steps when a current task is complete. Tieing Gmail emails to an Airtable task seems like a need that many Airtable customers will have. Thanks for your help! Abe…

I’m looking for someone who can help me get my Airtable set up for a logistics application. We order containers of materials from Asia. We need to track the orders that hve been placed and track what is recieved. I have a project brief and sample data. I have tried to set up on my own but it has been decades since I did any DB development. I need somone who can get this setup quickly and correctly for me. You can email me at aarcis@zoho.com if you like. Thank you

We currently use Google Docs and an array of other platforms to manage our applicant tracking, compliance and staffing operations and I’m convinced Airtable would be a better option however I don’t currently have the time to research and test it on my own. I am looking for some help from someone or a small firm who has built out several similar projects that could cut through a lot of the learning curve I would experience. Please email me so we can setup a time to discuss or let me know how to contact you. Thanks, McNair

Hi there, My organization is implementing a cross-departmental marketing strategy and I am looking for consulting help to help me with set up as well as show we the best way to: Connect/associate records (especially in calendar view) The best way to organize data from different plans/strategies so it can be viewed both as a unique plan, but also layered together with other data The easiest way to chop and change the filters and tags to view different cross-cuts of data Most of all, I’m concerned about getting set up correctly from the beginning as this is an essential tool for our marketing activities. If you’re interested please email me: grubens@tides.org Please include a little about yourself, your experience, and contact details of a reference. Thanks! Georgie

I am the volunteer technology guy advising a non-profit in building and organizing their data with Airtable. Initial needs are in contact management and keeping in touch with various segments of these contacts (for example, donors, governmental office holders, local business owners/managers and newsletter subscribers). Future needs involve gathering, recording and cataloging oral histories and historic images of a specific geographic area in North Carolina. I’m at the budgeting stage now and am seeking guidance as to what I should recommend to this non-profit Board of Directors for Airtable design, build and future consulting services. Bob

Hello. I have an Airtable with a lot of data. An example of it is here: Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free. In the table I have an Employee Name, contact info (for reference), and the important data: Shift, Project, and Scheduled Days (in multiple records) along with a Default Skill. In a second tab I have a Project Planner. In this I would like to have the Schedule automatically fill out the best it can, based upon: Scheduled Day Shift (Day or Night) Project Default Skill This way, I can sort the project planner, and easily be able to tell what my team is going to be in on what days, and easily see any blank spots I need to fill. My ultimate goal is for when I add new items to the master list of employees, they’ll automatically be added to the planner. If there’s overflow, I don’t know if there’s a wa

Hi there! I think Airtable is incredible and would LOVE to be able to use it for a project we (Camphill Association of North America) are working on. We need an application portal and contact database that can function like a simple ATS and CRM. It’s overall a fairly simple kind of thing, except we have 16 different locations that each need separate access. And I really want to be able to use the Kanban board to automate some of the workflow by triggering actions like sending emails and updating records in the database. We also want to have some kind of 2-way email integration/sync as part of the CRM so that all emails with an applicant is automatically stored with their record. And we have a long application that requires a secure login for applicants so they can trust their information is safe but also so that they can save what they’ve done and return to it later to complete. If this is possible with Airtable, likely with some Zapier integrations and maybe a wordpress plugin, and

Hi, I’m learning to use the new Maps block and would like to be able to add a track from a GPX file to my Map block. Is this possible? Thanks!

Hi All Looking at Airtable I’ve fast learned this is the tool for us however I also realised to get everything out of it that I need/want will require a lot of my time or a lot less of an experts time. As such I am looking for assistance in working with our base to help with a Sourcing and manufacturing process that processes orders as well as inventory management and some cool reporting. I have sent a few days getting the skeleton together but have a lot of things that need help with - it may need a complete overhaul. Essentially looking for somebody to work with me over a long period to fine tune and get the most out of Airtable fitting in with our processes. I am Australian based so preferably somebody close to my timezone but not essential. I understand this is vague so contact me at ashley@admarketing.com.au for further info.

In a recent reply to a post in Support, I set out a step-by-step process to create a table intended to drive an Airtable Chart Block bargraph, based upon the multi-record calculation routines I described earlier. In this case, the routines are not used to access values across multiple records; instead, they drive the population of a third table, allowing for the date and value from the previous X number of entries to be charted. At each new record from the [Main] table is added, the Xth value is dropped, the remaining values are moved up one position each, and the current day and value displayed as the most recent. Aside from linking each newly added [Main] record to [Calc] — a task that adds two mouseclicks to the record creation process and that may easily be automated using Zapier or equivalent middleware — once implemented, the routine should require no additional maintenance for nearly twenty years. Again, the reply describing the steps needed to implement the chart is here; the i