I am trying to update a field for an input tool (Amazon S3 download) without user input. The file location changes based on the date, so in order to pull data I would need to update the flow every day. The Bucket format is ".../[User]/[Location #]/[yyyymmdd]." I want to schedule this on server to run every day and pull the latest file. In order to do this I need to update the [yyyymmdd] part to something like...
ToString(DateTimeYear(DateTimeAdd(DateTimeNow(),-1,'days')))+
ToString(DateTimeMonth(DateTimeAdd(DateTimeNow(),-1,'days')))+
ToString(DateTimeDay(DateTimeAdd(DateTimeNow(),-1,'days')))
**assuming there is a better way, just throwing this out there...it also doesn't account for 2 digit day.
My issue is getting the Bucket Field to update without any user input/questions. Does anyone have a solution or something similar?
Assuming this is going to be a flow that runs a macro on server, but I'm not sure how to use the input tool to update the Bucket field since you can't use input as a question.
Thank you for your time & help
Solved! Go to Solution.
Figured this out!
I used a standard Macro and was able to schedule this on server.
Build Macro
Open new standard workflow