Skip to main content

Hi,

We fetch image links from one tree structure of Google Drive folders with the “New file in folder” trigger and transfer them to our CRM in Airtable. Google Drive is our storage and sharing back-end, but we need to show the images also in the CRM.

The current file structure is like this:

- Client Delivery
   -- yyyy-mm-dd <Client Name 1>
      - file 1
     - file 2
     - file...
   -- yyyy-mm-dd <Client Name 2>
   -- yyyy-mm-dd <Client Name ...>

 

However, we would now need to fetch two separate kinds of images for the same client. These need to go to separate places in the CRM, one for final client deliveries (the scenario above), and one for “client inspiration”. Therefore I see this as two different zaps.

This is how I would like to organise the file structure, so that we have only main folder per client:

- Client Data
   -- yyyy-mm-dd <Client Name 1>
      -- Client Delivery
            - file 1
            - file 2
            - file...
      -- Client Inspiration
           - file 1
           - file 2
           - file...


However, in the configuration for the “New file in folder” I can only choose one top folder (until now it would be “Client Data”). What I would like to achieve is two Zaps, where one would trigger from this:

- Client Data
   -- yyyy-mm-dd <Client Name 1>
      -- Client Inspiration

and the other would trigger from this:

- Client Data
   -- yyyy-mm-dd <Client Name 1>
      -- Client Delivery
 

In addition to the “Static” choice of one folder there is an option for “Custom”, but there’s no information on what on could do with it. Would it e.g. be possible to use regex here to include/exclude either of the under folders under “Client Name”?
 

Or could this be achieved some other way?

Thanks in advance,

Björn

Hi ​@BjörnE 

Help links for understanding the field expected value for dropdown field types.

https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

Static means select from the shown list.

Custom means you can manually set a static value or map a dynamic variable value.

 

 


Hi ​@Troy Tessalone,

Thank you! I’m sorry, I forgot to mention that I had already read that help page. Unfortunately it doesn’t really say what can be done with the custom values, nor how it should be used. Only thing I get from it, is that one could hardcode an ID value that can be found within the static listing, but I fail to understand how that could be helpful. I suspect regex could be of help, but it doesn’t look like that could be used here.

Would you know of any other help sources, with more thorough explanations and examples, that I might have missed?

Rgds,

Björn


@BjörnE 

The help page about how to add custom values to dropdown menu fields in Zaps describes that a dropdown list expects the bottom value for an option.

e.g. If you were trying to dynamic map a variable for a field and wanted to select “Jimi Hendrix”, then the dynamic variable value must be: 6

In other words, passing a value of “6” means you’ve selected “Jimi Hendrix”.

 

https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

 

RegEx can NOT be used in the dropdown field types.

 

Would you know of any other help sources, with more thorough explanations and examples, that I might have missed?

TIP: Try asking ChatGPT for help explaining concepts and include screenshots from your Zap step config.

 

 

 


Hi ​@BjörnE,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


Thank you ​@Troy Tessalone

The way you explained it confirms the notion I got from Zapier’s help page. I frankly just couldn’t believe it was like that, since I don’t understand the reason why it’s built that way. Can’t see the use for something like that, I hoped for something else, like regex. But anyway, thanks, I’ll be looking at other ways around this.

Cheers,

Björn


@JammerS, thanks for following up. As I replied to Troy, I don’t understand the need and use for this “static” choice, but otherwise I’m now sorted 🙂.

Cheers,

Björn


That’s great to hear that everything is now sorted ​@BjörnE!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