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!
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.
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.
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
@@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.
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
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?
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
@@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?
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-O4JDCFKnzPo.html
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?
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)