Solved: Different Folders each day for attachments - Page 2

Dan_Oliphant · 10-02-2020 07:54 AM

I am wondering if its possible to dynamically change the folder used for the attachments based on date. In other words, we send out bills clients daily, and I would love to have a different folder in drive each day with the bills. Can you have the filepath be dynamic?

Suvrutt_Gurjar

If I have correctly understood your requirement, yes one can have dynamic folder path.

Appsheet can create a folder path on its own on a daily basis as you need.

You could name the folder path something like below. It will create a new folder such as “ByDate-10022020” with changing date daily , under main folder “ClientBills” in the example below. You could suitably change the folder names etc.

CONCATENATE(“ClientBills/ByDate-”, TEXT(TODAY(), “MMDDYYYY”))

My latest testing showed that one can name the expression without enclosing it in << >> parenthesis as mentioned in article.

View solution in original post