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
I had to add a 'Factorial' column to the original text input that was the same values as the 'Number' column to set up my macro:
Spoiler
Each iteration updates that 'Factorial' column until it's completed.
Rather odd, it's such a simple form it doesn't need an iterative macro, so it took me a minute to figure out how to force one. Momentary hiccup on data format (hint). Good exercise to work through however.
Only going to bother with the macro since the other is just input/macro/browse per requirements.
I've previously always initialized the field being calculated to pass into the macro, so this was a challenge! Looks like a union with a Text Input to ensure the field is the way to go.
My solution, macro attached
Spoiler
A neat challenge, thank you. Helped me learn iterative macros. I used a similar approach to @ahsanaali! Thank you, @ahsanaali for pointing me in the right direction!
A neat challenge, thank you. Helped me learn iterative macros. I used a similar approach to @ahsanaali! Thank you, @ahsanaali for pointing me in the right direction!
