Builders Board

I needed to update Airtable with info pulled from a custom CMS that doesn’t have the export feature I needed, so I wrote a quick Javascript bookmarklet that scrapes the values from the page, looks up the corresponding record and updates it. Not the most robust script, but it’s saving me lots of time! Now all I have to do is browse to the page of each contact that I’m looking for and click on this bookmark. Could easily be adapted to use Airtable as a bookmark manager, or a way to save snippets and images. javascript:(function(){ fields = {}; fields["Email Address"] = jQuery("#email").val().toLowerCase(); fields["Address"] = jQuery("#addressstreet1").val(); fields["Address 2"] = jQuery("#addressstreet2").val(); fields["City"] = jQuery("#addresscity").val(); fields["State"] = jQuery("#addressstate").val(); fields["Zip"] = jQuery("#addresspostalcode").val(); fields["Country"] = jQuery("#addresscountry").val(); if (jQuery("#gender_female").is(':checked

I’m happy to announce the launch of Quickflow, a tool designed to save time on manual tasks by integrating web apps together! Airtable is one of the connected apps that Quickflow integrates with others such as Google Drive, Slack, and Dropbox (with new apps being added every day). You can give Quickflow a test run at https://www.getquickflow.com, it’s completely free to try. If there are any particular integrations you’d like to see, please let me know at ricky@getquickflow.com. Thanks!

Greetings, We’re a small, non-profit organization that is fairly new to Airtable and are soliciting proposals from consultants who have extensive Airtable or database experience. Our goal date to have this completed is early June and our budget is under $3000. If interested after reading the below, please contact me with your rate, background experience with Airtable, and your initial proposed scope of work. We primarily use Airtable to track our federal grant work plan deliverables, strategic plan, and service utilization (somewhat). Our current setup suffices in some ways, but there are gaps I’ve noted and I’m certain there is a more efficient way to organize the tables than what’s set up. We’d like someone to look at our current setup, and based on our business needs, re-configure it more efficiently. Below are specifics: What we currently do, but needs help: • Track # of training sessions (through various stages) within a given time period • Track #

Hi, We’re a philanthropic organization that uses Airtable as a grants and relationship management tool. We are fairly savvy with it, but I’d like to hire someone to do specific projects I have in mind that I don’t have time for. There are ebbs and flows with projects depending on the time of year. Some current Airtable support I’d like right now is: Create a survey/form asking multiple stakeholders to rate an organization. Take that information and use Page Designer block to present the summary information and data to allow a group to assess and vote. Recommending and creating blocks (like pivot tables) to help many stakeholders see summary financial data. A general review of our base to offer suggestions with how to use it better. One-off questions I might have on how to enter and link data. Not urgent but (eventually) use zapier to import data from grant applications If you have experience thinking through th

Need someone with strong expertise of Airtable’s API to consult with on a custom developed integration between Airtable and a vue js database. Currently, we have the tables we want to mimic in Airtable but we don’t know how best to format them (lookup tables, arrays, primary keys etc…) such that they will best integrate with our tool. I’m a product manager for a venture-backed startup in SF and I am willing to pay competitive hourly rates for work on this project.

Colorado Horse Rescue is a 501©(3) impact organization. Our mission is to provide a safe solution for every horse in need. We are looking for support to create our “equine management system” using Airtable. There are no robust EMS systems on the market, and based on initial testing on Airtable, we believe with the right support we can build what we need. Please reach out if you are interested and would like additional information.

Hey all, I need a simple project management base. I want to be able to view things by deadline or by category, but I also want to be able to dive deeper into each day or category. It’s not a complicated set up at all – I just don’t have time to figure out how Airtable works. If you’re available ASAP and budget friendly, reach out. :slightly_smiling_face:

I can be reached at fb@promolacrosse.com. Possible integration work as well.

Hi I need some help with my tables. Connecting columns, and making them talk to each other. Hiring a consultant. Ty

I’ve now touched down again, gotten over the obligatory cross-country-flight-induced cold, largely muddled through the [DST-intensified] time change, and begun the process of establishing an East Coast base of operations. (Bridging the San-Francisco-to-Southside-Virginia cultural shift would have been impossible in so short a time — quite likely impossible, one suspects,* regardless the time allowed.) Accordingly, I should be increasingly present in Airtable community and increasingly available in general for assistance and consultation. I’m working my way through the backlog of promised responses — but, given this transition has taken so much longer than I first expected, feel free to remind me you’re still waiting. My mobile, annoyingly, doesn’t appear to have survived the journey, so for the next day or two the best way to reach me is through a PM here or an email to wvannhall@paladesigns.com.

I’m looking for assistance setting up automated Airtable searches through integrations with Integromat or Zapier (or other). I would like to create complex formulas for searching a product database triggered by a new customer entry into a separate database. I’m looking first for guidance on if what I’m looking to do is possible, and if so, the time and cost it would take to complete the set up. Thanks, Cristy

I have 3 laboratory instruments that I want to push data into a table with timestamps. I will work up a more detailed data specification before we start. Interface is RS-232 over Blutooth and Infrared. The parsing data is very clear and detailed documentation for the right expert to implement this solution quickly. The baud rate is very slow, and total record is probably only 14k . Want it to push a data table to Airtable on my phone. Only advanced programmers who really know what they’re doing with this API, I’m looking for a finished product with some alpha and beta changes.

Need to work with an Airtable Consultant that can create a reporting process.

A couple of hours ago, while I was working on this base and post, I decided to take a break and go for a walk on the beach. I got as far as the shipwreck of the William H Sumner, exposed by Hurricane Florence, before heading back. Once I got here, I sat down to finish this post and discovered @Justin_Barrett had beaten me to it. Justin’s solution is preferable to mine, as it is more general-purpose, but I’ve decided to post anyway, as drop-in code for anyone with a specific need to restart numbering each day. For those of you who can stomach having to

I recently moved my work history notes into Airtable, and wanted a way to see at a glance how long I worked at each company, including time spans for those companies I’m still working with (I used to work full-time, but starting in 2012 my work became a mix of part-time and freelance/contract jobs). The end product is a clean listing of years and months1, as this sample illustrates: The full table includes three hidden formula fields: {End Date} defaults to TODAY() if no specific date is entered in the {To} field; otherwise it uses the {To} date. {Years} and {Months} run calculations based on {End Date}. The {Length} field puts it all tog

I’m using Airtable pro. I have 4 forms in a workspace that fill 3 tables. I need to have the data from the 3 tables integrated into one gallery that has cards that pull info from the 4 tables based on an assigned unique ID. The forms and the gallery need to be embedded into my wordpress site. Please contact me if you think this job is a good fit for you. -Terri

4 Teir Gantt, Single Dependency I really want to mate the Gnatt (beta) block work. I’ve spent some time trying to work around the circular references, and in-ability to look past a the first record link. I got the start date for a task to adjust up to the 4th task in a dependency chain, hooray. The timeline block reflects the correct start date, unfortunately, the Gantt block sets any task that is dependent on a dependent task to the 1st of the year. I’m hope new column field types or other Gnatt friendly updates are made in the near future.

I am looking for someone to set up my page designer block for me. I have a construction company and we are currently using Airtable to control budgets however the one piece we are lacking is having a PO document that we can send to our subcontractors and vendors. I would say that our base is pretty robust and our uses of this platform are likely to be considered mid-level to complex… Next step would be a screen share interview (15 min) Book a screen-share here Thanks Shane

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: