Wait i will upload the code that i am using to store the enteries in my excel, then please see and let me know...because i tried everything i could yet it does not function
Collect(
EntriesCollection,
{
'Haunted House': HH1,
Date: Today(),
Hour: Text(times),
'10 Min Duration':Text(tentime),
'10 Min Count': 5,
'Hourly Count': 5,
'Total Count':5
}
);
UpdateContext({ HourlyCount: Sum(Filter(EntriesCollection, 'Haunted House'= HH1,Hour= Text(times)),'Hourly Count') });
UpdateContext({ DailyCount: Sum(Filter(EntriesCollection, 'Haunted House'= HH1,DateValue((Date)) = Today()), 'Total Count') });
UpdateContext({ TenCount: Sum(Filter(EntriesCollection, 'Haunted House'= HH1,Hour= Text(times),'10 Min Duration'=Text(tentime)),'10 Min Count') });
If(
IsEmpty(
Filter(
NT,
'Haunted House' = "HH1" && '10 Min Duration'=Text(tentime) && DateValue((Date)) = Today()
)
),
Patch(
NT,
Defaults(NT),
{
'Haunted House': "HH1",
Date: Today(),
Hour: Text(times),
'10 Min Duration':Text(tentime),
'10 Min Count':TenCount,
'Hourly Count': HourlyCount,
'Total Count': DailyCount
}
),
UpdateIf(
NT,
'Haunted House'= "HH1"&& Hour= Text(times) &&'10 Min Duration'=Text(tentime)&& DateValue(Text(Date)) = Today(),
{
'10 Min Count':TenCount,
'Hourly Count': HourlyCount,
'Total Count': DailyCount
}
)
);
This is the code to store 10 min count , hourly count and total count
Then to
