Builders Board

Hello Airtable community! I’ve read a few posts here about the calendar view iCal link taking up to 48 hours to update on Google calendar/Outlook, more than enough to break a workflow. After a few hours, I stumbled on a GitHub repository that forces Google to resync the Cal link, either manually or at a set interval. I did a few tests and it’s working as intended, updating my calendar every 15 minutes. Please note that it’s a Google Apps Script, so will not work with any other calendaring platforms. The repository is located here: https://github.com/derekantrican/GAS-ICS-Sync. Instructions require very minor modifications on the user’s end but are very clear. I have no affiliation with this developer, but this script certainly solves a problem that I know many of you have had!

Hola! Tengo una base, y en una tabla tengo dos vistas, quiero que solo una puedan ver y editar todos los invitado, pero la segunda vista quiero que solo algunas personas lo puedan ver y editar. Las opciones de airtable en la versión PRO son: Todos pueden editar, o la vista solo para mi, o nadie. Yo quiero que un grupo de personas pueda verlo y editarlo y el resto de personas ya no puedan. Adjunto la siguiente imagen, aunque representa los permisos de un campo, me gustaría que eso se pudiera configurar por vista. (imagen representa la edición de algunas personas que yo puedo seleccionar)

Hey guys, I made some customizations for the new Airtable forum and figured I'd share them in case anyone else found them useful!You can turn off whatever features you don't want, and I've left comments in the code to help with figuring out what you can customize (e.g. customizing the unread topics to show up with red font or something)FeatureOriginalNewCustomization of Read vs Unread topic colors

Hi,I have a list of employees entering work, with start time, end time, number of hours, employee ID, etc. All day I try to come up with a sensible way to generate a list for a given employee, so that it can be quickly printed and signed later. I've tried with google sheets, google documents and it turns out that creating a list using make in each of these solutions is failing and complicated. Any ideas?

I've been scouring all threads, extensions, and templates for help with creating a base- and several threads I came across that had the same requests as me tended to come up with "hire an expert"My workflow consists of different phases:1. Inquiry2. Proposal/Research3. Booking/Follow-ups4. Planning5. Prep6. Week-Of Event7. Cleanup8. Follow UpEach phase has a bunch of different tasks. For example, the "Prep" stage has each of these tasks:Create Flower RecipeRent Van/TransportBook AccomodationsFinalize Hardgood CountsOrder materials for special mechanicsDigital MockupsFinal CallCreate TimelineSubmit Flower OrderPrep Hard GoodsAdjust Packing ListAll of these tasks in each phase need to be repeated for every event. And each of these tasks has a deadline range relative to each event. (submit flower order needs to be done between 21 and 45 days

I use airtable essentially to create daily schedules.These schedules are PDFS that i print from the layout extenionsi then upload the pdf to a seperate kanban view for employees on site to be able to go thru at start of day to know what they need to do.All of sudden, airtable has "forgotten" or corrupted all of the pdfs or images that were in the table.I can't upload anymore either. If I delete a corrupted file and try to reupload, it just reuploads a corrupted file that has a link to support center embedded if you try to open it as an attachment.This effects the way I run this business pretty critically unfortunately. Maybe this is the equivalent of a storage capactiy paywall?

We are an apparel development company and use Airtable extensively throughout our office. We are in need of a developer to help with the additional functionality of Airtable to even better suit our needs. If you are a qualified candidate please contact me at dlau@rideicon.com. Thank you.

Hi everyone, I just wanted to share a quick tip I use. I often see people use Zapier or miniExtensions to do this basic operation so it may be easier to do this way. I am using the Automation feature of Airtable to trigger when the record has a “pending URL” (that should be processed). When triggered, Airtable let’s you set the Attachment field type with an “URL” value and will automatically convert it. (tested for images and PDFs) Demo base available here Florian

