- 20
- 22 609
Rupert Hoffschmidt-McDonnell
Germany
Приєднався 11 жов 2006
Hey, I’m Rupert. I’m an entrepreneur and software developer focusing on business automation with No-Code and AI. My goal here is to share what I've learned in projects and automating my own work. I hope it brings value!
I'm also the founder of the popular document automation software DocsAutomator, integrating with No-Code tools Airtable, Glide, Zapier, Noloco, ClickUp and many more soon!
Feel free to reach out any time and happy automating!
I'm also the founder of the popular document automation software DocsAutomator, integrating with No-Code tools Airtable, Glide, Zapier, Noloco, ClickUp and many more soon!
Feel free to reach out any time and happy automating!
Create Automated & 100% Customisable Reports in Airtable
In this video, I'll show how I'm creating fully customisable reports from Airtable using scripting + my document automation tool DocsAutomator. Let me know what you think!
It's a code along & struggle along video, so you'll see me doing mistakes and figuring things out :)
Links:
Finished script: github.com/rupertxyz/airtable-scripts/blob/main/customreports.js
DocsAutomator: docsautomator.co/
Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
Timestamps:
0:00 Intro
3:00 AI rant
4:50 Use case intro
9:00 Script writing
18:00 DocsAutomator setup
27:30 Final run-through
#airtable #automation #docsautomator #documentautomation
It's a code along & struggle along video, so you'll see me doing mistakes and figuring things out :)
Links:
Finished script: github.com/rupertxyz/airtable-scripts/blob/main/customreports.js
DocsAutomator: docsautomator.co/
Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
Timestamps:
0:00 Intro
3:00 AI rant
4:50 Use case intro
9:00 Script writing
18:00 DocsAutomator setup
27:30 Final run-through
#airtable #automation #docsautomator #documentautomation
Переглядів: 1 032
Відео
[Airtable Scripting] Calculate Auto-Numbers
Переглядів 58511 місяців тому
Hi Automators! Let's look at calculating auto numbers. Airtable offers a field type called "auto number", but it has certain flaws that makes it unsuitable for lots of projects. Let's find out what I mean! Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Links: Script: github.com/rupertxyz/airtable-scripts/blob/main/calculateAutoNumbers.js ChatGPT Script: github.com/r...
Why Airtable Isn't a Spreadsheet and Why It Matters
Переглядів 26711 місяців тому
Hi Automators! Airtable is not a spreadsheet and treating it that way does more harm than good in my opinion. Let me explain the key differences and how to think about Airtable when getting started with it! Make sure to sign up for the Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Links: My document automation tool seamlessly integrating with Airtable: docsautomato...
10 Essential Airtable Formulas You Need To Know
Переглядів 92211 місяців тому
Hi Automators! Let's learn about Airtable formulas. I've identified 10 Airtable formulas that cover 80% of use cases. Enjoy and let me know what you think! Happy Automating! Make sure to sign up for the Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/tbl87Gh021m0TUdrk/viwq5JxwxRyqdENiC?blocks=hide Links: Airtable Formula Playground: www.airtable.com/universe/expHF9XTWWwAT299z/airtable...
Integrate Stripe Payments into Airtable (using webhooks)
Переглядів 1,6 тис.11 місяців тому
Hi Automators! Let's learn how to integrate payments and invoices from Stripe into Airtable by using webhooks. We'll also look at scripting in Airtable to format data according to our needs. Links: Stripe events: stripe.com/docs/api/events Weekly Newsletter: airletter.substack.com/ Artable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb DocsAutomator: docsautomator.co/ Happy ...
How to Structure Airtable Projects
Переглядів 71711 місяців тому
Hi Automators! What's a god base? Analogous to a god object in programming, it's a base that holds way too many, unrelated pieces of information. What's better way to structure things? Separating concerns into different bases and syncing generously between them. Let's dive deeper into this! Links: God objects: en.wikipedia.org/wiki/God_object Weekly Newsletter: airletter.substack.com/ Artable S...
Convert Currencies in Zapier for Free
Переглядів 23411 місяців тому
Hi Automators! This video features how to easily convert currencies in Zapier, completely for free. Hope you enjoy & let me know in the comments below! Weekly Newsletter: airletter.substack.com/ Artable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Check out my document automation tool DocsAutomator - turn your data into PDF using Google Docs: docsautomator.co/ Happy Automa...
Game-Changer for Airtable Interfaces: Conditional Logic
Переглядів 949Рік тому
Hi Automators! I'm super excited about Airtable right now. They've launched conditional logic for Interfaces, something I have been waiting for for years. This might finally allow building complex experiences in Airtable Interfaces. Let's dive in! Sign up for my Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Send me your content wishes and I'll make videos about the...
Automate Content Creation in Airtable with ChatGPT + Zapier
Переглядів 870Рік тому
Automators! This video features how to generate content ideas as new records in Airtable using ChatGPT and Zapier. AI automation should happen where your work happens. Happy Automating! Sign up for my Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Send me your content wishes and I'll make videos about them: automateandelevate.glide.page/ Timestamps: (00:00) Intro (0...
Zapier Tables instead of Airtable?
Переглядів 1,8 тис.Рік тому
Hi Automators! With all these latest Zapier changes, I thought it's time to compare Zapier Tables to Airtable! Let me know what you think! Send me your content wishes and I'll make videos about them: automateandelevate.glide.page/ Useful links: Make a Zapier account here: zapier.com/ Make an Airtable account here: airtable.com/ Latest Zapier announcement: zapier.com/blog/automate-new-zapier-pro...
Airtable Record Cleanup: The One Script Every Base Needs
Переглядів 426Рік тому
Hi Automators! Quick video about the one script I'm using in all of my Airtable projects: Cleaning up records. Hope this brings a lot of value, let me know in the comments below! Useful links: Cleanup Script: github.com/rupertxyz/airtable-scripts/blob/main/recordcleanup.js Airtable Scripting Course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Weekly Newsletter: airletter.substack.com?r=lqg...
Automate Incoming Invoices with ChatGPT, Zapier, Gmail and Airtable
Переглядів 565Рік тому
Hi Automators! This week's video is all about automating your incoming invoices. It's 2024 and you should spend 0 minutes on filing expenses, adding data to a database and manually sending them somewhere. Hope you enjoy this video and let me know in the comments below! Subscribe to my channel: www.youtube.com/@automationmania Please also checkout my upcoming Airtable Scripting course for NoCode...
Trigger Zapier or Make from Airtable like a Pro (Webhooks!)
Переглядів 350Рік тому
Hi friends of Airtable! This video shows you the best way to trigger Zapier and Make from Airtable: Instant, cheaper and more flexible! Hope you'll enjoy and let me know in the comments! Please also checkout my upcoming Airtable Scripting course for NoCoders: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Useful links: - Script: github.com/rupertxyz/airtable-scripts/blob/main/triggerZapierAnd...
Airtable Scripting - Connect to the ChatGPT API in Airtable (no Zapier, Make, ...)
Переглядів 1,4 тис.Рік тому
Hi friends of Airtable! In this video you'll learn how to connect to the ChatGPT API using a script in Airtable. Hope you'll enjoy and let me know in the comments! Please also checkout my upcoming Airtable Scripting course for NoCoders: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb Useful links: - Script: github.com/rupertxyz/airtable-scripts/blob/main/chatgpt_api.js - Upcoming Airtable Scri...
Airtable Document Creation (incl. Line Items)
Переглядів 3,5 тис.Рік тому
Airtable Document Creation (incl. Line Items)
Airtable Scripting - Delete Duplicates
Переглядів 2 тис.2 роки тому
Airtable Scripting - Delete Duplicates
Airtable Scripting - Scrape Data From TikTok using Apify
Переглядів 1,7 тис.2 роки тому
Airtable Scripting - Scrape Data From TikTok using Apify
Airtable Scripting - Create More Than 50 Records at a Time
Переглядів 1,2 тис.2 роки тому
Airtable Scripting - Create More Than 50 Records at a Time
Airtable Scripting - Automate Your UpWork Job Search
Переглядів 7402 роки тому
Airtable Scripting - Automate Your UpWork Job Search
Airtable Scripting - Delete Multiple Records Automatically
Переглядів 1,8 тис.2 роки тому
Airtable Scripting - Delete Multiple Records Automatically
Perfect way to solve, perfect explanation! Thank you 👍👍
If we have existing members on subscription and so have a member table, is it possible to link to that members Airtable profile for the Name field, rather than constructing a new name field? I'd like to be able to pull their payments from the existing member table as well.
Not sure I understand 100%, but it sounds like you want to retrieve existing subscribers from a subscribers table. You can add a find step, usually based on the email address and pull the existing record that way
Does the trigger also work with a subscription ?
This also works for Stripe subscriptions, yes
Thank you. Best explained with appropriate examples. Not sure why this video is not as popular as others. Keep it up.
Thank you!
Free Idea account is my Facebook connect in the WhatsApp connect
Very good! I have tried to run 2 events in the one webhook, one has a subscription creation event with 2 custom fields and the other is invoice paid as i wanted the invoice pdf filled, but it wants to create 2 records and i then lose the custom fields which have run through a script to seperate them.....
Hey Rupert. Great tutorial! Clear and easy to set up 😁 How would I include an attachment field in this webhook? Does a separate webhook and automation need to be set up for this? Thank you!
As a beginner, to all this automation, This is exactly what I was looking for, but you need to go slower, and not skip or bounce around. I am looking forwarding to trying this out. Thank you
@@cathychapman5530 thanks for the feedback!
I'm basically syncing between all the bases.. 😀
Thanks Rupert! I hit a bit of a wall trying to make an Interface button do things that only a $45 plan allows for! Pity that; the more cool interfaces I build the better the chances are that I upgrade to a higher plan! A bit short-sighted and practically down-right mean of Airtable not to allow for button visibility / rules for everyone..
As always very helpful and EXACTLY what I was looking for 😅 Thanks Rupert!
Glad to hear that :)
Is it easy to keep a zapier table 2-way synced with an airtable table?
Very good videos. I would like to know more about percentages. I want to apply a standard 8% to each of the quote i provide . I will put the fee as a quote but in another tab, the percentage calculated and another
How would you adjust this for emails with multiple attachments? Attachment1 could be an image or anything else but the invoice.
Why not just use filter to create view of "In Progress" Then use it in zapier?
Interesting video. Curious why you didn't use the now() function instead of creating a script to convert the Unix date
I'm not sure about this exact timestamp, but dates passed by an API can be in the past. Invoices paid late for instance. So this was to demonstrate how to convert a UNIX timestamp. If you're sure it's now, you can use now of course.
fantashtische : )
Great tutorial, straightforward and useful!
I am relatively new to Airtable and started on the approach of one base for all. I like the simple approach that you have laid out. I have a big project that I am starting to put together and I think this would be a game changer. More like this please and with examples would be great!
Good on you for showing how to delete more than 50 records because my project definitely needs that 😅 thank you!
Excellent how-to. Thanks for posting.
5:22 Core Data = Master Data Rest would be transactionaL data
This is not Upwork its a site called Toptal which is totally different
The limitations that synced tables impose on editing capability, field types and interfaces feels currently too great to make this a viable model. I'm currently syncing selected data through shared views from one master to several sub bases, each forming the data layer for another app (Glide and Softr-based), but have hit many roadblocks, forcing me to resort to API/automation tools to edit data in the master table instead of each specific app base. I wish the concept would work as smooth as described here but for that improved sync and Interfaces are a must...
Can we do the same thing to get profiles that apply to our jobs?
Thanks for this video, Rupert. This makes it easier to understand how the document creation works from the Airtable data. Doing it 'code along' also makes this much more 'normal'- scripted videos aren't as useful 😊👍 Viv
Thank you! I'm trying to do more "code along, struggle along" type videos :)
@@rupertxyz I think they're far more effective & useful 😊👍
correct me if I'm wrong but you can't link or do a lookup for data from one base to another. You can in smartsuite
You can sync bases in Airtable: support.airtable.com/docs/getting-started-with-airtable-sync
@@rupertxyz ok but that seems like unnecessary overhead and duplicate data
@@techme3845 You can limit what gets synced in any way you want. It always does add a table to your base though.
Interesting, and helpful. Appreciate it. Would love to see a video detailed use case and real specific examples around the core data in particular. How do you draw the line between core and the satellite bases?
Yes, definitely a video I'd like to see!
Really interesting approach, as a beginner would love to see detailed demo 🙏🏽
This is great 👍🏽, thank you. Looking forward to learn more about Airtable
Glad you're following along!
👀 "Promosm"
That is a much better way to handle data but it does depend on 2 way syncs which is not available in all subscription levels I believe
Two-way sync is only available on Business and Enterprise plans. But I've been working like this for years without two-way sync. In most cases, it's not necessary for a target table to edit the source table, so one way is enough.
With interfaces getting more and more robust i can see a use cases for keeping data in a single place and just working from the interface layer. You could overwhelm the base and slow things down with this approach so spreading data into multiple bases and syncing tables is likely the best path.
By adding interfaces on top, the issue is indeed out of sight for most users. But the poor maintainers of the underlying structure will still have to deal with it. I think it would be a true fix if interfaces weren't bound to a single base, but would be entirely separate from underlying data bases. One big frontend able to reach into the underlying architecture.
@@rupertxyz yup, that is the true fix. Hopefully we see it by eoy as that would be the game changer.
Hi Rupert there are no attachment fields either👍
Yes, handling files is another issue...
Cool video! Totally agree that we need to seamlessly integrate AI into your workflow
👍great product you're building!
Thanks! @@rupertxyz
u are BRILLIANT. Gracias! Today, would you replase Airtable for Zapier Tables on this specific case?
The only downside I see is that you can’t store PDFs directly. Otherwise I don’t see any reason against using Zapier Tables for this use case, especially as there are no relations in this base
I've written a few Airtable scripts - but by my own admission I am terrible at it. I tend to copy paste and work with trial and error. I often get the "Your script took more than 30 seconds" error - which I think is because my code is so awful!
Haha let's fix that! Make sure to leave your email address for the course: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
I’d be interested in your Airtable scripting course Rupert. Thanks. Andrew
Here you go airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
Course link is broken but definitely interested. Saw you've been posting more consistently lately, keep it up they have been fire
Thanks!! Fixing the link now, here as well: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
sweet thanks, just submitted @@rupertxyz
Super useful video. Already thinking of modifying this strategy to capture support tickets from emails. Thanks for publishing!🙌
Thanks! Always happy to help / expand when needed!
Good lord this is helpful!!! I do have one question (because I'm a non-coder but already understand way more just from your explanation): how to you filter the dTableRecords array to filter for identical field values EXCEPT "null" or empty fields? Seems like there's some way to indicate !== i AND "null".
In the filter step you would have to add another condition, so after comparing to the index you could do something like " || !rec.field" in the example above. This is not tested, but basically says "include if the index is equal OR if no field value is present". Hope that helps! :) I do have a scripting course coming up, specifically for Airtable if you're interested: airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb
Danke dir! I mean, i would be very interested to get a solution for the Automation script with the proxy. I am facing this timout error and i can't fix it! I am trying it with Cloudflare workers and Airtable atm. Anyways, if you will do the other video or not, thank you for this one!
Thank you!! I'll think about the video, potentially I could show a workaround with a no-code backend like Xano...
oh this is great🔥
Amazing video, thanks a lot for taking the time to create this :)
Thanks Rupert this is incredible
Thanks 🙏 Released v2 a few days ago :)
Hi is there a way this works but it scans lines instead of a record? For example in a record i may have multiple exact urls one below the other. And instead of deleting them to have them marked or highligthed or a count of how many duplicates?
It's JavaScript?
Yes :)