Builders Board

Sometimes you want to visualize some metrics. For example, I may want to see the different delivery metrics of email campaigns by different segments across many years. I can do this nicely with blocks if each campaign is delivered to only one segment. However, if I’ve got an email that hits two (or more birds) with one stone…aka one email delivered to multiple segments, this is where my chart gets wonky. I can’t break out the multiple segments while still looking at my chart over time. (Note: You can do this in a pivot table block, but charts are just way more impactful sometimes.) To get a better chart that does break these segments out, I’ll need a Summary Table, which is a nice way of saying I’ll need a junction table to break out this

Greetings! We are managing a system of ferry transportation routes and require an Airtable expert to build out the reservation interface for us. Details more easily provided via a Zoom meeting where I could walk you through the base we have built and describe our needs. Should be relatively straight forward for an expert. Looking for quick turnaround. Many thanks, Chris Ritter Innovation Arts & Entertainment

Hi, We are looking for some help in three areas: Help translate data in a grid view into a matrix table that summarizes some of the grid data. Automatically add new orders to a reporting field for use in a page designer report. Creating a formula to automatically break down numeric values into specific columns based on a tag in a column. Please reach out to tony@innovationae.com with estimates for this type of work! Thanks, Tony

Using this script with the Content Calendar Template, you will be able to do some common tasks with managing your content calendar. This script will enhance the Content Calendar Base by providing 2 common tasks: Create new Content - this easier approach to creating new content makes it quick to get content added to your table Publish Content - once you have created content, you want to publish it quickly to multiple platforms. This makes it easy to track which platforms you are publishing it to (Twitter, Instagram, or Facebook) and automatically links it back to the primary content. NOTE: This does not actually publish to Social media platforms, it simply tracks where you have published the content to and how. No changes are required to be made, simply run script and select one of the two options. TEMPLATE TO INSTALL:

Something very often requested is the ability to extract the meta information of a base/table to be used for external use. Now, with the new scripting block, that information can be extracted and shared outside. Simply copy this code into a scripting block and run it. If you wish to publish to a 3rd party endpoint, simply modify the codebase. Full documentation provided inside the code. gist.github.com https://gist.github.com/on2air/ab32b4bb59d02d490be37e28d45daf92 On2Air: Meta Extraction Script /***** * Title: Post Meta Data * License: MIT * Author: Openside (Team behind On2Air

Hi , I am looking for a consultant in Israel , who can help me implement. Thanks , Netta +972-50-5564991 , netta@nettatravel.co.il

I’m looking for someone to help custom design an airtable database. I’m already using the product but want to take it to the next level. Please let me know if you can help. Phoebe

I would like to hire someone to write a script in google’s g-suite to replicate the actions performed by a Zapier task (as described in this post: Update Fields with Integrated Scripting Approach). I have a very simple use case, an existing Zapier task, as well as a simple explanation of what needs to be done, as follows: Every minute, run a script that looks for new records in Table 1 For each new record, identify existing record in Table 2 via linked field ID Update record in Table 2 with field value from new record in Table 1 Update record in Table 1 with status Reply with contact information and I’ll be in touch.

Hi Everyone. Beenform is a simple form backend product that enables you to setup working web forms that works with Airtable in just a couple minutes. With Beenform, you can hook up your static HTML form, with an endpoint that captures form submissions and creates an Airtable record. In addition to collecting submissions, you can enable User Authentication in beenform so that any form submission from your users, an automated email with their unique individual link will be sent to them, which they can always use to update only their individual records. All these changes are made in your Airtable base. Every Beenform form also includes automatic spam filtering, Google recaptcha support etc. We are still currently in beta, so it’s completely free. Let me know what you think. You can check it out here https://beenform.co . Thanks all :slight

Hello, I need help building a tool that does several things. I have an interior design business and I want to be able to input projected hours for each employee, by project. I want to be able to then see their bandwidth several months out. Secondly, I want to input these hourly projections by project, and create gaant charts by project, so I can track progress of each project, but hopefully all together in one place. Ideally, there is a place I can input project information, including which employees are on what project and about how many hours we think will be needed by project phase. Then I would love to be able to see this information in different views- calendar, by employee, and by project. The goal being that I can better plan for staffing needs, see when we will be busier and less busy, so that we can take on more or less work as we see fit.

Hi, we are in the midst of building a simple website and would like to include a form connect to airtable and a few customized fields on airtable. Would like to find someone who can help.

