Builders Board

Looking to have someone assist building a proof of concept integrating Airtable to third party software via APIs and web hooks. Very straight forward use case with potential work in the future. (Memsource API primarily) Thanks, LM

Looking for a developer to help with API project. We have a functioning database, all structures are rocking but need to get a certain scan view that we can’t accomplish with Airtable/mini extensions alone. Looking for someone to help with an API project to display records, scan from one column to another in a “bag” or “order” scenario. Basically… confirming they are in the right order/bag. Accomplishing this in airtable with QR scanners, but need scalable front-end interface that employees can use.

Non-profit looking to hire consultant to help develop inventory management, multi-order shipments, link shipments to customer records, and manage customer records. Please message if you have experience with these and are available to start this week.

Hi, Searching for a consultant/freelancer (ideally UK / European based due to timezones) to develop a base on behalf of my company. This is used as a pipeline tracking system for business development, but requires automation to create log lines in other sheets for data collection whilst feeding back to the initial sheet. Work needs to start immediately with a tight completion timeline of approx the end of the month. Appreciate any recommendations. Jack

Hello, I am looking for a developer who can set up airtable to easily maintain an extensive list of materials (BOM), suppliers, store designs, product data, etc. Currently, the company is working with excel. This is quite urgent.

Hi there, I’m looking for help to start using Airtable for my company. I need help converting sophisticated Google Sheets -> Base and with Monday.com integrations. I have assistants who do all the data entry but need help with design and layout. I’m racking my brain trying to figure out how to set it up so everything runs seamlessly with automations. TIA!

Hi team, Many of us have large Org Charts aka Maps of our data - I have several that take me minutes to scroll from left to right. I’d like to see: A mini-map that allows us to quickly navigate to an area of the bigger map/org chart Mini map allows us to scroll, zoom, pan, or drag across the bigger map canvas / org chart. See attached picture. See attached link.

Hi, I’m looking at using Airtable as a CRM and I’m interested in connecting Airtable records to Xero and to HMRC giftaid. I’m aware other CRMs connect to HMRC giftaid, some via Swiftaid, and I’m wondering if any experts out there have come across this and have any recommended approaches with using Airtable.

I have created a Synced table from Airtable updates Base that can be translated in french from Google Translate with a button. If you want to do the same table for an other language send me a DM I will happily send you the full table so you don’t have to make all the formulas again. Link to the table. J’ai créé une table de synchronisation à partir de la base de mises à jour Airtable qui peut être traduite en français à partir de Google Translate avec des boutons. Si vous voulez faire la même table pour une autre langue envoyez-moi un DM je serai heureux de vous envoyer la table complète afin que vous n’ayez pas à faire toutes les formules de nouveau.

We’re looking for a consultant who can listen, brainstorm, and help us take our ideas to a point where we can start trying stuff asap. Our company is based in NY, but the consultant can be anywhere. We use MS Teams for online meetings and collaboration. We’d like to get going as soon as we find the right person. Additional notes: We’re a commercial building services company (janitorial, windows, construction cleans, special projects, etc) We have recurring services customers (low churn), and non-recurring/project customers (sometimes repeat services, sometimes not) We have about 200+ employees Due to our industry, our employee turnover is higher than “normal” We have 100+ customers, ranging from large factories to small offices Some customers have more than one building/site Our field employees generally work at more than one site, and “report to” more than one supervisor Retaining employees becomes a strategic advantage in our industry. We to expand our data collection in a way t

I just launched a brand new app on Airtable’s app marketplace. Data Fetcher lets you run, save and schedule API requests without leaving Airtable: https://airtable.com/marke…/blkZrRSlxzhBlv6T9/data-fetcher Some of the features: • Use values from your base in the request URL/body/headers • GET/POST/PATCH/PUT/DELETE methods all supported • Save API requests securely • Import requests from cURL commands • JSON/ XML response to Airtable transformation • Response field types are inferred. e.g. dates in API response become Airtable date fields • Schedule requests to run hourly/daily/weekly • CORS proxy for all requests If you have any feedback or questions, feel free to comment or email (hello@datafetcher.io)

How can I hire someone to help me? I think what I want is simple, I just need help setting up. How can I hire someone to help me?

Our nonprofit research project needs someone who can create an app for AirTable that consists of an interactive, georeferenced map of medieval cemeteries that associates specific graves on the map with entries in AirTable. We are compiling a database using AirTable with over 100 cemeteries and several thousand individual graves with detailed archaeological, isotopic and genomic data. Previously, the archaeologists we work with had been using a database called Thanados, which is good for visual examination of individual graves and their properties, but is extremely time consuming to enter data, limited on how one can do complex Boolean searches of the data, and useless for any statistical manipulations. It does however have one killer feature that AirTable lacks: it has integrated a map like Google Maps onto which one can place the map of a cemetery and then designate each grave. When one clicks on a specific grave ID in the database, it illuminates where the grave is on the map, and vi

