Builders Board

It’s a quiet Saturday in my office and while I should be working on a client’s project, I found myself intrigued reading the various responses to Airtable customer requests for help from consultants. Some of them had me chuckling and others were simply boring. A few even triggered yawns from time-to-time despite being hopped up on Black Rifle Coffee. This post is yet another tell, and no show. Just a few tips from an old dude who’s written about 41.8 million lines of code. I’m an analytics guy, so yeah - I pretty much know how many lines of code I’ve written since 1978. Being this old and this “seasoned” in the fine art of crafting software, I get away with saying stuff that might come off as crude or insensitive. But, my candour might also help you avoid some blind spots. Feel free to push back on these highly opinionated perspectives and know that if these were considered crimes, I would be on death row. :winking_face: That said, here are some tips to pick winners - both consultant

Hello All, I am looking for a good article that explains what a Airtable base is? When I look at https://airtable.com/pricing Records per Base seems to be the main difference between Free, Plus and Pro? That leads to the question, what is a Base?

I have a a database in two formats, a complete one and one for public viewing with some private information hidden. I have three forms related to the databases that also need to be embedded on a website. Need some help, or direction to a tutorial that will give me some info on how to accomplish this.

I currently have all of the components on separate basic programs that I would like to integrate on AirTable, I understand somewhat but know that this platform is quite powerful if used correctly and need someone expert in all of the nuances in order to set up form the beginning in the correct way to maximize usage. We are a Tailor-Made private Travel Consultancy and also do some online web corporate events. Currently located in California during this surreal period of time but usually based in Florence Italy. Please contact me jennifer@tuscanturtle.com Grazie mille! Jennifer

Hi Is it possible to add a condition to trigger an action (like hyperlink redirection, e-mail, …) after changing the data from a specific field? Cheers, Marcelo

Bigwig.com.au is an Australian financial services business. We are seeking a developer with airtable API experience to help build our website which uses an airtable database as the back end.

Hello all, I’m looking to hire a good consultant that can put together a comprehensive Airtable with various bases. Some of these bases will need Zapier integration, with apps such as Typeform, Mailchimp etc. This will initially be a setup type consultancy, but then some ongoing ‘housekeeping’ with the project. Please contact me on sam@cholera.me Thanks

Just posted a 7 Wonders scoring app built in Airtable to Airtable Universe. Airtable 7 Wonders Scoring App - Airtable Universe This base is for those 7 Wonders fans who are looking for a scoring solution that can account for ALL the expansions (including the most recent, Armada)! ​ ... Let me know if you have any feedback! Thanks to @bdelanghe for helping with the scoring algorithms.

Good day. We are using a 3rd party ordering system for school meals and need to print physical vouchers (of the pre-ordered items) to distribute to children which they then in turn use to redeem food. Thank you in advance.

Looking for someone to help us build out a workspace for my race event. Basically this is how it breaks down: 1,500 Racers …making up 450 Teams… …across 80 different classes… …over two days of racing… …with 6 total races… …on 3 different race courses… There are many different components to the event like merchandising, ticketing, vendors/exhibitors, staffing, etc… We are looking to organize things under one roof and utilize AirTable to its full potential, just need some help getting things set up.

EdTech Start-up. While we can spend the time building everything ourself… We are looking for someone to create it quicker and more efficiently than we could - saving time and money down the line. We are also running into problems with users (we will have many ICs that need to view a workflow table AND only collaborate on it IF they choose- without admin permission or approval). We would prefer not paying individual user fees connected with Airtable for everyone who’s sitting around - maybe deciding to collaborate… so need to find a workaround. There will be a lot of little things like this where we could use an expert! If you are available for hire on Upwork - even better!

Hello, I’d like an airtable capable of the following things: Managing inventory (including batch tracking) Building Bill Of Materials from inventory Run Production Jobs of the BOM at different quantities and costing If you know what I’m talking about above: a. have you built something similar / is it possible? b. is there a template I could use or adjust to needs? c. could you build me something? Thanks! Courtenay

Hi there, I’m looking to work with a developer to create a custom block to the following specification: Sketch Multiple Table Charts — Artboard Shared on Sketch by Russell Bishop Display a single bar chart with two tables as the source of the data Assume that both X Axis and Y Axis from different tables are the same data type Ground the bars by their origin table. Assume SUM as the aggregator of the data when grouped by an axis (to keep things simple) You can read further information here: Charts displaying data from multiple Tables Product Suggestions I am often in a position where I would like to compare data from two tables. Say for example, one table was my Estimations table, where I have many entries where I forecasted the result of something. In a separate table, I have my Records, where I recorded the results of entries. If I wanted to map those those table together, there is no way to

Are you an Airtable consultant that is familiar with Javascript and / or React? Please sign up for scripting, blocks and code-related updates! We’d love to keep you abreast of any exciting technical partnership opportunities. Sign up here: https://airtable.com/shrAfXexy3R2MjrdB

Help with Airtable, Gannt, Dbas, Project management & pricing

