Builders Board

Trying to write a formula that will recognise a word value in one field then if one or more word values are meet in the second field then it returns a value in a third field. This needs to be able to meet several values in both the first and second fields and return a different value in the third field depending on the condition of the first and second fields.

Hi Community :wave: We already know you’re some of the best Airtable builders around, why not join our team? We’re starting a new role for remote Airtable experts to help customers around the world. We’re organizing the team by times zones and currently hiring for the “Central Mountain Squad.” Definitely apply now if you live in that time zone, and don’t worry, other time zones will also be opening shortly. :blush: The new role is called Customer Support Advocate. You’ll be providing online support for our creative and expansive range of customers, including everyone from video producers to cattle ranchers. You’re a great match if you’re a natural troubleshooter, get excited by working closely with customers to unlock their potential within Airtable, and have the ability to deep dive and learn the product inside and out. For this role, we’re looking for candidates who are: Experienced remote workers Display strong written communication

We’re hiring an Airtable (or other recommended software) expert to help us develop a more intuitive, aesthetically pleasure and useful report for our clients. Ultimately, the ideal outcome for this project is to be able to provide a report to our customers that is… Easy and quick to assemble, with much of the summary, for example, being automated by formulas. Aesthetically pleasing for even the most OCD among us. Proprietary and not easy to replicate if at all possible. Action-oriented, providing our clients with clear next steps. Easy to understand, for all levels of understanding. The ideal candidate is detail oriented to the point of OCD. Is a designer, and is able to produce intuitive, ‘clean’ designs, similar to an infographic, but with the utility/live-ness of a spreadsheet. They have worked extensively in Google Sheets, Excel and most importantly, Airtable. They are a quick study and will take the time to understand a little bit about our

Hi all, I am look to simplify the following: As you can see there are numerous duplicate entries for each size available for an individual name and for each size there can be multiple materials. I would like to split this data up so that there is only one entry of the name that links to the available sizes, then each size linking to the relevant materials with prices. Feel free to get in touch for further details if you want a quick project.

This is a card based calendar, powered by an Airtable. It includes helpful details such as countdowns, Google Calendar links, auto-magical sorting. See the GitHub repo and demo at https://github.com/Arty2/aircalendar This script and its related Airtable base may change breaking compatibility. Designed with multilingual websites (i18n) in mind. Underlying code is quickly hacked together, but fully functional and should work even with missing fields. PS. Dear forum admins: “can’t put images in a post” is not that useful when not knowing what one has to do before using images. :grinning_face_with_smiling_eyes:

I was looking for a meeting collaboration tool for a “pains, gains and goals” brainstorming exercise. I looked at a number of tools and all of them were quite a bit more complex than I wanted. Luckily for me, I have a subscription to Table2Site and @poehah was available to answer my questions on Saturday! Feel free to check out both the site (this is a demo page, so feel free to enter results): https://table2site.com/site/brainstorming Here is the related base: Airtable

Hey guys, I’m using Airtable as a kind of database for a ReactJs project. I’m pretty new to React and javascript in general and so this might be trivial for a seasoned developer. But I wanted to share one approach you can take to integrating Airtable into your React App. Here’s the tutorial: http://www.automationfuel.com/airtable-reactjs/ And here’s the github repo: https://github.com/focuswish/airtable-react I hope someone finds it useful :slightly_smiling_face:

Hello I am seeking assistance from someone who has proven experience developing complex inventory management solutions within airtable. We have built our own custom inventory tracking system and it works great, and has all of the information we need, but we are getting stuck when trying to summarize the data in a digestible way. We know exactly what we need, but need someone to create it for us in a manageable amount of time. We use airtable for ALL kinds of things, so I am sure we will call upon the right partner often. Cheers, Marie

Hi folks, I manage a growing database of investors that I just migrated from the Google Sheets/Forms platform. However, I have not found a way to send mail merged emails using attachments. Each email should say Dear (first name) and be a unique email to just that person. This would be a short problem-based project, but I would like to find someone seasoned to help me grow my database functionality in other areas as well with future work.

I have a ton of same type of XMLs that I would like to drop into the XML block. I just have no idea how to set up the XPATH block itself to grab the correct information. I attached an image of what the XML code looks like below.

Having had quite a few questions about an earlier blog post I wrote about creating checklists in Airtable using Zapier, I decided to write a new version using Integromat instead (which makes it much simpler, requiring no code): Database Resources Creating Checklists with Airtable and Integromat | Learn more about Cloud... Id

Hi Everyone. I work for a technology company and I’ve been tasked to find someone that can help us now on an existing base and moving forward creating new ones. This is an hourly contract/freelancer role. If interested, please email jessicaacer2@gmail.com with your details, experience and rate. Thank you. Jessica

Wanted to share a great experience I’m having with ReportBin. Use case: we work with athletes and provide them with career coaching to help them figure out what their post-competition life will look like. within a broader curriculum, we have individual homework assignments which are collected either through Airtable forms (when simple) or one-off custom forms built from scratch. after the athlete completes an assignment, it then needs to be reviewed by their career coach and the athlete which is where ReportBin has been a total life saver. after setting up the template for each assignment, we were able to use zapier to build a workflow where as soon as an athlete submits something, we generate a ReportBin report and the link gets written back into our Airtable. the report looks like this. i started working with Sam at ReportBin a few months ago a

