How Airtable "Thinks About" Time
12:06
Пікірлер
@TheRemyRomano
@TheRemyRomano 12 сағат бұрын
Excellent. I have scratched my head over. Make a good bit and that is very helpful.
@ozelayaran
@ozelayaran Күн бұрын
As always, excellent explication, Gareth!
@GarethPronovost
@GarethPronovost 3 күн бұрын
Grab our automation training 👉👉 gapconsulting.io/webinar-registration 🤓🤓 Start a free trial in SmartSuite 👉👉 partners.smartsuite.com/8ust3byf6ihl ✨✨
@60pluscrazy
@60pluscrazy 3 күн бұрын
That quick, but very useful 🎉
@GarethPronovost
@GarethPronovost 2 күн бұрын
Thanks for watching!
@henk0129
@henk0129 4 күн бұрын
As a new user of Airtable, how do you let a user use a form without having to 'enter' the database with all its options? How do I save a form and how do I activate the form?
@GarethPronovost
@GarethPronovost 2 күн бұрын
You don't need to save a form, any changes you make are instantly available in the public URL. Each form is activated automatically and can be shared by using the share link or embedded on a website! Users submit data in the form without logging into Airtable, so they don't need to be users ✅
@agoogleuser6937
@agoogleuser6937 4 күн бұрын
What are the pros and cons of linking records with a script vs with a non-scripted airtable automation?
@GarethPronovost
@GarethPronovost 2 күн бұрын
It really depends on your use case. Most of the time we will default to linking with automation wherever possible. We'll typically use a script as a last resort, especially now that Airtable has enabled looping automation that will perform multiple links.
@agoogleuser6937
@agoogleuser6937 4 күн бұрын
What are the pros and cons of linking records with a script vs with a non-scripted airtable automation?😊
@GarethPronovost
@GarethPronovost 2 күн бұрын
It really depends on your use case. Most of the time we will default to linking with automation wherever possible. We'll typically use a script as a last resort, especially now that Airtable has enabled looping automation that will perform multiple links.
@HealthandBeautyAP
@HealthandBeautyAP 4 күн бұрын
Timestamp: how to actually create the linked relationship: 9:18
@GarethPronovost
@GarethPronovost 6 күн бұрын
Grab our automation training 👉👉 gapconsulting.io/webinar-registration 🤓🤓 Start a free trial in SmartSuite 👉👉 partners.smartsuite.com/8ust3byf6ihl ✨✨
@DustinBajer
@DustinBajer 6 күн бұрын
Thank's that's very helpful, but is there a way to share a single form link that updates records in my Airtable? Ex. If the email address matches an email address in an existing record, update the existing record. If the email address does not match an email in an existing record, create a new record.
@GarethPronovost
@GarethPronovost 4 күн бұрын
Sure! For this, build an automation that triggers from (any) form submission. Form received, search for matching email address. If found, update. If not, create new
@DustinBajer
@DustinBajer 4 күн бұрын
@@GarethPronovost Much appreciated, Gareth!
@angtol839
@angtol839 7 күн бұрын
im trying to learn zapier or automations. im non an IT guy or anything. but where do you get the formulas necessary to put in?
@GarethPronovost
@GarethPronovost 4 күн бұрын
Formulas aren't required for automation!
@velious2121
@velious2121 7 күн бұрын
But it doesn’t validate the email so someone could give a fake email?
@GarethPronovost
@GarethPronovost 4 күн бұрын
They have an upgrade option that can help validate email addresses and also require 2FA
@mathieuluna
@mathieuluna 7 күн бұрын
Is it new? I heard about signature integrate in Documint, is it coming soon?
@GarethPronovost
@GarethPronovost 4 күн бұрын
Heard the same thing - we'll get a video of that published once the feature is live!
@agoogleuser6937
@agoogleuser6937 7 күн бұрын
What are the pros of fillout signatures compared with jotform. Please video about the new features of fillout.
@GarethPronovost
@GarethPronovost 4 күн бұрын
They have similar options, but it's been a while since I used JotForm. I don't think JF has the scheduling aspect, although it doesn't impact this specific workflow.
@fillout
@fillout 7 күн бұрын
Thanks for the overview Gareth and team! Happy signing✍
@GarethPronovost
@GarethPronovost 7 күн бұрын
We can't say enough great things about Fillout! 🙌
@mckennaschallersafal
@mckennaschallersafal 7 күн бұрын
You, sir, have a way of breaking down information and teaching. Bravo! I look forward to watching more of your Airtable videos.
@GarethPronovost
@GarethPronovost 7 күн бұрын
Thank you! 🙏
@GarethPronovost
@GarethPronovost 7 күн бұрын
Grab my Free Automation Webinar 👉👉 gapconsulting.io/webinar-registration 🤓🤓 Start a free trial with Fillout 👉👉 fillout.com?ref=gapconsulting ✨✨
@GarethPronovost
@GarethPronovost 9 күн бұрын
Grab our automation training 👉👉 gapconsulting.io/webinar-registration 🤓🤓 Start a free trial in SmartSuite 👉👉 partners.smartsuite.com/8ust3byf6ihl ✨✨
@agoogleuser6937
@agoogleuser6937 11 күн бұрын
150$/months for the custom domain 😢
@agoogleuser6937
@agoogleuser6937 11 күн бұрын
is now this possible directly with airtable?
@GarethPronovost
@GarethPronovost 8 күн бұрын
Yes, Airtable now has dynamic linking!
@agoogleuser6937
@agoogleuser6937 12 күн бұрын
In which use cases would be fillout scheduling a better solution than acuity?
@GarethPronovost
@GarethPronovost 4 күн бұрын
We used Acuity for a bit in our business, but the software felt outdated and we eventually switched over and built our own system using Fillout, SmartSuite, and Zapier
@RoyleTC
@RoyleTC 12 күн бұрын
I really like Softr. Unfortunately they have very limited login protections instituted at this time. No OTP, 2FA, etc… For me this means nothing can go in the portal that matters in case of breach. Any ideas to deal with this lack of security? Thanks for all your amazing content!
@VivaLasVegusNervana
@VivaLasVegusNervana 12 күн бұрын
I have no idea what any of those are but you've captured my attention
@GarethPronovost
@GarethPronovost 7 күн бұрын
I'd also love to see 2FA added - I'm not sure what the timeline for this is, but I'll defintely reach out to them!
@thanhnguyendafa9138
@thanhnguyendafa9138 14 күн бұрын
Thank you Gareth, you save me 1 hour thinking about this. Best wishes.
@GarethPronovost
@GarethPronovost 7 күн бұрын
Glad it helped!
@JJfromsoftr
@JJfromsoftr 14 күн бұрын
Awesome video! Thanks for creating, Gareth!
@GarethPronovost
@GarethPronovost 7 күн бұрын
Thanks for everything you do at Softr!
@danquixote6072
@danquixote6072 14 күн бұрын
I can't believe it. I just watched a completely unrelated video of yours on SmartSuite forms. Then started learning how to build a client portal on Softr to see if it's teh right optio for me - and this popped up. Must be fate ! My only regret is that if I had known, I could have taken advantage of that promo code:((
@GarethPronovost
@GarethPronovost 14 күн бұрын
Follow along with a free trial in Softr 👉👉 softrplatformsgmbh.partnerlinks.io/qop6k5
@runnerdude1990
@runnerdude1990 15 күн бұрын
I’d love to have a way to push a dollar amount from Airtable to stripe and then have the customer pay it and update Airtable as paid. Any suggestions?
@GarethPronovost
@GarethPronovost 7 күн бұрын
Totally - you can pass the dollar amount as a variable to Fillout so that the checkout screen includes that total. Then after the payment is made, a separate automation can trigger to update the record in Airtable. Maybe we need to add this use case to our video list!
@runnerdude1990
@runnerdude1990 2 күн бұрын
@@GarethPronovost please do!! That would be amazingly helpful. I’ve actually been meaning to reach out to you. We’ve been using a route optimization script that we were wondering if it would be valuable to customers. Adding a “Time block” parent project and several smaller tasks in that block with addresses. And then a click of a button to use googles API to determine the fastest route between each appointment and then rearrange the appointments to reflect the shortest drive time.
@emilrabinovich4976
@emilrabinovich4976 15 күн бұрын
Hi Gareth, Is there a way to prefill a read-only field?
@GarethPronovost
@GarethPronovost 7 күн бұрын
you can prefill any field in the form, but you can't make a field read-only in an Airtable form - for this you'll want to integrate with a 3rd party form tool. We recommend Fillout as it integrates directly with Airtable
@Sumkilla
@Sumkilla 15 күн бұрын
if I don't have any excel fluency and I am a true beginner, am I doomed
@GarethPronovost
@GarethPronovost 7 күн бұрын
Not at all! Excel fluency really helps with formula writing, but now Airtable AI is so helpful in writing formulas for you, there's hardly any advantage!
@kb7494
@kb7494 16 күн бұрын
Thank you for your video. Do you think Softr could handle taking attendance for a group of people over a period of time? Unlike a school environment where a list of students remains mostly static, I'm thinking about a list of people that will change from day to day with more people being added (or deleted) throughout the week. I'd appreciate any advice you have on how to approach such a task.
@GarethPronovost
@GarethPronovost 7 күн бұрын
Softr is great for building/launching an app to users. If your students are logging in on their own account and marking their attendance, this would help. Although typically, I suspect attendance would be taken by one person, so I'm not sure if you need to build an app for this use case?
@GarethPronovost
@GarethPronovost 16 күн бұрын
Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
@peterland001
@peterland001 17 күн бұрын
It seems you still can't format the result of a formula - do you know if that is still something that might be coming?
@GarethPronovost
@GarethPronovost 7 күн бұрын
I hope so, but I don't have any insider information about this one... 🤞
@agoogleuser6937
@agoogleuser6937 17 күн бұрын
This was one of the main Advantages of SmartSuite.
@agoogleuser6937
@agoogleuser6937 19 күн бұрын
Please make a video about workarounds so that submitters can edit linked records, not just adding, selecting and unselecting.
@GarethPronovost
@GarethPronovost 7 күн бұрын
We have some videos on this topic already!
@giorgoslavrentiou4296
@giorgoslavrentiou4296 19 күн бұрын
If a user sign in for the first time with his magic link, then how can he set up his account to be able to sign in a usual way like email-password / Google sign in?
@GarethPronovost
@GarethPronovost 18 күн бұрын
If a magic link is used initially, you can ask the user to click "forgot password" in the app and then enter their email. They will receive an email with password reset instructions. 👌
@giorgoslavrentiou4296
@giorgoslavrentiou4296 18 күн бұрын
@@GarethPronovost thank you very much!
@Julie-Dox
@Julie-Dox 19 күн бұрын
This is pure genius!!
@GarethPronovost
@GarethPronovost 18 күн бұрын
Thanks, but now Airtable has dynamic filters available so you don't even need the workaround!
@Julie-Dox
@Julie-Dox 17 күн бұрын
@@GarethPronovostit would be great if it was true everywhere but unfortunately the dynamic filters don’t work on forms (computed fields), it looks like it’s one of the many limitations listed by Airtable on their help page. So I still had to use your solution as a workaround to this limitation, and it worked perfectly !
@GarethPronovost
@GarethPronovost 16 күн бұрын
@@Julie-Dox amazing!
@fierceasjules
@fierceasjules 20 күн бұрын
hi Gareth! thanks so much for this! appreciate this video is quite a few years old but I'm unable to get the "recID" bit to show up similarly to yours in my Make - it only shows up as raw text rather than the burgundy "2. recID" that you've got. I think I've done everything before this correctly, though. any thoughts?
@GarethPronovost
@GarethPronovost 16 күн бұрын
It may be a change in the UX since we recorded this video - does it still work the same? Even if it's just text, you should still be able to use the ID in subsequent automation steps, no?
@fierceasjules
@fierceasjules 16 күн бұрын
@@GarethPronovost ah, no, the subsequent steps were a bit of a mess for me as well - I couldn't get the AirTable module in Make to connect to the webhook module, basically, and the subsequent linking fell apart. appreciate you taking the time to reply!
@data-gen
@data-gen 20 күн бұрын
Great video Gareth, thank you! Quick question: how do you make the KZfaq subscribe button light up at the end of your video?? 😁
@GarethPronovost
@GarethPronovost 16 күн бұрын
Thanks! I'm not sure about your question though - do you mean the video edit that popped some "Subscribe" text on the screen? That was just an edit added to the video.
@nxvalism
@nxvalism 20 күн бұрын
Is it shareable to external people ? Like if you d want to an expert booking experience or events list to browse for people with button to redirect to a Calendar link or event page ?
@GarethPronovost
@GarethPronovost 7 күн бұрын
Airtable Interfaces are not public facing and require users to be signed in to Airtable and to have the interface shared with them. Typically this isn't a good option for external users.
@nxvalism
@nxvalism 7 күн бұрын
@@GarethPronovost yes but why ? 😂 Also, would be nice to be able to create template databases...
@lifeonearth9261
@lifeonearth9261 21 күн бұрын
Taking a look at transitioning all of our Zaps to Make. Currently paying about $200/month on Zapier. Make now supports all the tools we use, so... Why not?
@GarethPronovost
@GarethPronovost 7 күн бұрын
The learning curve for Make is a bit rough, but they definitely compete on price!
@davidcrowle760
@davidcrowle760 21 күн бұрын
Hey Gareth, I'm trying to figure out how to create a "loop" in my automations. I was successful in Airtable, but I'm wanting to move to SmartSuite. I'm trying to schedule clients for weekly sessions that last for an entire month (or based of an end date). I built an automation loop that is supposed to end when the conditions exceed the "End Date" field. It's initiated by a single select "Create" option and the trigger is when a record is updated. I made a second automation that updates that new record to match the conditions of the first automation in order to start it all over. Everything runs great, but the second automation doesn't trigger the first one. Again, Airtable can do this, but SmartSuite can't for some reason. Any workarounds or thoughts?
@GarethPronovost
@GarethPronovost 7 күн бұрын
I'm think we are still waiting for a true "loop" in SmartSuite automation - hopefully soon!
@elipavlovska7212
@elipavlovska7212 21 күн бұрын
Hi Gareth, Excellent lessons. I need your help, if I want to link the form as a button or link in another table is that possible? I know you said one form per table, this is only to be set as easy access for internal users. Thank you.
@GarethPronovost
@GarethPronovost 7 күн бұрын
Thanks for watching! Yes, you can create a button or link in another table. Typically we see this in the case where you want to prefill information on your form and you use a formula to prefill it. For example, you could have Table 1 for Clients and Table 2 for Invoices. Your form could add an Invoice, but you could push a button from Table 1 to automatically prefill the form with the Client Name - does that make sense?
@Emicss
@Emicss 22 күн бұрын
Thank you ! very clear !
@GarethPronovost
@GarethPronovost 7 күн бұрын
Glad it was helpful!
@BatzorigBegzsuren
@BatzorigBegzsuren 22 күн бұрын
It's great, but my Chrome browser started crashing frequently so I had to uninstall.
@joellemorris5684
@joellemorris5684 23 күн бұрын
Thanks a lot! I'm trying to figure out to use a formula to display a Smartdoc field from a linked record. I don't find a way to do it. Apparently it's not possible.... Do you have a solution?
@GarethPronovost
@GarethPronovost 7 күн бұрын
I think you can build a Dashboard and access the Smartdoc there from the linked record?
@TheRemyRomano
@TheRemyRomano 23 күн бұрын
There’s a lot to like about the new interface design, but buttons is one thing that I’m not completely fond of because now we don’t really have any choice about where the buttons live. I keep thinking this is going to change again, I guess because it doesn’t really feel right to me. I really like the new dashboard layout in the way that you can drill into numbers, graphs and pivot tables. I’m finding so many uses for this. I can build a complete app out of the dashboard now.
@GarethPronovost
@GarethPronovost 7 күн бұрын
I agree, the buttons are a bit tough to find and not as customizable as I want - however I really love the functionality and different things that buttons now make possible! With software updates, I try to remind myself to take the bad with the good... 🙂
@jeremymurphy7475
@jeremymurphy7475 23 күн бұрын
Love your videos, they have beena a great help and inspiration..........#1 ---> How to create Airtable fields in bulk.... since importing a .csv does not do it
@GarethPronovost
@GarethPronovost 7 күн бұрын
It depends on how much data you are adding at once. Typically, I just copy/paste a table - this works for several thousand records at a time.
@YveGoodfolk
@YveGoodfolk 23 күн бұрын
Hi Gareth! Thank you so much for sharing this! It will be a big help for my organization. However, I keep getting the error "There is no scenario listening for this webhook" when I push the button. I believe the Watch Responses module isn't passing the record_id. I can't see the record_id in the Get a Record module, even though the record info flows through the Drive module to the Update a Record module. I'm finding this a bit confusing. Could you please help me out? 🙏 Thanks!
@GarethPronovost
@GarethPronovost 7 күн бұрын
I think you may have an error in the webhook URL - it sounds like there's not a match. Double check the webhook URL and make sure it's exactly correct (case sensitive).
@Festis_Festis
@Festis_Festis 23 күн бұрын
I Want to Type In Airtable Workspace That Is Not Created By Me Can You Help Me
@davidsmiththeaiguy
@davidsmiththeaiguy 23 күн бұрын
Get the owner to build a form, paste the form URL as the destination of the "Go To Website". I have used this solution a lot. Saved me $'s as read only users can update a base
@GarethPronovost
@GarethPronovost 7 күн бұрын
You'll need editor access - reach out to the person who created the Airtable Workspace and request to be upgraded
@GarethPronovost
@GarethPronovost 24 күн бұрын
Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