Show and Tell

On a recent task I reached my limit for the annoying and time-consuming implementation of a PDF document generation process for Airtable. I just had to find a way to eliminate lots of steps. Lacking the use of integrated tool sets the likes of which @kuovonne and On to Air has created, most of mine have embraced a process like this. As you can see in the list, the workflow involves a lot of steps that are dependent on services all working perfectly as expected. Not to mention that there is a significant amount of processing time involved with all of these steps combined. Airtable → Automation → Script → Webhook → Google Apps Script → Airtable API → Google Document (template) → Google Drive → Google Apps Script → Airtable API → Airtable I really want this: Airtable → Script Action → Airtable This seems impossible, but it’s not. I have perfected this approach and it requires no external document storage service to host the final PDF document from for upload into Airtable’s attachment

Ever needed to get the initials of a name that had more than first and last name plus some weird dashes and what not?Try this formula, which can also be used to get the firstname and lastname with a workaround of find() and search() which only returns the position of the first space in the stringLEFT({Name},1) & LEFT(REGEX_EXTRACT(Name,"\\s(\\S+)$"),1) I hope this helps!

Hey Airtable Community!  🎉 The countdown is officially ON for Daretable, the conference for Airtable enthusiasts happening in New York City on October 25-26! Whether you're a newbie or a seasoned user, this event is your chance to level up your skills and network with fellow Airtable enthusiasts. 🎙️ Are you attending Daretable? Share your expectations, questions, and enthusiasm for the conference in this thread for a chance to earn an exclusive Community badge! We'd love to hear what sessions you're most looking forward to, what you hope to learn, and maybe even who you're hoping to connect with! This thread can be a great place to start making connections with each other! P.S. While I personally can't attend this time around (and will be living vicariously through this thread), be sure to connect with the incredible Community and Education team on-site (@kev, @leah_ackerman, @AMtable) to geek out on all things Academy and Community!

Ok, so first up i love airtable and think it is possible the greatest app ever made, i respect airtable and greatly appreciate the free version that they have given to us, it is AWESOME. I am not trying to abuse this generosity and i am not personally using this “Hack” as for reasons that will become obvious, the “Catch” makes it unusable for commercial use / the wider public. But works for personal uses as long as you are logged into the airtable account that has the videos uploaded. Same works for images and files i imagine. The Process Step 1: Upload video into airtable attachment field Step 2: Open this video so that you can see it playing Step 3: Right Click on the video and select “inspect” this opens up the coding for the website Step 4: Locate the web link for the uploaded video file, should be close to where the inspect element has taken you (Or Ctrl + F and enter a distinct word from the video name) Step 5: Share the base and grab the embed code from this Step 6: Replace the

There has been quite a lot of interest here about sending PDF documents from you base automatically. Integromat recently introduced a PDF ‘app’ which converts HTML into a PDF and I thought I would see what could be achieved in a real world type scenario. I’ve written this up in a blog post which you can see here: Database Resources Sending a PDF document from your database with Integromat | Learn more about... Ideas and reviews of Cloud Database platforms Note that I don’t use Airtable this time in my post (I work with several platforms) but the process would be practically identical connecting to Airtable.

Hey everyone!We’re excited to announce that last week we released an Airtable integration for our static forms on Static.app.What does this mean for you?Now, you can easily collect form data by adding a simple code snippet to your static pages:<form static-form>...</form>Once that’s in place, all you need to do is connect Airtable, and you’ll start receiving your form submissions directly in your Airtable account.For a step-by-step guide, check out this article.We hope this makes your workflow even smoother!Let me know if you’d like any further tweaks!

Here're a few 'Run a Script' Action automations for integrating with MailChimp (create contact, tag contact, archive contact). In all examples, be sure to add your own values for mailchimpAPIKey and audianceId constants and add your own input variables e.g. email, firstName, lastName, organisation, tag etc.Note: these automations send the actual email address across to MailChimp instead of using an MD5 hash of it, as is recommended by MailChimp. Whilst these scripts are not necessarily insecure, the transport is still TLS encrypted (HTTPS), sending an MD5 hash is still a more secure method. CREATE A MAILCHIMP CONTACT// API Key and Audience ID const mailchimpAPIKey = "ENTER YOUR MAILCHIP API KEY"; const audienceId = "ENTER YOUR AUDIANCE ID"; // Extract email and other fields from the record that triggered the automation let config = input.config(); // Capture all input variables let email = config.email; // Email address from Airtable let firstNa

Hello everyone 👋Powersave, my chrome extension to quickly save to Airtable right from the browser has just been updated.It now provides custom autofill configurations. You can configure different strategies to map values from websites to your fields:Pre-configured exact valuesExtracting meta values from the page's headUsing CSS selectors to pull values from the page bodyContextual reading via AIIf one strategy doesn’t work, you can set up a fallback. Powersave will try one strategy after another until a value is found.The other functionality such as bulk saving and updating records right from the browser has been improved.Big thanks to anyone giving it a try 🙌 Feel free to reach out to discuss any saving workflow!Martin

