Builders Board

Hi Airtable community! I’m looking to hire someone that specializes in Airtable formulas. I have looked and messaged some consultants here to no avail → Find the right Airtable Consultant To be more specific, I would like some advice on potential formulas, strengthening and adding on to specific formulas that are currently working. Also someone who has skills in advanced linking and synced views/tables would also be of great help. I reside in Canada so a consultant who lives in North America would be preferable. Thanks a lot! Valentino

I put together a bunch of hotkeys to make my own life easier, and figured I might as well clean it up and post it in case any one else found them useful!This all works via a Tampermonkey script, and installation instructions can be found belowDemoChange Log7 Oct 2022 Updated to handle new field menu items 24 Mar 2023 Updated to handle new field option layout Firefox now uses MetaLeft; script updated to use it 28 Mar 2023 Updated to handle new formula field HTML 29 June 2024 Updated to handle new create button selector ID Shortcut List⌘/Left Alt + ⇧ Left Shift + ' Add a new field ⌘/Left Alt + ⇧ Right Shift Customize Field modal - Click “Save” ⌘/Left Alt + ' Next field header ⌘/Left Alt + ; Previous field header s Next field menu option w Previous field menu option ⌘/Left Alt + ↵ Enter “Click” selected field menu option ⌘/Left Alt + ↵ Enter Open field menu for selected field Escape Deselect ⌘/Left Alt + ⇧ Left Shift + 1 Select f

I have a financial reporting and budgeting projections base that I want to build out and make more robust and do some fancy things withI have a crew hours base that I want to use to funnel information into existing excel template to crew invoices and send to payroll.These bases are for TV production, however not funded by a TV studio - they are my personal bases I use to automate many of the daily tasks I need to do as a production coordinator. Looking for consultants with experience with film and tv production work with airtable.

We sell internet data plans, customers often need technical support. We need a way to handle support tickets, preferably within Airtable so we can see all of the relevant details for each customers. Ideally, customers would start with a form on the site that they use, that will find them and add a ticket to Airtable. We would like to be able to see all relevant customer detail. We want to be able to tag the ticket with issues, make comments, we want to be able to mark as closed and so on, any takers or suggestions on how to accomplish this?

