Builders Board

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

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 o

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

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

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 eq

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 keyXXXXXXXXXXX

We’re excited to announce that our Bulk Download Attachments app has been released on the Airtable Marketplace! Airtable

Hello I am an indie filmmaker and I am working on a film project. I am looking to develop a unique and a companion workflow application for FCPX. Based on my findings, there is no dedicated application to what I am looking for. The application involves, database management, handling of audio, video, images and metadata. After much detail research, I realise that Airtable might be the perfect database management platform that I am looking for for the backend. The are couple of ways to my problem. The old school and new school. The old school way might be parse xml from FCPX into CSV and import that into Airtable. But I am thinking of a new school ways and thinking of the possibilities that it might open up. The concept for my app is simple. Despite being simple I believe that the engineering could be a little challenging. I also believe is it can be groundbreaking idea in the filmmaking community and can revolutionise future workflows. Apple have published docume

Now that the submission period for the Custom Blocks contest is over, I’d like to share my custom block for check-out/check-in systems! This block is a customizable wizard which, in its most basic form, allows users to select a Unit record and create a new linked record in a Log table detailing when that record was “checked out” with relevant fields pre-filled to save time. The wizard just as easily allows users to check that unit back in to close out the log and make that unit available for selection once more. Advanced features include tracking a unit’s condition over time (i.e. the unit was in “great” condition when it was checked out, but was in “poor” condition when it was checked back in), and the ability to enable an Items table for bases structured where each unit is an instance of a type of item (i.e. 5 “