Hello everyone. We use Airtable for various things at Unly, and we have always been concerned by the inability to create scheduled backups that really fit our needs. Despite the fact Airtable has its own backups/restore feature, it didn’t fit our needs. And, because Airtable holds lots of business-sensitive data, it was a very big risk for us not to be in control of the backup&restore process. So, we built a tool that is designed to perform scheduled backups automatically, and deal with backups lifecycle (auto-removal, etc.). Today, we’re releasing this proprietary software as OSS under MIT license. GitHub

Hello, We have a very large Google Sheet document that we want to translate to Airtable for a better user experience for a sheet we will be releasing on VPN.com. Our Google Sheet has more than 400 columns and 600 rows, so you will need to know your way around prepping, working with and organizing large amounts of data. Most of the data has been scrubbed and formatted so your main responsibility will be bringing it to life from a navigation, linking, color, answer formatting, grouping and Airtable experience standpoint. In addition to this very large sheet, we have several slightly smaller sheets that we will need linked to our main Airtable base as well. I am looking for someone to help us with this very quickly as we are under a tight timeline. If you are a good fit, teammate and enjoyable to work with I can deliver a lot of ongoing work as well. Ideal Requirements Native En

I always wince when I see broad and sweeping claims that a tool can perform workflows. This is especially problematic in platforms that are not designed with an integrated state machine. Lacking this, we are all left to manage the state of any workflow process on our own. Many of you are nodding. Here’s a design I put together recently that provides a way for vendors to receive email notifications of opportunities to bid on projects and a complete workflow process that captures their bids. The red lines indicate the flow of the Quote Request Process which is a lights-out factory process - it just happens automatically as new records emerge in the Quote Request table. The green lines indicate the flow of the Request Response Process which is kicked off by a vendor respond

We are looking for someone to help create our project and product design planning structure using airtable. We know what we want, but don’t have time to do build it. I have built a flow diagram and have field items in a spreadsheet. It’s essentially a few base units with multiple tabs for data entry, cleverly linked to show scheduling and parts of the design process either in a Gantt chart or weighted in risk or priority. PM me and I can share documents to help someone quote for the work needed. Thanks! Will

hi, We are a small food processing company, I am trying to build a database around our production. We need to track all of our production from raw materiel to final product, keep track of inventory and packing material. Thank you. Eva María

Bit off more than I can chew! :joy: Small business needs invoicing software. There are 3 tiers of pricing (retail, wholesale, resale).

We are currently testing whether Airtable is a viable option for our business and have one issue that stops us moving forward with it. We are looking to find out how much it would cost to be able to have custom visibility in a table. When looking on the app on a phone we would require certain entries to hide columns depending on the input. The current hiding option doesn’t work as some entries within the same table may need that column visible. To confirm we are not currently using airtable, more looking at whether the development needed to make it work would be possible for our budget.

Hi, We have built a number of database tools to manage our workflow and sprint planning. We are looking for a consultant who can bring the tools together and create a unified view of the data. Thanks, Drew

Hello, We want to build an automated project management tool that will allow us to: Create project Track the timeline, completion… Forecast metrics Compute some metrics All the features are described in a document. Our estimated timeline for this is ~2.5 weeks with a week of testing. You can contact me using the following email: martial.chastel@newtonx.com Best,

looking for Airtable expert to redesign our workflow in Airtable. We are a travel company that is running most of our business in Airtable and would like up our game by using airtable more efficiently and taking advantage of the technology.

I’m new to Airtable and using the Commercial Real Estate Transaction template and want to customize it.

I need help. More time is spent on data entry, back-logging, and verifying work than my actual responsibilities. I’ve spent the last 3 months building a portal, through another company only to find out, it’s not as custom as promised and the project management is just a fancy to do list. $4,000 later and I’m back to square one. I’ve spent the last 2 days working different angles thru Jotform, Stacker and Google Docs and I’m finally at my wit’s end. After spending all this money on a disappointing portal it’ll be hard to justify more money out, but if someone is able to help at a decent price I’m willing. I’m either expecting to accomplish the impossible or mentally drained. Someone who has experience in construction or subcontractors would be great help. Even sharing a base and integration would be extremely helpful. Below is a list of a few things I’m looking for. A real Project Management system- based on workflows that keep employees on track, triggers a sequence base

Basic bases are in place, but I know they can do more. I have a few projects in mind: (1) I have a form set up for third-party questions/responses. I need to be able to forward those responses to my client for review and the client be able to click a checkbox to approve, which then comes back to us. (2) I have different client bases to track new projects for each. I would like new projects automatically entered into on comprehensive base archive of all projects. …there could be more.

Hello, I am looking for a consultant who can develop our work spaces for us. I have tried to figure it out on my own but I have not been successful at it.