Context:
I am building a voting form (of sorts) for a recurring annual process at work. The form needs to capture nominations, but the total allowed nominations per vote will vary from year to year. I have setup a global variable to indicate what this "total nominations allowed" will be:
Problem:
In order to capture nominations I created a collection that feeds into a gallery control which the user can interact with in order to make their selections.
How can I pre-emptively create the collection and add X empty records based on "total nominations allowed" number above?
I'm trying to avoid the solution below as I would need to adjust this piece of code every year depending on that "total nominations allowed" number:
ClearCollect(colNominations,
{col1: Blank(), col2: Blank(), ... , coln: Blank()},
{col1: Blank(), col2: Blank(), ... , coln: Blank()},
....
{col1: Blank(), col2: Blank(), ... , coln: Blank()}
)