show a wait image while a Collection is being loaded

[Anonymous]

I have a weird problem:

I'm trying to show a gif image while a collection is being loaded from a text box of data.

No image will  show or any variables execute. 

i have the variables set at the beginning of the button push.

Nothing will execute until the collection is fully loaded ??

UpdateContext({varShowSpinnerWait: true})
;
Clear(colFinal)
;
Clear(colSplitBy10)
;
Clear(colSplitBy10Filtered)
;
Clear(colWithRowNumbers);
Clear(colWithColumnNumbers);

Set(VarStartTimer_Import, false)
;
Set(ShowSuccessButton, false)
;
/// to start the engine for timing
Set(VarStartTimer_Import,true)

;

/////   none of the above code will execute until ColFinal is loaded into the Collection

//I broke things up into a lot of little steps to make what is happening as clear as possible
//Split the text into a table with rows by the new line character

Set(varGuid,GUID())

;

ClearCollect(colSplitBy10,
Split(
Substitute(Substitute(TextInput5.Text, "$", ""), "%", ""),
Char(10)
)
);

//Filter out any blank rows
//You could combine this with the above step to be more effecient
ClearCollect(
colSplitBy10Filtered,
Filter(
colSplitBy10,
Not IsBlank(Result)
)
)

;

UpdateContext({PopupWaitScreen:true})

;

//This collection gets built by ForAll and Collect, so you need to reset it each time you press the button
Clear(colWithRowNumbers);
//This is code I have used for years to add row numbers to a collection
ForAll(
colSplitBy10Filtered,
Collect(
colWithRowNumbers,
Last(
FirstN(
AddColumns(
colSplitBy10Filtered,
"RowNumber",
CountRows(colWithRowNumbers) + 1
),
CountRows(colWithRowNumbers) + 1
)
)
)
);
//Variable is how I know how many columns I had
Set(
varNumberOfColumns,
CountRows(
Split(
First(colWithRowNumbers).Result,
Char(09)
)
)
);
//This collection gets built by ForAll and Collect, so you need to reset it each time you press the button
Clear(colWithColumnNumbers);
//This makes a table with all of the cells in their own rows
ForAll(
colWithRowNumbers As MyRows,
ForAll(
Split(
MyRows.Result,
Char(09)
) As MyNew,
Collect(
colWithColumnNumbers,
Patch(
MyRows,
{
ValueColumn: MyNew.Result,
ColumnNumber: Mod(
CountRows(colWithColumnNumbers),
varNumberOfColumns
) + 1
}
)
)
)
);
//This collection gets built by ForAll and Collect, so you need to reset it each time you press the button
Clear(colFinal);
//This only works for up to 3 columns as written
ForAll(
colWithRowNumbers As CWRN,
Collect(
colFinal,
{
Column1: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 1
).ValueColumn,
Column2: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 2
).ValueColumn,
Column3: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 3
).ValueColumn,

Column4: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 4
).ValueColumn,
Column5: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 5
).ValueColumn,
Column6: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 6
).ValueColumn,

Column7: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 7
).ValueColumn,
Column8: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 8
).ValueColumn,
Column9: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 9
).ValueColumn,

Column10: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber =10
).ValueColumn,
Column11: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 11
).ValueColumn,
Column12: LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 12
).ValueColumn,
Column13: Upper(LookUp(
colWithColumnNumbers,
RowNumber = CWRN.RowNumber And ColumnNumber = 13
).ValueColumn)

}
)
);
UpdateContext({ShowBannerLock: false})
;
Set(varShowSpinnerWait, false)

Thanks Dave

[ProgrammerJaDe · Accepted solution]

Without digging too deep into your code, let me give you a few of my tips for this type of solution.

1. Replace your button with a timer, onselect turn on the loading gif, set timer to something fast, maybe 250 ms and on timer end, start your collection work. This might help you with the sequence of actions.

2. I always have issues with visible on/off for things likes Gifs, especially if the software doesn't render controls until they are visible this creates an issue. Instead, my gifs are visible 100% of the time, but I use an if statement to change the x value, and when my loading is false, x=-150 or -(self.Width) so its outside of the screen. When you change x locations it seems to be more instantaneous when the image is already visible (even if its off screen).

Let me know if either of those helped!

[Anonymous]

@ProgrammerJaDe , Thanks...#1 suggestion worked perfectly.

Thanks for replying !!

Dave