Hey all, excited to tell you about BuiltOnAir, a project that’s been in the making for a little while now, and now going live. I think it’s awesome, but would love to hear your thoughts also :thinking: What is it? BuiltOnAir is a hub for Airtable happenings. We made it to become a place to bring together, highlight, and empower the people building things with Airtable - so if you’re here reading this, this is for you. BuiltOnAir is (currently) comprised of these main elements: A podcast: A weekly production highlighting an expert, professional, or enthusiast using Airtable in their work. We hear their story with Airtable, then we get a peek into their work with a “show and tell” of a base they’ve created (usually with a whole slew of nifty ha

Hey all, I’m really excited to share something that has been a long time in the making and one I think will help a lot of people. I’m curious: how many of you use Zapier for your Airtable integrations? I wanted to get a general poll for a sense of how people are using automation with Airtable: POLL: Do you use Zapier for your Airtable integrations? I have no need for Zapier Nope, I use another platform No, but I might in the near future Yes, and it does absolutely everything I want it to Yes, but I need it to do more (it lacks k

Starting my own Airtbale Consultation firm! Looking to help new users set up their Airtable(s) to meet their use cases. e-mail: cbrennick@rsu10.org for more information.

At BaseGenius we’ve now helped a few clients keep data in sync between Airtable and Salesforce. So we decided to productize our code and are launching it as a separate product from our regular consulting work. Check it out here and send us a note if you’d like to use it for your business. Daniel from BaseGenius

I’d like help creating a web page that displays data from a given Airtable View that provides me more robust control of page content and styling than is currently possible through the “share view” and “print view” commands. Requirements: The data on the web page must be synced with my base so that any changes (new records or updated records) are updated on the page. Preferably, these updates would be automatic, but a “refresh” button would be workable. We must have complete control of object styling, via HTML/CSS. I’m fine with manually editing the HTML/CSS; no CMS required. We need some basic controls for conditional formatting (e.g.; if a date is i the past, it is displayed in red; color-coding of particular values in a field; etc.) We must be able to host the page on our current web server, with minimal fuss. And I’m hoping it would not require any third-party licenses or subscriptions. Let me know what additional info

I have what a simple airtable base created; however, I am struggling to determine how (if) I can get the data to print out in a somewhat structured way. I have tried Airtable Blocks / Page designer but it appears this solution will not work for my current data structure. I am actually looking for someone to help solve this problem. Whether this means a new database design in Airtable or some other add on solution to that can provide the output in the desired format - I’m open to options and suggestions. I can be contacted at jack@spacecraftworldwide.com

Los Angeles Area. (Encino) Greetings, Our team is looking for an Airtable and/or Salesforce specialist to assist with the creation of an CRM application pertaining to Commercial Real Estate. We are looking for someone with strong knowledge of Airtable and/or Salesforce to work closely with the small internal team that is leading this project. The team is very familiar with existing data and operations. The team has a clear vision of the desired product and ability to do much of the work, but has no experience with Airtable. The ideal candidate will have the following knowledge/skills/experience: Database architecture/schema design Submissions workflow creation and automation (follow-up reminders, client reach, etc.) Integration with third-party tools (like Zapier) Migration/merging of data from spreadsheets Creation of exports and reports Creation of a well-documented system that can be continually

I’ve used Airtable to run a couple RPG games and it’s really great. Being able to have a view for my players to look at where I can post images of NPCs or notes is terrific. Here’s how I created the base (this is a Forbidden lands game). And here’s what players can see. It’s challenging to create hidden views that actually show the information I want to share. Hopefully someday there is another step for linked records that allow for a cleaner format.

We have a client with a series of projects that need accurate tracking of; status, task, estimated spend, invoices, budgets etc. Have setup the basics but need help in refining it and ironing out the bugs.

I am looking for someone to help me create a rental inventory database where, within a project, multiple items can be checked out for periods of time.

Hello! The The Chicago Architecture Center (CAC) is looking for an Airtable specialist to assist with the creation of an Airtable-based application to collect and manage data pertaining to Open House Chicago (OHC). This application will store information about past, present, and prospective OHC sites, along with related contacts and attendance statistics. It will facilitate the electronic collection of submissions and updates from participating sites, and the review, finalizing and export of this content by CAC staff. We are looking for someone with strong knowledge of Airtable to work closely with the small internal team that is leading this project. The team is very familiar with existing OHC data and operations and includes an experienced web developer. The team has a clear vision of the desired product and ability to do much of the work, but has no experience with Airtable. See more about the job and apply:

I manage a growing Nursing Agency based in Sydney. We recruit temp nurses on our books and supply to our client on as need basis. Every client have their own requirements and procedures to get a nurse approved to work with them (Onboarding Process). We have a fantastic client allocation software but we struggle with Onboarding and clearance of nurses with Hospital Clients. Current Setup: Recruiter interviews and scans their docs on onedrive. Also there is a compliance checklist in pdf (8 pages) - the recruiter will fill out 1st page on this checklist. Docs scanned in ondrive then taken over by compliance team. Compliance team continues to complete the checklist in pdf. Then compliance team adds nurses on to a different tracking excel sheet (the excel is basically a workflow - step by step process) to get the nurses cleared at different clients. For example, nurses hired for Hospital A and Hospital B are added to 2 excel sheets).