Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
Slightly changed the original macro (added the date selection tools) and created a batch macro from the original flow. Then build a new small workflow:
Spoiler
Simple solution:
I added a condition to swap the Start and End dates in the filter if the user entered them backward (e.g. 7/1/2019 for the start date and 6/1/2019 for the end date).
Also, I assumed that the calendar input was necessary (and we couldn't just generate the list of dates between Start and End using a Generate Rows tool).
Form:
Batch marco solution (to process each day individually:
I don't really understand the use case for this (why you would need to process each date separately), but here it is!
I added a condition to swap the Start and End dates in the filter if the user entered them backward (e.g. 7/1/2019 for the start date and 6/1/2019 for the end date).
Also, I assumed that the calendar input was necessary (and we couldn't just generate the list of dates between Start and End using a Generate Rows tool).
Form:
Batch marco solution (to process each day individually:
I don't really understand the use case for this (why you would need to process each date separately), but here it is!
I was expecting to make a macro, but I've made an app instead!
I'm not quite sure I understand the bonus question. I did some transposing and dynamic renaming so you get a line of data per date with multiple previous dates (if you type multiple dates into the app). But I wondered if this was a batch macro thing... Looking forward to seeing what others have done!
