Builders Board

For anyone interested in Airtable scripting, I’ve added a few new posts to my blog: 3 ways to loop Getting the unique values for a field Creating a record Creating many records Enjoy!

To All The Volunteers: I would like to give a shoutout and a thank you to all the volunteers that go above and beyond, to help the Airtable members. Even with your busy lives, you still manage to find time to help. I, for one, am grateful for the many times that I received such great help. Thank you, Mary Kay

Hi, we are a venture capital firm and are looking for an Airtable consultant / developer who can help us develop a custom tool to easily and visually track upcoming events / catalysts for our portfolio companies. Baseline needs include an interface for inputting events, a Gantt chart visual summary output, and automatic reminder function. Bonus if we can figure out a way to integrate info like stock price / market cap from public sources. Please email me if you think you can help! Thanks kchu@fprimecapital.com

Hello, Im looking for someone show me how I can stack rollups from multiple tables into 1 summary table. Would like to be able to do this myself… but will be happy to pay for the tutorial For example (this is abbreviated) Table 1 … Has a rows for every day. Column 1… is Unique Page Views… Column 2 is Leads that came from the page views… Column 3 is a formula that calculates the conversion rate Table 2 & 3… Same thing I’d to create a table that has a row that summaries the sums of the values of each table … with each ROW being a table So Table 1 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Table 2 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Table 3 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Let me know if you can help or have any questions

Hey, it’s Andrew the Founder & CEO of SportsForce a National College Athletic Recruiting company. We are a fast-growing sports company that is ready to dramatically expand our business and improve our operational efficiencies. We are seeking an experienced AirTable expert to assist with our integration and implementation of AirTable, Zapier, InfusionSoft (CRM), Google Sheets, Google Suite, and More. We foresee this being an ongoing project, not a short term engagement. We have put together a video overview to help you clearly understand our current goals, a few example manual workflows, and our software stack before considering the project. This is available upon request for great potential partners. We have organized documented workflows for a large majority of our business including video tutorials for many processes already. If you are up for an exciting challenge! Please comment here on why this project int

We would like to be able to see the capacity of teams at any given time based on current workload and future projections. I don’t want to be too prescriptive, but we have data at two periods within the lifecycle of a projects. In the beginning we have forecasted estimates of how long it will take and known future capacity - we would like to see if we need to hire for future time frame Once a project gets into scheduling - we have a decent view of capacity, but it would be great to do some rollup and reporting of that data.

Hi! I am building a digital bullet journal for my personal use and would like to hire a coach/consultant that could help me. I saw templates but I would like to have some tailored/complex features and I tried to do them myself but it takes a lot of time to even understand the right question/point of view, so I would be grateful if someone could coach me through it and potentially also delegate full parts of it and save a lot of time. Is someone interested? Thanks, and looking forward, Have a nice day, Giulia

