Airtable Limitations (& how to overcome them) | No-code Tutorial

[@GarethPronovost]

Grab my *FREE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration 👈

[@francisokech]

I asked and you delivered. Thank you Gareth.

[@GarethPronovost]

Glad to be of service! 😂

[@frankdrolet9439]

Love your channel, thanks Gareth! Keep up the good work!

[@GarethPronovost]

Thanks Frank! 🙏

[@UniversusTech]

At 8:20, you indicate placing a link below for a video on overcoming the view only share with a button automation. Where is this link/video ?

[@ithinkigottalent4047]

You're the man, Gareth!!!

[@GarethPronovost]

Happy to help! 🙏

[@carlossalinas3711]

Great content!! Quick question: how do you limit words in an airtable form? If I only want a response to be under 200 words, what formula would I use, or what do I need to do to have it limited? Thanks in advance for all your help!

[@charliekelland7564]

6:58 - did you mean stakeholder? Fantastic info as always, thank you Gareth 👍

[@GarethPronovost]

lol, oops!

[@michaelsargent157]

I don't understand for limitation #2 why you wouldn't use synced bases? I would simply create a view I want the other person to see and sync it into a new base and then share that base with them.

[@ChristopherManke]

Thanks as always! I love your content. New music…nice.

[@GarethPronovost]

Thanks for noticing! 😉

[@carl-w3r]

When did you start preferring Make over Zapier? so far Zapier is still my favorite, though I think they need a better free/low-cost plan.

[@GarethPronovost]

It has been a gradual shift for me. My current opinion is that Zapier is best for automation beginners. Make is a bit more complex, but more powerful too

[@carl-w3r]

@@GarethPronovost I'll have to play with Make some more. I've done a few simple things in it as a demo, but haven't ran into any road blocks with Zapier that have pushed me to learn Make more thoroughly.

[@marcuslayton9036]

Hey there! Do you have a video you've made for the more recent version of Glide? It now integrates with Airtable and may trump Softr regarding the extent of what you can do with it and its customisability etc. Cheers

[@GarethPronovost]

Hey Marcus, I haven't done a video on Glide sorry! We haven't used it much here so I don't have experience with that tool 🤷‍♂️

[@ChristopherManke]

Will you be covering Jott forms new marketplace tools? I’m curious about these.

[@GarethPronovost]

I don't have plans to at this time - haven't had a chance to get into them yet

[@sergiomendoza9464]

Hi, I have a question regarding the archived copy to overcome the record limitation - how is the uniqueness of the record is managed in that case? is a copy archived creating a duplicate of my original record?

[@GarethPronovost]

When a copy is created, all copied records are unique, meaning they have their own record IDs that are specific to the new copied base. It creates a duplicate of your original record (so you can delete the original, now that an archive exists)

[@anuj269]

Nice video. Just a question. Is it possible to extract cell which are highlighted in airtable to be pushed into this code?

[@GarethPronovost]

How do you wish to extract a cell? This is possible to do as a formula output, for example - was there another way you wanted to get this result?

[@gooddaycommander4657]

Thank you for such an informative video! Is there a no-code way to make an SQL view? I.e. TableC which is a JOIN on tableA.Itemid = tableB.Itemid ?

[@GarethPronovost]

In a way, yes. It's different from what you've described because we always like to a record using the primary field, then we can lookup the other relevant fields in Airtable. That said, you can check out this video about junction tables in Airtable for some inspiration kzbin.info/www/bejne/hWWtdXZ8gNOthtE

[@francisokech]

Question: The process for managing non-user bases / tables appears to be straightforward per your explanation. However, how do you manage record limitations for user bases / tables. This is important because this base / table determines access control, etc. Assuming I am nearing 100,000 records / users in my user table or 250,000 users in my entire base, what do I do? I can't delete users, so what do I do?

[@GarethPronovost]

Hi - not sure when you have a user table, unless you are using Airtable to create a Softr/Stacker app. Is that the case here? Otherwise, if you're just using Airtable, you don't need a user table - your users live at the "shared base" level

[@francisokech]

@@GarethPronovost Yes Sir, I'm referring to having a users table for softr access control. If my membership website is really killing it and I'm nearing the 50k or 100k limit for user records, what do I do? Also, have you heard about Xana?

[@ambroisedhenain]

Interesting, but not often as simple as what you imply. Duplicating databases doesn't work well as soon as you start using 3rd party tools (Noloco, Softr, Stacker, etc.), it's a workaround that works "fine" for some stuff, but it does increase the overall complexity by a huge margin. For "beginners", I'd rather recommend Noloco than Softr, especially if you want to build a "back office". The UX is much better.