Hello,My team uses the Page Designer extension to export pdf files for our customers. Until recently, the urls were active when exporting PDF files, but now the urls no longer work. We absolutely need them. Could you please help us? Thank you in advance,

Hello Airtable Community!I'm excited to share a project that's been around since 2020, but I realized we hadn't directly shared it on this forum yet. It's called BaseQL, and it's a tool that I think could be really useful for Airtable users who are looking to build more complex applications or integrate Airtable data into their existing systems. Essentially, BaseQL provides a GraphQL API for Airtable to simplify the process of building custom applications and integrations using Airtable as your database.For those unfamiliar with GraphQL, it's a query language for APIs that allows you to request exactly the data you need, nothing more and nothing less. This can be particularly powerful when working with complex data structures like those we often create in Airtable.Here are some key features of BaseQL:Automatic schema generation: BaseQL creates a GraphQL schema based on your Airtable base structureSeamless integration: Allows you to leverage GraphQL's benefits without changing your Airt

Hi, How can I make that when a new user signs up he gets a unique ID in the Accounts table and every time he adds a new record in other tables his ID shows in the column?

Hello!When I open the extension Page Designer, I cannot edit the preferences, i cannot do anything but close it.Any ideas?

So, forms just got the option “Collect respondent email addresses automatically (sign-in required)”. When this option is checked and people open the form URL, they will be prompted to sign in with Airtable or make an account. After that, they can fill in the form and the email address they used to sign in or to create a new account with, will be stored in a auto created “created by” field in your table. This opens up the possibility to let people change their data, using their email address as a unique identifier. When a record, let’s say a client record, contains an email address, you can crosscheck this with the auto filled in email address in the “created by” field mentioned above, by prefilling and hiding it in an email field in the form. Via automations you can access the underlying email address from the “created by” field and check it against the one in the existing record. As you cannot create an Airtable account without having to activate your account from the inbox from the

Posting this here for anyone else who might find it helpful. While there are some great extensions for geocoding, I needed to simply convert an address into latitude and longitude and had a hard time finding a script to do it in Airtable + Google Maps API. I found this awesome script but had to modify it to only run on a particular view so that it didn't hit the automation / script limits. Here's my version for anyone looking for a way to geocode the record once it hits a particular view: Create number fields called Lat and Lng, get a Google Maps API key, create a view of records that have Address, but not Lat that can trigger an automation. let table = base.getTable('<TABLE NAME GOES HERE>');let view = table.getView('<VIEW NAME GOES HERE>');let result = await view.selectRecordsAsync({sorts: [{ field: 'Lat', direction: 'asc' },{ field: 'Address', direction: 'asc' },{ field: 'Lng', direction: 'asc' }]});const GOOGLE_MAPS_API_KEY = '<API KEY GOES HERE&g

 One of my clients, an American production company, was spending a lot of time on invoices to the detriment of their high-value work – the production of corporate videos and ads. Consequently, to help them refocus on their core mission, I created for them a set of automations that streamline their invoice management system: data entry for inbound invoices, document generation and sending for outbound invoices. Those automations helped them reclaim around 10 hours of work per week. You can see what I built in 👉 this Loom video 👈. For data protection purposes, please note that the product you’ll see in it is only the MVP I built for the client, not the final product, and that I made up all the data. For this project, I have to say that setting up the loop mechanism in Documint for retrieving the line items stored in Airtable was the biggest technical obstacle to me. But if you guys ever consider using this tool, I have to say Documint’s support te

Hi! I am brand new to Airtable (and admittedly, brand new to the tech world in general), so I wanted to share my first project and get some feedback/suggestions. Some background on the project: My dad’s company is built almost entirely out of google drive and he is wanting to start transitioning over to Airtable to automate some processes that are currently being done tediously by his HR team. One of these tasks is keeping employees’ contact info updated regularly. Right now, this is being done by HR reaching out to employees individually to see if their info has changed and then manually updating in google sheets. Current Project: Import current employee info into new Airtable base and set up a form to be emailed quarterly to all employees which will allow them to change any information and update their record automatically once this form has been submitted. Step 1: I imported data straight from google sheets into Airtable to create my Employee Info base. This google sheet had a lot o

Hey there 👋Anyone using Airtable and Asana?We’re slowly launching our new tool, Syncgrip, and we could really use some feedback from folks who are already using these platforms.Syncgrip lets you sync data between Airtable and Asana in real time, and we’re planning to add more services soon.If that sounds useful, check out this quick demo to see how it works.The Beta is open to everyone, so feel free to try it out at Syncgrip. We’d love to hear what you think!Cheers!

