How do I schedule an email based on today's date, change the attachment URL, and send it to my email?

Question

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 · Accepted Answer

Hi @BrykaGood 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=0Replace [DD.MM.YY] with the output from the Formatter step.

christina.d · Answer

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. 🙂

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded