Best answer

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

  • 8 September 2022
  • 3 replies

Userlevel 1

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

URL looks like this:

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.

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.


Best answer by Troy Tessalone 8 September 2022, 04:56

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

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:[DD.MM.YY]-BARCODE%20no%20double.xlsx?dl=0

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

Userlevel 7
Badge +9

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

Userlevel 1

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