[Note: As this process is a crucial part of a number of other Airtable routines — for instance, finding the latest/first/largest/smallest something of a group of somethings, or [seemingly] any method allowing the value of a field in one record to be used in a calculation performed from a different record — I find myself entering it increasingly frequently. To save my fingers and others’ patience, I’ve decided to create a post dedicated solely to the process I can later reference as needed. The following will create a link from every existing record in a given table (here called [Main]) to a single record in a second table (here called [Calc]). The creation of such a link between tables is a necessary first step for a number of Airtable routines. In [Main], define a new single-line text field called {Link to Calc}. Set the value of {Link to Calc}

Hi guys, I need some suggestions in a course to learn more about airtable. I need an special focus on forms, formulas and interfaces

Hey ATCF Community! If you want to securely connect your entire database / warehouse from Airtable, we built Bracket for exactly that (https://www.usebracket.com/)! With Bracket, any change in your backend data will be reflected in Airtable, and any change in Airtable will be reflected in your database (e.g. Postgres, Mongo, Snowflake) – or you can sync data in one direction Why did we build this? Because Airtable made databases accessible to non-technical people, but it can’t function as a true backend to a company. With Bracket, you can turn Airtable into a UI for your database to get the scalability of a database with the amazing user experience that Airtable offers. See how it works here p.s. If you know SQL, you can even set up SQL statement logic between the datab

I’ve been playing around CSS selector on the Web Clipper Block and created a Clipper that automatically extracts information from a LinkedIn using the CSS selector. This could be useful for recruiters, sales reps, or people just building a social network. Here’s my full write up: https://www.notion.so/Building-a-LinkedIn-Scrapper-on-Airtable-af052e46f3454d40909990d75fbdfde8

Simple sales db, inflow from jotform. Need to add several messaging options to create ready terminals for sales team. Texting, email, Whatsapp, maybe direct calling (optional).

Hello Everyone! I’ve been struggling to count the number of times a field is changed in airtable. For instance, I have a bug tracker table and wanted to control how many times the “status” field is set to “Missing Information”. This is important for process control and have a better SLA with our customers. I think my solution will work for your similars use cases. My solution is: Create a single line text field to receive strings. I named it "Missing Information Reg.; Create an automation that tracks when the “Status” field is changed to “Missing Information” Make the automation update the “Missing Information Reg.” 3.1 Configure in “Fields” as “Dynamic” and insert the field “Missing Information Reg” and then add a single character, like “1” or dash or whatever you like, as long it’s a single character. That Automation will then add 1 character every time the “status” field changes to “Missing Information” and it wil

Hey all! Wanted to keep using Airtable to easily store images for my projects, so I built a service that automatically uploads images/attachments to a CDN, and creates stable URLs that my website can then use. Check it out here: https://aircdn.io It’s has complete compatibility with Airtable’s API, so all it takes is to switch api.airtable.com to api.aircdn.io in your application code. As a bonus, Air CDN can also resize your images to make your website load faster. Only supports images at the moment, but reach out and let me know what else you’d like to see!

I have been working on an integration to automatically save important emails to airtable for further tracking and attaching emails to various tasks and projects. Looking for feedback from our community 🙂Grid view:Individual view (partial):How does it work?Simply forward any email to a designated address (similar to how other project management tools work)A script will pick up the sender and cc, dates, attached files and other email attributes if any and save it to an airtable of your choiceYou will be able to view the entire email thread in airtable and manage emails with your other existing workflowsCool features:Auto tag emails with hashtagsAttachmen

I made an integration called TaskRobin to save emails to Airtable with a simple forward. All your attachments, email information like the sender, CC, dates, message will all be saved to Airtable.You can also tag and organise them with #hashtags as you forward your emails.We are now in beta test! Feel free to give it a try!Update: TaskRobin is now fully launched

Hi there, I’m looking for help with the following problem: I have a database of People and a multi-select data field called Groups that people belong to. There are 3 groups that people can belong to, and we expect to add more over time. When I import new data via the Import CSV block, I’d like to merge data around emails (to prevent duplicate instances) and append new data in the Groups column. Here’s an example: If a person in my database belongs to Group A and Group B, and when I import the list that says the person belongs to Group A and Group C, then I’d like the field to say that the person belongs to Group A, Group B, and Group C (creating Group C, if it doesn’t already exist in the multi-select menu). However, currently the Import CSV option overwrites this data. Any thoughts on folks who could help write the script to do this? Here’s an identical problem:

Hey Airtable, I need helt with tracking the performance of TikTok sounds (posts using the same sound) likes, comments, shares, views, saves, link Is there anyone here that has good experience with that? Would like to pay for making some automatic services Please send me an mail on dennis@kiilmgmt.com Best regards

Hi, for a long time I thought about ‘what IF’ - display bases and workspaces as tables and fields displayed in base schema. I played a little with array transformations and did 2 model bases to use with base schema app. First, 2 levels up, Workspaces are ‘tables’ and bases are ‘fields’. Connections are manually created - I used these lines to display some data flow to my colleagues during knowledge transfer. In general, it’s not very useful. Maybe it can be updated to clickable form to serve as start page, before Airtable develop it’s customizable form, announced in ‘coming soon’. (by way, that’s a great move from Airtable managers - to share such plans with community. it saves time from developing custom solutions, that later may appear in Airtable as native functions). The next, 1 level up, bases as “tables” and tables as “fields”,

Hey team, There’s a new version of the Data Fetcher Airtable app out: • Connect to OAuth APIs including Google Analytics, Google Ads, Facebook Ads, Webflow and more right within Airtable! https://help.datafetcher.io/create-requests/connect-to-an-oauth-api • Use x-www-form-urlencoded format for request body • Add a fixed value to every output record https://help.datafetcher.io/advanced-options/add-fixed-value-to-output • Run requests with no output table

Hi everyone, Hope you’re having a great week so far. I’m super excited to share a big announcement today: Codemap’s 2022 no-code market report is out, and happy to say that Airtable is the most in-demand tool within the backend/database solutions category! About the report The 2022 no-code industry report is the first ever deep dive into no-code from a user perspective and based on aggregated real-world data from thousands of clients and experts on Codemap. The no-code/low-code industry is growing and changing – rapidly. With a continuously increasing number of vendors, an evolving community ecosystem, and an accelerating pace of no-code adoption, there are many unanswered questions about this revolutionary space. While there has been a lot of progress in the areas of no-code education, the missing piece we see at Codemap in the current market landscape is the abi

I have been in need of a Calendar view that does not compress items that exceed the max number of viewable items in a single day. The interface views all days by Month. There is no limit to the number of items that can be displayed in a single day cell. A form is included to create new calendar events. Displayed item text is very customizable and can include many fields and emoji. Here is a link to the Universe Base: Full Interfaces Calendar - Airtable Universe

Hi Airtablers! This is a silly little thing that I though some others might find useful/funny. I find myself living in my ‘demo’ base most of the time. Users come to me with an Airtable question and I often open my demo base and recreate the issue to help them solve it. When I do this I often need to make a few tables and fields quickly, yet creating a new table, naming it, renaming the primary field and deleting Notes, Attachments and Status every time is a pain. So here is a small script to keep at the top of your extensions to quickly create new tables and fields without the need to clean them up after. const config = input.config({ title: 'New Table Maker', description: 'This script lets you create a new user defined table without the default table options.', items: [ input.config.text('defaultPrefix', { label: 'Default New Title Prefix', }), input.config.select('keySuffix', {

Hello, I’d appreciate any guidance or offers on the following! Pro users currently have a couple of ways to restrict access to a view (email domain & password). What I would like to do is effectlively create a third option of “Restrict access to a list of email addresses in table X”. In this scanerio: the anonymous visitor hits the shared url and must enter their email address. System responds with a “Thanks, check your email for a magic link.” System checks table X for the presence of user’s email address in table X. If it is there, generate a magic url and note the time of generation, then send email containing the magic url. When visited, the magic url allows access to View. Magic url is accessed more than 10 minutes after generation, show user a “This magic link is expired. Try again?” message. Note: the email addresses would not be for Airtable user accounts. This would likely wrap around the “restrict access wi