Builders Board

Script developers are quick to reach for the Switch() directive in javascript. This is considered better than IF() statements for many reasons, but this is not specific to Airtable scripting; Switch() is used in all flavours of javascript and it’s a bit faster than evaluating IF() statements. But just as Switch() is a better alternative to IF(), JSON may be a better alternative to Switch(). Consider the requirements of my Benford’s example. Traverse every record to capture the first digit in the values of a target numeric field. Count the instances where the first digit is 1 through 9. This is a simple aggregation and one might perform the classification

We already use Airtable and have a working database for payments, surgery(project) tracking. But need to improve on the model and create automations. Possibly integrations in the future. Since we are in Brazil, Portuguese speaking and understanding of Brazilian health management is desired. Thanks!

Airtable, known for its low/no-code marketing posture is experiencing rapid growth and adoption by users who need to create code and by many who want to learn how to code to take full advantage of the platform. The irony does not escape me. About two years ago I predicted Airtable would soon enable users to create javascript code; seven months later, they did. I called it, but this was an easy prediction - it had to happen. A few weeks after Script Blocks was released, I made a similar prediction concerning code generators. I guessed aloud how long it would be before we might see some smart systems able to create complex scripts that perform some pretty useful automation and tasks. Mark that one off - today I got a preview from Dan @openside and I’m excited that he made this a reality. Watch for announcements on this s

It’s not likely many of you known about Benford’s Law, but it will surprise you especially if you happen to unwittingly bet against it. Imagine a scenario - you’re having lunch at a counter cafe and the old guy next to you (i.e., me) says out of the blue… I will give you 20 bucks if you open any page in that newspaper and the first number you see starts with a 7, 8, or 9. And as part of this little game, if the number starts with a 1, 2, or 3 - you have to give me just ten bucks. Would you play that game knowing that the odds are stacked against me? It’s a two-for-one bet after all and numbers, of course, occur in the wild in even distributions, right? Um, wrong. Here’s a 10,000 record [data se](https://download .csv file)t of insurance information that I randomly chose for thi

Bonjour, Je suis gérant d’une société de construction située en Belgique. Je suis à la recherche de développer pour m’aider à peaufiner des workspace créés pour mon entreprise. Un workspace a été créée pour la réalisation de planning hebdomadaire et un second pour la gestion du service après vente. J’ai besoin d’aide pour: Créer des rapports pour impression avec entête, logo,…; Connaitre les possibilités pour réaliser des restrictions d’utilisateurs - Rendre par exemple impossible la suppression d’un enregistrement à une personne avec un statut d’éditeur; Possibilité de créer des liens avec un record suite à l’envoi d’un mail; Je me tiens à votre disposition pour de plus amples informations. Jerome SCHILS DELTA Constructions

We are new to Airtable and do not have capacity to build what we need in our project timeline. Seeking a partner to assist with the development a CRM/asset map to support state-level grassroots organizing that needs to be developed before year-end. Please message me if you are intrested in a tight turn and lets set up a call to discuss.

I’ve updated this show & tell to include a little better video that’s more complete and demonstrates many of the ways that MapBox and Vega-Lite can be blended to create a powerful visualization of data. And you can purchase this codebase as well.

Found this nifty tool on Product Hunt! Mantle supposedly allows you to turn your Airtable into custom internal tools with no code. You can natively integrate multiple SaaS apps too. Kinda cool and might be useful for someone :slightly_smiling_face: Link to PH: https://www.producthunt.com/posts/mantle

I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today. Check out how this simple script can create links that are dynamic and formatted with the text you want instead of the ugly full URL. Explainer Video: Loom | Free Screen & Video Recording Software Base: Better (Dynamic) Links - Airtable Universe Script: Create fully formatted links in Airtable · GitHub

Hi I have just discovered AirTable and have started to put together a database, is there a developer out there who can help me for a modest fee as I have limited knowledge of AirTable? If you can assist me please call me on 07976 797455. Thanks Martin

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

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!