Hi everybody, I use Airtable as a CRM to track all my contacts and interactions. It is pretty neat that I am able to open up a contact in expanded view and view a list of interactions I had with this contact. However, I had to manually click into each individual interaction to view the information I needed. The entity-relationship is as follows: Each Contact may have multiple Interaction Each Interaction has 4 key fields namely Date, Method, Notes, Next Steps My objective was to put all my interactions for each contact into a single column for quick viewing. To set this up, I did the following steps: In the Interactions table, create a new column named “Interaction Summary” with ‘Formula’ as the column type. Create your formula as follows and customise according to your needs: Formula: “\n” & CONCATENATE("[",DATETIME_FORMAT({Date},“DDMMYY”),"-",{Method},"]") & “\n” & “=== Notes ===”& “\n” & {Notes} & “\n=== Next Steps ===” & {Next Steps} & “\n” T

I have set up two separate databases in Airtable. Oe is a Grant Tracker and the other is a Fundraising database. I have done most of the necessary work. What I need now is to set up reminders in Airtable (I need to know HOW to do it as well) and a few calculated fields (simple ones). I MIGHT also want to connect to a currency conversion app. Please email me your CV and your rates. Thank you Rachel

Just inherited a photo business and with all the craziness and my day job, haven’t got much time to build a much needed system out, so looking for someone that can help with the following project System contains interconnected tables for: photos inventory of different sizes stores where they are sold (with different terms / some multi-location companies) inventory in each store contact list for store owners / workers & individuals orders from each store orders from individuals print queue to produce photos It’s relative ‘simple’ but time I don’t have… Essentially the business prints photos that are sold in local stores, also (very limited number of photos are) ordered through a website. Need to track each store’s inventory as the photos are (mostly) sold on consignment (though some are bought outright), so that my wife can easily go to each store, understand what’s been sold so what’s owed, and we can understand popularity of each photo so we can print more for in house stock or in

If you’re like me, you like to catalog things. Like, perhaps, your movies. And you’re going to want to sort them by title. Which is no big deal… until you get to all of those movies that start with “The.” You don’t really want all of them in a lump in the T section, right? You’ve gotten spoiled by programs like iTunes that somehow ignore the word “The” when sorting. Thanks to Airtable’s formula columns and string-handling capabilities, you can achieve the same effect. Let’s say you’re storing your movie titles in the Name column. All you need to do is: Look at the first four characters of the title. If the first four characters are "The " - chop them off, then add “, The” to the end of the title. Otherwise, just return the title as is. This function: IF(LEFT(Name, 4) = "The ", RIGHT(Name, LEN(Name) - 4) & “, The”, Name) does just that. Sort on this column, and you’re all set. Hide the column if you don’t feel like looking at it. Be sure to look at the first four characte

I believe that I have a somewhat unique use case scenario. I have successfully migrated one key piece of my operation from spreadsheets into AirTable, and need to solve a couple of additional issues before this AirTable-based approach achieves “minimum viable function” status. I think that these missing pieces are feasible, but I lack the expertise to structure a clean solution. In 15-minutes (or less), on a ZOOM session, I can narrate a quick tour of my AirTable base, and outline the functions that I need help building. If you are interested in receiving this briefing and discussing this consulting opportunity, just let me know.

Hi, We are a Creative Agency and Production company moving to Airtable to manage a vast database of freelancers and connecting that master database to project resourcing tables. Additionally, I’d like to track the projects they’ve worked on and even link out to those assets. I currently have some version of this but need a pro to get it dialed in so I can get back to my job. We’re based in Los Angeles so the same time zone is helpful but not necessary. Please message me and provide your rate. I’ll be evaluating respondents on Monday and looking to start this project next week. _Mat

Hi All We are trying to find valuable consultants who can support us achieve this, the following is the multiple processes which we are wanting to set up, (We can also use embed the view in our role-based portal framework) 1)Quarantine management base 14days quarantine timer and google map integration for showing them live so as to ensure monitoring that they do not move out of home quarantine A notification alert if they move out of the quarantine zone Quarantine citizen to upload selfies 4 times a day (based on a conditional formula), along with sms reminder if they fail to do so Request a checkup submission of family/friend if he/she had met them pre-quarantine stage Request medical attention submission if feeling not well follow a routine provided for the day via Callender etc watch youtube videos etc SMS Alerts if selfies are not submitted on time along with tracking/time view block with sms apis (I have got the early access of embedding block views so this can happen) 2)Quaran

For anyone more knowledgable than myself with Airtable I would hope this is considered a quick project. I’m on a time crunch so while I absolutely would love to learn Airtable I’d like to get this done within a matter of hours. I have a grading rubric of 20 students. There are 20 rubric elements each that can be scored 1-5 totaling 100 points. I would like to put the students in a drop down menu so that when selected the scores of that particular student display under neath the drop down menu and also add the scores up. Any ideas? Thanks!

I’m in the market for building relationships with consultants that can help me with Air table. Please email me at blaw@dallasjanitorialservices.com if you are interested. Bill Law Dallas Janitorial Services

With all the live-streaming meetings that my family currently has, I wanted a one week rotating calendar, where I could enter all the events for a week and the events would always show up for the current week indefinitely, without creating any new records. Then everyone could subscribe to the shared calendar in their favorite calendar app. Here is a simplified version of the base that I created. Airtable Templates Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. This base lets you create a rotating one week calendar of activities. Enter your activities, select the day of week for each activity, and enter the start and end times. Formulas will calculate the dates for the current week so you can see the activities on in a calendar view and subscribe to the calendar in your favorite calendar app. When you view the calenda