Hoping to get some insight into how to build an airtable base. Context: Our business development department is collecting information internally on prospective vendors. They’ll then input the information into airtable with the expectation that all documentation can be outputted into 1 seamless “packet” of information taking all documentation from airtable. Here are the requirements of the base: 100+ vendors 3 Phases of document / conversation completion. (Ex: In Phase 1, we must collect the Brand Analysis document, and have a “Top to Top” conversation. Each Brand Analysis document and Top to Top conversation will be the same, but the responses will be unique for each vendor. There is a chance that the Brand Analysis document (for example) may live in Airtable, or may be an excel document. My fear is that if the information is standardized (even captured in a form) it’ll mean we must have a table for each conversation/document (brand analysis, top

Hi all, Been using Airtable since 2018 and keep discovering awesome things everyday. One of my other ventures is building apps with no code web database tools. One of the new Airtable tools I found recently is a service called table2site (posted here before) which allows you to build websites using Airtable as your CMS. I built a site called NoCodeStudio and I’m really happy with how it turned out. Right now it’s focused mainly on Knack and Tadabase, and web design tools, but I’m planning to add Airtable resources as well. I’ll just stick this here to get it out of the way… NoCodeStudio is a community oriented collection of resources, tools, tutorials, builders, and more - specifically for no-code web database apps like Knack and Tadabase. Visitors can also submit new resources via an Airtable form. Thanks for checking it out - https://nocodestud.io And don’t forget to look a

I’m looking at learning more about Airtable and using it for my small business. This platform seems promising however a sales rep from another company (Quick Base) had pointed out the following limitations of Airtable. Airtable Limitations (according to a Quick Base rep) Limited Data Set Support: Airtable has a data limit of 50,000 records (rows) that organizations can quickly outgrow. Basic User Permissions Means Weak Data Security: Airtable has a basic user permissions security model that allows anyone invited to a workspace to view all of the info in that workspace. In addition, anyone needing to add or modify records requires Editor access which includes the ability to change and delete tables and views that may be needed by other users Lack of Reporting: Airtable lacks the ability to create reports that can be shared with management and others. Viewing tables

I’ve seen a few posts in recent weeks from people asking about how to get started with Airtable scripts (e.g. here and here). I think people are, rightly, seeing the scripting block as a powerful piece of functionality and for non-coders it can be a struggle to know where to start (I know from bitter experience!). It is all there on MDN, but even the first sentence is putting up barriers: ==== JavaScript ( JS ) is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions. =

With the recent launch of the Scripting Block, we’ve been excited to see all the handy things created with it (and cool to say that @openside won a contest with this nifty script also!). So we made a central resource to host ALL the user-created scripts (code + description + source) for the scripting block and put it here. It had to be done. :woman_mechanic: Here are a few screenshots: You were wishing for a central place to find all the script-block goodness, admit it. :slightly_smiling_face:

Hello all, I’m looking for help on a particular project. It’s a visual directory of people/things/activities/relationships specific to a particular industry. I have a base in Airtable with tables setup… The 4 main tables are as follows: Person Company Project Relationship The idea is those 3 main entities (Person/Company/Project) all have relationships to each other… And that those relationships also carry data themselves. For example… Bill Gates (person) has a relationship to Microsoft (company)… but we also want to know the time range that relationship was valid (from, til), as well as the nature of the relationship (e.g. CEO). What I want is for this data to be available on a web portal with the ability to search the database and make queries. The queries could be simple: (e.g. “Show me all PEOPLE who work for MICROSOFT”), or they could be more compl

Hello AT community of super smart consultants, I have been using an AT database for about two years now. Over the years, we’ve added, adjusted, and evolved it to what it is today. And what it is today is good, but in my gut I feel it can be better. Coming from the standpoint of ‘I don’t know what I don’t know’, I’m looking for someone to evaluate what I have, understand my business, and consult on ALL that can be possible using all available features of AT. Thank you for your help! Vita

I have an Airtable base, I have a website. How can I hook them together so that website visitors can search the databases?

I have a pretty simple database I use to make repair tickets. I receive the repair request via a form submission on our site and import it via Zapier. When I send each record field to the different shops to handle the repair, it takes about 4 pages of paper to print out. I essentially need to be able to reduce the amount of spacing between listed fields so it we can reduce the number of pages each shop has to print out. Anybody got experience with this? Thanks, Dominic

Hey all, So I am new here and totally new to word of airtable and databases, my knowledge ends at 10th grade excel. We are a bakery in Berlin, Germany trying to readjust to life after Corona. I came across Airtable but am too busy trying to run a bakery rather than trying to learn a whole new software. We are trying to get a database together, in which we can easily input new ingredients/suppliers/costings/recipes and link to our sales to manage our overhead better. Here is a list of things I am after. Ingredients and recipe costings (we reuse ingredients in our kitchen, bakery, retail space and online retail space, focus on zero waste) Easy recipe and costing generation forms intergration with pos (we use orderbird, cybake and shopify currently) production planning shift planning financial reporting. All this is just the start, we are seperating our wholesale department into a seperate log

I either need to add a new field and link it appropriately or set it up as a new table and link it accordingly. Super quick turnaround preferred.

We are an alternative energy finance company in Dallas, TX that is reviewing Airtable to handle our (simple for now) database needs. In the short run I expect 1 base with 4-6 tables that focus on definable assets (with lat/lon coordinates), their links to a geographic area (counties or sections thereof), their owners, and then any contacts/CRM type stuff. I have built a prototype/sample myself, but am having trouble automating the links (writing the script defeated me for now). Could use immediate help for deciding, and this could turn into an ongoing gig. Local helpful (Dallas) but not required.

I use tags to highlight some characteristics of records in my table. In this dataset I want to highlight whenever I have a “Stale Deal” and/or a “New Customer.” I want to use multi-select options because they’re easy to filter and chart. However, I don’t want to manually tag each select option, because there’s a formulaic way I can assess these characteristics: ‘New Customer’ = Deal Count is one ‘Stale Deal’ = Time since last inquiry is > 30 days. I’ve tried to do this via a formula and isn’t pretty to write, read, filter, or chart by. So, why not replace that formula with a script? Works like a charm: Link to the base here. Happy Scripting! /* Calculations: 'New Customer' = Deal Count == 1 'Stale Deal' = Times Since Last Inquiry > 30 */ // Loa

Hi everyone, I’ve a request, my situation is : I have a table with my customers database with name, phone number, etc. I attribute to each of them a partner. And I have a table for each partner. So I would like to know if it’s possible to put each customers in the right table of the corresponding partner automatically (using only the customer’s table) and how? Thanks a lot in advance!

When a record has multiple date fields, sometimes you’d like to know which date is the earliest. In the below example, each record is a social post that has different live dates for different channels. I’d like to know the earliest live date across all three channels. I could do this in a formula, but the ‘LIVE DATE’ field is also used by other teams, so I’d rather calculate the date with the below script (plus the awesome batchAnd script to do this for more than 50 records): Example Base Here // 🌸🌸 👇Add all the date fields you need here 👇 🌸🌸 let fields = ['Instagram Date','IG Stories Date','Facebook Date','LIVE DATE'] // Let Airtable know which table and views records you want to use let t

Basically I want to use airtable to integrate the 2 worksheets of data (education business, data comprises student registration, payment, exam result and funding administration). Want to create a single data source for everyone in my company, and use airtable to display and data in a meaningful and productive way instead of relying on column view.

I’m not sure if what I’m trying to do is even possible with Airtable. But it needs to be as user friendly as possible because it will be used by employees of my company. I’m a service based company and I’ve been using Airtable to track work for various customers. Requirment 1 - Workorder To be able to fill out a form with relatively simple user experience. Ability to enter a lot of data into the form with a minimal interface (ability to hide fields until they are required would be ideal). Also data in the form must link to other tables and grab data from those tables. Also the form must be able to collect signatures. All on mobile. I tried out Fulcrum on a recommendation and it has everything I need for the form side, but not the data management or report side. So if you’re familiar with Fulcrum you may know what i have in mind. Currently all data is entered directly into the table and is a clunky experience at best. It’s embarrassing trying to teach pe

Busco experto en crear plantillas de Airtable para tareas complejas de plantillas ya creadas por mi, pero que por conocimiento aún no las puedo completar. Por favor los interesados tomen contacto en Español comigo. Saludos