Hi everyone! For those of you that were in attendance for Airtable’s New Feature spotlight last week, you may have heard Howie’s announcement that Airtable Academy, our e-learning and certification program, will be universally available and rolled out to EVERYONE this October.  As Howie stated in the webinar: "Our goal is to make this the go-to resource to understand how to build an app—the data modeling concepts, the automation and logic concepts, the interfaces—and to further our mission of empowering a whole new generation of builders to create really useful apps that ultimately transform their operations and create awesome impact for their businesses." If you are a member of one of the 1,000+ Enterprises who’ve registered for the Academy, enrolled in a course, completed a learning path, or achieved the Airtable Builder certification since we launched last month, we appreciate your support and feedback thus far.  And for those interested but unable to access Academy—we've

This article shows how to generate a PDF based on one of the DynamicDocs JSON to PDF templates from Airtable. PDF generation is done by setting up a script which can be prompted with a button. The script creates a JSON with underlying data from Airtable and uses DynamicDocs API to generate the PDF. The PDF is then downloaded and put into the Airtable attachment field. What is DynamicDocs API?DynamicDocs API is JSON to PDF API based on LaTeX that allows users to generate dynamic PDF documents in a matter of seconds. PDF generation happens with LaTeX, a mark-up style language that separates formatting and content. LaTeX consistently applies a user-defined style throughout the documents and has become very popular in academic circles due to its ability to create high-quality, complex documents. The templates utilise special commands that can create dynamic text with logic statements, tables spanning multiple pages, great-looking headers & footer

If you are looking for a way to convert a shared Airtable view to CSV then we have now added this to our service at csvgetter.com. This 2 minute video demonstrates how it works:https://www.youtube.com/watch?v=8xyUP5LAJnM

Hey all! Ryan here, I created a tool that lets you customize and embed Airtable data on any website.I've implemented the feedback I got from here (Thanks again!) and am excited to share our new Calendar template.This template is a perfect way to showcase upcoming events on your website all whilst managing them in Airtable.The Template comes with a bunch of customisation options:The Calendar comes with 4 views (Day, Week, Month, Agenda)You can toggle which views you want to have on your template Choose a Default Calendar view for the Calendar.This is the view that the template starts with when the template first loads on your website. You can combine this with toggling off views you don't want to have only 1 view on the Calendar. Popup Event ModalsWhen you click into an event a modal will pop up with more information. Here you can also add custom fields and more. (I am investigating adding the modal functionality across existing templates too, stay tuned!) Custom Event Co

How to group rows by date so that groups are formed by day, without taking into account time. To get a group of October 4 with 2 rows and October 5 with 2 rows. I understand that the question is in the time display, but if you make a separate column with the formula DATETIME_FORMAT({Posting Time}, 'DD MM YY') and then group by it, then the program takes the date for text and sorts without taking into account the month, only by day.

Have trouble with your age-old ERP that's visually horrible and takes you so much time every week? Well, we've got just what you need. We're building a streamlined and visually appealing ERP on Airtable and Make for a client, allowing them to leave soon the horrible Dolibarr. It's estimated that our client will thus save 4 to 10 hours of tedious repetitive tasks a week. Plus, they already enjoy the polished look of this new tool. Thank you, @airtable44 team, for giving us the means to have our clients go from 'Aaargh' to 'Wooow' ! Here's what the first step of this massive project, namely integrating Dolibarr and Airtable, looks like:👉https://bit.ly/demo-erp-airtable 👈

I've gotten a lot of help from the community, and I'd like to offer something in return.  I was able to author a script that autonumbers a counter field for my detail records based on the group field of the parent record.  This is my first working script and I'm sure it has issues, so use carefully.  I'm sure better versions of this exist on marketplace or someplace, but I couldn't find.  I've submitted it to the marketplace, not sure if it's worthy of them listing it though.  It was a painful learning process to get working, but it does do what I need now. 🙂PS, I know airtable doesn't have a concept of "secondary key" (as in subject), but I think people like me that come from a SQL background might search on thatThe high level of this use case is I have a board meeting each month (Meeting is primary key of parent record). People can submit new agenda items for that meeting, and as they do, the "Agenda Item" counter will number them 1,2,3, etc based on

Airtable’s Script Editor is great, but one flaw that’s bothered me for a long time is how much space the side panels take up, especially on small screens. There’s no way to collapse them, and no way to resize them. Soooo, I spent a few hours writing a userscript with some absolutely insane CSS rules to fix this. Now, the side panels in the Script Editor are collapsed by default, and can be shown by hovering over the handlbars to the right and left. The script is designed to work in both the Scripting Extension, and in the Automations editor. I haven’t released the script publicly yet, as it’s currently written using some experimental CSS properties which allow the CSS rules to be less complex. However, I already figured out a version of the code previously that doesn’t use these experimental properties and is compatible with current browsers, so it would just take a little time to fix up the code before I can share it. If you’re interested in getting ahold of this userscript, please le