Skip to main content

I have an external dropbox folder that has three files that change at  4pm everyday.


URL looks like this:

https://www.dropbox.com/sh/pa/09.07.22-BARCODE%20no%20double.xlsx?dl=0
 

I would like to look like this so I can change the date every day and email me a copy of the file in an attachment.
DD.MM.YY
https://www.dropbox.com/sh/pa/DD.MM.YY-BARCODE%20no%20double.xlsx?dl=0


I tried the formatter to change the date but it change the https and other data in the URL string.

So, in a nutshell, I want to schedule an email daily based on todays date and change the URL string the email attachment and send it to myself.

@Troy Tessalone Bingo, you are correct. Now my issue is with dropbox. I dont own the folder and its has a file that changes name everyday (date changes in its name). The issue is that since its a new file the URL string for download changes. I’m not sure there is a solution to my problem.


Heya @Bryka! Just checking in to see if you were able to get this sorted using @Troy Tessalone’s tips?

Keep us posted - we’d love to know. 🙂


Hi @Bryka 

Good question.

In Zap fields you can use a combination of static values and dynamic variables.

Use the Formatter to get the Date in the desired Format.

Then in the Zap field try this:

https://www.dropbox.com/sh/pa//DD.MM.YY]-BARCODE%20no%20double.xlsx?dl=0

Replace DD.MM.YY] with the output from the Formatter step.