Hi,
I'm trying to updatecontext for a progress bar when creating a collection. After/before filter, that takes place I am trying to increment the locloadingpercentage by 0.05. When I add the updatecontext to the formula, it doesn't create the full collection, any suggestions?
Set (varLoading, true);
UpdateContext({
locLoadingMessage: "Preparing",
locLoadingPercent: 0.05
});
Refresh(RegisteredKits);
Refresh(Wards);
UpdateContext({
locLoadingMessage: "Loading Wards",
locLoadingPercent: 0.07
});
Refresh(Documents);
UpdateContext({
locLoadingMessage: "Loading Documents",
locLoadingPercent: 0.10
});
Refresh(NonNSFTStaff);
UpdateContext({
locLoadingMessage: "Loading Staff",
locLoadingPercent: 0.15
});
Refresh(DistributedKits);
UpdateContext({
locLoadingMessage: "Loading Distributed Kits",
locLoadingPercent: 0.17
});
UpdateContext({
locLoadingMessage: "Loading Registered Kits",
locLoadingPercent: 0.2
});
UpdateContext({
locLoadingMessage: "Please Wait",
locLoadingPercent: 0.3
});
ClearCollect (
colKitData,
Filter (
RegisteredKits,
IsBlank(BoxNumber)
),
Filter (
RegisteredKits,
BoxNumber > 0 && BoxNumber < 500
),
Filter (
RegisteredKits,
BoxNumber >= 500 && BoxNumber < 1000
),
Filter (
RegisteredKits,
BoxNumber >= 1000 && BoxNumber < 1500
),
Filter (
RegisteredKits,
BoxNumber >= 1500 && BoxNumber < 2000
),
Filter (
RegisteredKits,
BoxNumber >= 2000 && BoxNumber < 2500
),
Filter (
RegisteredKits,
BoxNumber >= 2500 && BoxNumber < 3000
),
Filter (
RegisteredKits,
BoxNumber >= 3000 && BoxNumber < 3500
),
Filter (
RegisteredKits,
BoxNumber >= 3500 && BoxNumber < 4000
),
Filter (
RegisteredKits,
BoxNumber >= 4000 && BoxNumber < 4500
),
Filter (
RegisteredKits,
BoxNumber >= 4500 && BoxNumber < 5000
),
Filter (
RegisteredKits,
BoxNumber >= 5000 && BoxNumber < 5500
),
Filter (
RegisteredKits,
BoxNumber >= 5500 && BoxNumber < 6000
),
Filter (
RegisteredKits,
BoxNumber >= 6000 && BoxNumber < 6500
),
Filter (
RegisteredKits,
BoxNumber >= 6500 && BoxNumber < 7000
),
Filter (
RegisteredKits,
BoxNumber >= 7000 && BoxNumber < 7500
),
Filter (
RegisteredKits,
BoxNumber >= 7500 && BoxNumber < 8000
),
Filter (
RegisteredKits,
BoxNumber >= 8000 && BoxNumber < 8500
),
Filter (
RegisteredKits,
BoxNumber >= 8500 && BoxNumber < 9000
),
Filter (
RegisteredKits,
BoxNumber >= 9500 && BoxNumber < 10000
)
);
UpdateContext({
locLoadingMessage: "Kits Loaded",
locLoadingPercent: 0.8
});
// Collects and groups the records by ward/team
ClearCollect(
colKitsGrouped,
SortByColumns(
GroupBy(
AddColumns(
colKitData,
"WardTeam",
WardorTeam
),
"WardTeam",
"WardTeamGroup"
),
"WardTeam",
Ascending
)
);
UpdateContext({
locLoadingMessage: "Preparing Data",
locLoadingPercent: 0.9
});
// Adds a row number to be used later when filtering the galleries
Clear(colKitsGroupedRowNo);
ForAll (
colKitsGrouped,
Collect(
colKitsGroupedRowNo,
Last(
FirstN(
AddColumns(
colKitsGrouped,
"RowNumber",
CountRows(colKitsGroupedRowNo) + 1
),
CountRows(colKitsGroupedRowNo) + 1
)
)
)
);
UpdateContext({
locLoadingMessage: "Complete",
locLoadingPercent: 1.0
});
Set (
varLoading,
false
);
Thanks
