re: Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.
Yeap, I've done this exact thing before with Zapier, works fine!
@0800-grizzly
Yes, you can use either Zapier or Make to do either of those 2 different methods that you said you would like to do.
If you'd like to save money & gain power, I always recommend to everybody that they should think about switching away from Zapier to Make, because it is SIGNIFICANTLY cheaper than Zapier, yet it is INFINITELY more customizable & INFINITELY more powerful.
I wrote an entire post here comparing Make vs. Zapier: https://air.tableforums.com/t/make-vs-zapier/737
— ScottWorld, Expert Airtable Consultant
re: Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.
Yeap, I've done this exact thing before with Zapier, works fine!
Thanks @TheTimeSavingCo, got this working easily!
One follow-up question: I couldn't get Zapier's search formula for looking for several fields in Airtable to work.
This is the formula I'd like to to have for now:
{Sähköposti}="{{254014963__title}}"&{Projektin status}="Työn alla"
Tested separately both {Sähköposti}="{{254014963__title}}" and {Projektin status}="Työn alla", so I suspect it my combining them with an ampersand that doesn't work. I get "no results found" with the full combination.
@TheTimeSavingCo, can you find the error in this?
Björn
@0800-grizzly
Yes, you can use either Zapier or Make to do either of those 2 different methods that you said you would like to do.
If you'd like to save money & gain power, I always recommend to everybody that they should think about switching away from Zapier to Make, because it is SIGNIFICANTLY cheaper than Zapier, yet it is INFINITELY more customizable & INFINITELY more powerful.
I wrote an entire post here comparing Make vs. Zapier: https://air.tableforums.com/t/make-vs-zapier/737
— ScottWorld, Expert Airtable Consultant
Thank you @ScottWorld. I have followed your praise for Make, but have gotten used to Zapier so will stay there until something forces me to decide differently.
Rgds,
Björn
Thanks @TheTimeSavingCo, got this working easily!
One follow-up question: I couldn't get Zapier's search formula for looking for several fields in Airtable to work.
This is the formula I'd like to to have for now:
{Sähköposti}="{{254014963__title}}"&{Projektin status}="Työn alla"
Tested separately both {Sähköposti}="{{254014963__title}}" and {Projektin status}="Työn alla", so I suspect it my combining them with an ampersand that doesn't work. I get "no results found" with the full combination.
@TheTimeSavingCo, can you find the error in this?
Björn
Ah, try:
AND({Sähköposti}="{{254014963__title}}",{Projektin status}="Työn alla")
It expects you to use Airtable's formula syntax, and so we use `AND()` instead of `&`