Builders Board

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

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 “

Hi There, Please can someone assist I am having difficulty with the Airtable ‘New Record’ and Zoom Webinar Registrant integration using Zapier. Kind Regards

I found myself in a spot where I wanted to get JIRA to post data to airtable without another service like Zapier in the middle. In fact, this does require ScriptRunner. However, if you’ve got airtable, scriptrunner and jira, then here is a link to a Gist that will get you off the ground. So, you can basically add a new ScriptRunner listener, paste in this code and setup the constants. gist.github.com https://gist.github.com/nafeger/dc754f59645120df3f5e030dd0166067 JiraScriptRunnerToAirtable.groovy import groovy.json.JsonBuilder import groovyx.net.http.ContentType import g

My company is looking for a freelancer to help modify our database, set up automations, and possibly integrate Airtable with another database we use. It would be great if there is a freelancer out there with experience doing these types of things. The database is for a law firm that needs to keep track of deadlines and tasks for a few hundred cases.

PLEASE CONTACT: tiri@create.green We are building massive 3D printers (3000x5000x2000mm) to 3d print emergency shelters for Green Camps that serve as pop-up BnBs and eco-retreats for our regenerative programs (reforestation festival, Dhamma retreats etc) - we also want to 3D print our shelters for refugee camps and people who really need shelter, equiping them with massive printers and teaching them how to print from waste plastics. We are just about to launch a crowdfunding campaign to raise the money to buy the 3D printer and enough bio-materials to print our first prototype structures here in the UK. I have built our site http://www.create.green and would like a memberstack integration (already drafted here and would like it that when people signup on the different tiers of membership that their “account” (airtable entry) reflect the number of nights stay their membership has earned. £30 a month memb

We are currently using the calendar view to schedule our festival with over 20 venues and 450 shows across one weekend. It would be perfect if were were able to have a calendar view where we could see each venue next to each other and so that each venue staying in its own “column” instead of all of the different Venues being all over the place. Would this be able to be done if we built a custom app for this feature? Where would we go to find an airtable expert to build us this?

I am trying to achieve the following basic automatic backup feature (of data): When a new record is created in a specific table, I’d like to use the new automation feature to trigger a script that exports a CSV of that table (and a certain view). The script should be saved in a specific dropbox folder and subsequent export should simply overwrite the previous CSV export. Could someone write that script for me? I’d be thrilled if someone could solve this for me. Please contact me so that we can talk about a price for that service. Thank you so much in advance. – Markus