Hi there I’ve built an extension for airtable (Charts Like https://convertkit.baremetrics.com ) I might launch it to the marketplace if you are interested :slightly_smiling_face: )

Seeking an AirTable Consultant To Help Build Out A CRM Like system for our Marketplace Business. We need the ability to Track Users GloballyTrack Transactions GloballyTrack TRansactions by Date Track Users By RegionTrack Transactions By RegionTrack TRansactions by Date By Region

Hi there. I am looking to hire someone who can help me with my project. Ideally I want someone that will sit with me and talk me through the processes so I can learn at the same time. I already have some automations working with me Webflow site using zapier so i’m not a complete novice, I’m just quite time poor at the moment and need to get this project live quickly. The main objective is to get data moving to and from Webflow and automate an much as I can using airtable. You can check the website here - https://www.virtualrallychampionship.com/ This is a passion project so I don’t have a huge budget. I imagine we could get everything done in half a day so I can find budget for half a day of a professional’s time. Thanks,Steve

Movie Analytics [23k+ Movies] - Airtable Universe Hello Community, I have been working with Airtable Designer for a while. With elements and rearrangeable surface area possibilities are endless to drive the use-case. I made some effort into extracting popular movies. With Zapier, Script Block, Triggers and Automation - here is my small attempt to giveback. Checkout the interface and try putting various constraints. You can do many things such as: Avg movie length of hindi movies in 90’s Marvel Vs DC Comparison Avg profit in % made by movie Which categories are more successful (Action vs Drama) Does spending more money increase the rating Correlation between revenue and rating Revenue, Profit, Budget comparisons by different parameters and much more!! Updated Date field, more graphs and comparison view (compare your filter side by side) - are some of the new feature coming soon. Feel free to bookmark and check this out. Movie Analytics [23k+ Movies] - Airtable Universe How can I publi

Add the “User CSS” chrome extension (free) and then paste in the following: /* add extra margin to top*/ /* so filter popup does not hide first record*/ #viewContainer { margin-top:120px; } /* hide annoying view popups*/ div[id$=“tooltip”].dark{ display:none; } /* restrict height of long text fields in form view*/ /* and add scroll bar */ .contentEditableTextbox{ max-height:200px; overflow-y:auto; }

Hi Everybody! I’ve started a new series of YouTube tutorials and thought that some of you might find this one interesting. Automations have opened up so many cool possibilities in Airtable!

Hello!Default formula fields too small? Hate using your mouse?Good news! Here’s a Tampermonkey script thatMakes the formula input field larger by default (Customizable) Allows you to set a hotkeys to: Save the field (e.g. Hitting Left Control + Right Shift will save the field) instead of clicking the Save button manually Add a new field DetailsWe can customize the height and width of the input field by modifying the following lines:let formulaFieldHeight = "350px"let formulaFieldWidth = "350px"And we can customize hotkeys to automatically hit the Save button by modifying these lines. (I used this site to get the keycodes such as ControlLeft, OSLeft etc)let key1 = "ControlLeft"let key2 = "ShiftRight"let addFieldKey1 = "OSLeft"let addFieldKey2 = "Quote"InstallationTo install it you’ll need to install Tampermonkey into your browser and just paste in the code belowNotesI think I’ve ironed out all the kinks, but one never really knows. If you encounter any bugs please feel free to message

You can view or edit Google Docs, Google Sheets, or Google Slides files from Airtable with On2Air Forms.How to use the Google File Field in On2Air Forms for Airtable.

Made by a French Lego Master with reused pieces. The hole story and a picture of the artist here (sorry, this is in french)

TLDR 4 week accountability meetups to build automated CRM for myself Do hands-on assignment before each meetup During meetup on Zoom we discuss on our hands-on experiences and answer other’s questions $50 to join - which includes an expert Q&A to answer all our questions Hi everyone! I’m building automated CRM with Airtable. But I’m not that confident to push myself to finish it, so I’d like to organize a weekly accountability group with other B2B company sales persons or marketers where Do hands-on practices in the articles Meet on Zoom weekly for an hour Discuss on the obstacles and ask and answer questions to each other Every week participants need to do hands-on practices on one’s own. Then, during the meetup, we can share and discuss on our experiences and ask & answer to each other. I’ll collect $50 for each person who joins, and use part of that money to recruit an expert who can answer our questions if we have unanswered ones after meeting. Any one who wants to jo

You have all your data in Airtable and now you need to summarize and calculate all the information.Reporting on business information is a vital part of company operations. “How do I create a report in Airtable?” is one of the common questions we see from Airtable users.First, the answer is, “Yes, you can create reports!” You can create summary reports from your Airtable data, whether you need to summarize income, projects, sales, or information such as employee vacation hours or inventory totals.In this tutorial, you’ll learn how to create summary reports in Airtable, how to automate record links to a report, and how to create a dashboard to showcase the information for others.See the full tutorial here:How to Create a Summary Report in Airtable If you need automated documents for your reports, check out On2Air Docs, an app to automatically generate documents with your Airtable data. To allow others to view or edit documents or any other data in Airtable, use On2Air Forms, an

I have been building out a database in Airtable to track the 199 countries of the world in regards to these kind of data points: strength of passport (visa free countries you can visit, whether you can go visa free to USA, Schengen countries and other top destinations, etc) plus a good number of other metrics. In each country record, I have started entering how each passport is treated in every other country. I’d like to scrape this data from wikipedia entries such as this: *Visa requirements for Slovak citizens - Wikipedia) and have it merged into my airtable. The end result is being able to pick any country and see the options for travel in some kind of simplified table or map. The other data consideration is how visa waivers work i.e. you get X number of days to start and can extend for another Y days for a total of Z days per year. I’d like to get all this data built out so that I can use it for different kinds of tools (picking a country by rankings for a quiz, designing travel or

3/17/2020 Edit: updated the the ‘Create’ case to return the recordId's of the created records, rather than just a count of created records. Thanks @kuovonne for the idea. The updateRecordsAsync(), createRecordsAsync(), and deleteRecordsAsync() functions that Airtable provides in the Scripting Block only allow the action to perform on 50 records at a time at most. While Airtable does provide a helpful example of how to run a loop that batches a set of records greater than 50 for processing in the “Find & Replace” example of the Scripting Block documentation… // Only up to 50 updates are allowed at one time, so do it in batches while (updates.length > 0) { await table.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); } I thought it might be nice to have a single function to drop into any script that would handle this for me, regardless of the action I want to take on the records. (Admittedly, it would be nice if this was in the Scripting Block’s SDK b

If you are looking to pull insights from your Airtable data, try connecting your Airtable base to Metabase to easily build interactive graphs and dashboards. Metabase is an open source BI tool where you can easily summarize and visualize your data. You can connect Airtable to Metabase using a tool I helped build, Sync Inc. We’ve been blown away by the kinds of dashboards people are building - so we wrote up a tutorial that walks through how to do it: docs.syncinc.so Metabase | Sync Inc Sync Inc replicates Airtable to a Postgres database, giving you the best of both worlds. Also - shout out to @Paul_Coates who showed us how you can then embed dashboards like these back in Airtable using the Embed app. Then your team will have all the information they need without ever leaving Airtable. Hope you find this useful :slightly_smiling_face:

https://www.askdottar.org Hello folks, I am Joseph, creator of The DOTTAR Project or The Database of Technology Training and Resources Project, an online database that is ad-free, with an easy to use interface. It is an online resource for sharing other resources. On DOTTAR a user can contribute to the project by adding a new resource, they can also use the project to search for resources in various categories, from online courses, micro degrees, or content creators and videos, to offline resources like books, textbooks, lecture notes, or colleges and local universities. It is a resource of resources. DOTTAR is built on Airtable and Softr and I am truly pleased with how the project turned out, if you have any feedback please let me know. :slightly_smiling_face: Sincerely, Joseph, DOTTAR, and the rest of the data monsters on the DOTTAR Project.

We are a social impact driven consortium of international development consultants, and we are looking for the help of an advanced Airtable user, ideally one who is an independent consultant or aligned to our mission. As a consortium we are operated by members for members. We have an established base that we use for about 50% of what we want to use it for, starting with membership management, through sales/opportunity pipeline tracking, project management and sub-contract management. To facilitate peer updating we currently utilise Stacker to enable members to see and edit some of our Airtable data. The base works fine, but as we have grown it needs to be optimised to improve linkages between tables and probably eventually restructured to enable it to serve us better. We want to build a relationship with an independent consultant by starting small and expanding our ambitions with Airtable as our internal data management teams capacity to work with AT grows. We have two small and discret

In my last gig, my team used Airtable extensively as our database. Our content editors wanted to collect user testimonials in Airtable, where we managed all of our existing data. If you or your team has this kind of setup, Open Testimonials is perfect for you. Open Testimonials stands out from the plethora of testimonial collection SAAS’s in a couple of ways: :heart: 100% Open Source (self-hosting coming soon!) :heart: Small bundle size (https://bundlephobia.com/package… reports 3kb min + gzipped) - this means that Open Testimonials won’t slow your website down! :heart: Server-side rendering (works with React, comment other frameworks you’d like to see) Try it out at https://opentestimonials.com! For a limited time, you can get a lifetime plan for a $150, which includes unlimited testimonials on unlimited websites, and personal support. Regardless, the free plan is very generous. If you have any questions (or need help setting anything up), please DM me on Twitter (or Reddit!) @l

Hi All, I hope this meets you well, I need an expert in Google API. We would like to have a professional paid service to automate and generate a TV grid in google sheets. So we have a specific structure in a weekly bases with time slots vertical and date horizontal. We have the episodes with the time slot and release date available in Airtable. We want a script to place those data in the right cell for each episode, I will share a snapshot of the grid and a snapshot of how we have it in Airtable . for your note : we have built something like this Airtable → On2air → Google Sheets a script with Json will read from the episodic view and place that to the right cell, and generate in PDF. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. Let’s book a meeting and discuss timeline a

I wanted to share what I figured out looking for a way to run an automation at a scheduled time. First, create a helper table named Automation Trigger with 3 columns: Name (type: Single line text) Run At (type: Date, with time field included) Record (type: Formula, expression: RECORD_ID()) For each automation you want to schedule: Add a row with a unique descriptive name Add a view with a filter matching only the one record added above (Name is …) Add an automation: Choose trigger: When record updated Select table: Automation Trigger Select view: the one matching your automation intent Select the Run At field. Run test Add an action according to your needs Finally, the scheduling piece. You’ll need Integromat or Zapier. Zapier allows to schedule a task only at a selected hour. Whereas Integromat is much more flexible. For example, you can schedule an action at regular intervals. Connect Integromat to your Airtable account Select Update a record action Select your base and t

Hello everyone,I’m looking to build a matching engine that will compare records across two different tables (that have the same structured fields) and identify matches i.e. when there is a complete or partial overlap of the specified fields. The objective is to create relationships between records that are similar and then display these on a Softr page (similar to Amazon’s widget “customers who bought this item also looked at this”).Who has experience and short-term availability to support me? Please reach out directly.

Do you have an Airtable workspace with multiple important company bases? You can backup up multiple Airtable bases at once with On2Air Backups - without having to add the On2Air Backups extension to every single base. Every On2Air Backups plan (except Starter) can back up multiple Airtable bases. Check out this 3 minute video on how to create a Backup Project :small_red_triangle_down: You can also read our knowledgebase article: How to Back Up Multiple Airtable Bases with a Backups Project