Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Great tutorial! I don't need this feature yet, but it's good to know as it creates a lot of exciting possibilities! Thanks to you (and your client) for sharing.
@@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 !
Lots of hard limitations here that leave room for error, but there are some improvements you can make: 1 - You don't need an automation at all to find, check and uncheck records. Use a rollup or count to check how many 'service records without a contact' exist. If > 0, it needs to be dynamically looked up. Use that field as your condition for the show/hide. 2- As you mentioned, this wouldn't work for any kind of editing an existing record (only new ones), but you could likely use 'last modified' everywhere to decide whether or not a company (or all of the records it's linked to) has been changed recently in order to include it in the dynamic list. 3 - You will always end up with some mistakes made here, so you will need a checks and balances automation to run and trigger when {Company (from Contact)} != {Company}, and either clear the field or display a validation issue.
Also using a field with an "if" formula to put a character (for example "1") when client is not empty and Company is empty. Then, filter client view by this character. Formula example: IF(AND(Company!="",client=""),1,""). Has any of you a workaround to try this behavior on a form?
Yes, I should have said add a step to check all the Dynamic filter boxes in the Customer table after choosing a contact. I'll share a base with you in a bit where I've been playing with this feature. @@GarethPronovost
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡
Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Great tutorial! I don't need this feature yet, but it's good to know as it creates a lot of exciting possibilities! Thanks to you (and your client) for sharing.
This is pure genius!!
Thanks, but now Airtable has dynamic filters available so you don't even need the workaround!
@@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 !
@@Julie-Dox amazing!
I've been using this method for half a year now, it's very useful.
So cool!
Lots of hard limitations here that leave room for error, but there are some improvements you can make:
1 - You don't need an automation at all to find, check and uncheck records. Use a rollup or count to check how many 'service records without a contact' exist. If > 0, it needs to be dynamically looked up. Use that field as your condition for the show/hide.
2- As you mentioned, this wouldn't work for any kind of editing an existing record (only new ones), but you could likely use 'last modified' everywhere to decide whether or not a company (or all of the records it's linked to) has been changed recently in order to include it in the dynamic list.
3 - You will always end up with some mistakes made here, so you will need a checks and balances automation to run and trigger when {Company (from Contact)} != {Company}, and either clear the field or display a validation issue.
Great insights! Using a rollup would certainly be more efficient and I love the idea of removing contacts that are linked improperly with automation
Also using a field with an "if" formula to put a character (for example "1") when client is not empty and Company is empty. Then, filter client view by this character. Formula example: IF(AND(Company!="",client=""),1,"").
Has any of you a workaround to try this behavior on a form?
this is nothing short of brilliant!
Thanks for watching! 😄
What an awesome idea! 🤩
I was thoroughly impressed!
Is it safe to say that this would not work if multiple people were using the interface page at the same time?
That would definitely cause issues
This is an interesting work around for sure
I was super impressed when our client shared this with us!
Very clever workaround. Definitely some very significant limitations. Does SmartSuite handle dynamic filtering?
Yes it does!
Does SmartSuite have dynamic filtering natively?
Yes indeed it does ✅✅
Creative workaround! Can't believe airtable don't have that yet🤦♂️what other dB solutions offer this feature?
SmartSuite allows for this out of the box!
Idea to address the last limitation: Move the 3rd automation step (unchecking) to the end and create a delay before it runs.
Does that open up a new set of limitations or am I thinking wrong?
Yes, I should have said add a step to check all the Dynamic filter boxes in the Customer table after choosing a contact. I'll share a base with you in a bit where I've been playing with this feature. @@GarethPronovost