I came across a great resource from The Covid Tracking Project Once I saw they had an API, I decided it was the perfect use case to showcase the power of Airtable - charts, scripts, data grouping, etc. So, I spent an hour to build this tracking utility from the Tracking project. Feel free to share: Airtable COVID19 Tracking - Airtable All Data Collected and Provided by [The COVID Tracking Project](https://covidtracking.com/) Airtable organization and charts created by the team at [Openside](https://openside.com)

Hello! We’re looking for an Airtable expert to consult with / potential for project work in building a prototype for us. We’re a logistics startup and seeking to use Airtable in few ways. Highly interested in automations, building bases with one-to-many relationships and Zapier integrations. Please leave your contact details and we’ll reach out to you. Thanks in advance!

We are trying to use AirTable to manage volunteers through a linear process to track them in stages. We have a limited budget, and I don’t think it’s that hard, but we don’t have the time in our internal tech team to do this. It would require creating the architecture, probably creating some automations or scripts so that when a certain form is filled out, a stage automatically changes. It would also involve a brief training on how to use it.

I’m the Democratic nominee for Congress in the Massachusetts Fourth. If I win on Nov 3, I will be seeking an Airtable expert with an interest in Democratic politics to help run, on a part-time basis, the campaign & fundraising sides of the operation. Massachusetts resident preferred but not required. Text 617 431 6546 with your interest.

Hey there! We created a quick guide to backing up your Airtable bases. :point_down: The Essential Guide to Backups for Your Airtable Bases The most basic way is to set a regular time in your calendar every week and export each table in your base. If you need an automatic backup option with attachments included, try the On2Air: Backups solution. You can set backups to run on a schedule and automatically be uploaded to online storage. (plus, you get access to the other useful On2Air apps - you can try it out with the free trial)

I’m looking for someone that can write a script to update Airtable records (via the Octoparse api) as the data is being scraped from the web by Octoparse such that the Airtable database is updated within seconds of the scrape.

I’m building a tool that will follow up with vendors/clients/co-workers with automated text messages. I need someone familiar with setting up triggers and integrating airtable with other apps like twilio. About me: I’m a project manager in commercial construction. I spend most of my time thinking about how I can automate tedious tasks. If you are interested please send me a direct message. Chris

This is how you can calculate the number of unique values in a field in a linked record. I couldn’t find a previous post on this when I was looking for help (apologies if I just missed it) so I thought I’d put one here for others to find. Short answer: you can create a Rollup field specifying the linked table and the field you want to count unique vales in, then define an aggregation formula as follows: COUNTA(ARRAYUNIQUE(values)) The tool tips for the aggregation formula don’t make it clear that you can do this. It may appear that you are limited to the simple formulas they suggest, but this is not the case. I haven’t tested it to see how far you can go, but nesting ARRAYUNIQUE() within COUNTA() definitely works. What is this used for? In my case, I have a table of Locations where we have equipment (e.g. Chicago Office, London Office, etc.), and I have a list of Assets that tracks all the individual pieces of equipment. I also have an Asset Type table that tracks the basic information

Hi, I am building an Airtable solution for a client who requires automated reporting capabilities. The solution captures the data from so-called ELOM assessments of young children (50-69) months: http://elom.org.za. We are using SurveyCTO to capture the data in the field and Integromat to get in into Airtable. In Airtable, ELOM submissions are linked to specific projects (e.g. a NGO which does ELOM assessments of children in pre-school). At the end of a project we would like to be able to click a button and output an automated report with a few graphs. We usually do thus sort of things in Stata or R, so I have an idea how to do it in Airtable scripting using output.markdown and Vega-lite but I don’t do JavaScript and it would take me a long time to make it work. Anyone here interested?

I am looking for a Developer to create a website i think js to showcase my vacation rental properties, for sale properties and monthly rentals. Currently i have a draft here https://sites.google.com/view/roompanda/rentals?authuser=0 I would need date search capability so guests can see properties available. Ideally i would like to integrate Stripe for payments if possible. I would like to have the option to proivide property owners with accounts to add rates.

Hi all – I’ve been working on a project for quite a while now and am excited to show you all. It’s called Stacker, and it allows you to create portals on top of your Airtable with login for your users and private data. You can theoretically build any UI you like, but for now I’m trying to get it working well for simple user portals before going for anything too complex. Is there anyone out there who has a use case around giving your customers an authenticated web app where they can self serve? I’d love to chat to you if so, and maybe see if you’d like to take part in helping us test the product before I release it to the world. If so, email me at michael@stacker.app You can check out our landing page at stacker.app/portals Would love to hear your thoughts! :grinning:

Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding. If you are looking to just copy and paste the code you need without much explanation, ignore the details :slightly_smiling_face: Details SECTION 1- CONNECTING EXCEL TO POWERQUERY- The first issue a user may run into while trying to get data to automatically feed into Excel is creating an authenticated connection to Airtable from Excel’s powerQuery. The following code will be used in a later step, but it is given here as a preview of the code that is chiefly responsible for the data connection to airtable’s api. Source = Json.Document(Web.Contents(“https://api.airtable.com/v0/[PartialAddressToYourBase]/[NameOfYourTable]”, [Headers=[Authorization=“Bearer keyXXXXXXXXXXXXXX”]])) You will be replacing “[PartialAddressToYourBase]”, “[NameOfYourTable]”, and the “keyXXXXXXXXXXXXXX” with your particular information at a later step. Now even if a query were created with its sole