Hi All,
Is there a way to change the behaviour of a format rule to execute BEFORE a data sync has occurred?
I’m porting some app config across from our DEV app to our Test app but I’m stuck on the performance of a Format Rule.
In our DEV app, we have a format rule to change an action icon to a green tick after it’s executed.
In DEV, it changes the icon instantly, even before the action’s changes have synced to the sheet.
However our TEST app waits until AFTER the changes have synced to the sheet before the graphic changes.
In TEST, the icon does change correctly, so the format rules are working, but it’s significantly slower compared to the DEV version.
The source data sheet and calculations are (should be) close to identical.
App spec & goals:
Goal: Allow known people to check-in to our venue by selecting their own profile pic from a deck view.
Setup:
v-column count code:
Attendance Count: Count a person’s check-ins today. Used by the format rule to mark a green tick.
COUNT(
FILTER(
"Attendance",
AND(
([check-in Date] = today()),
([Membership Number]=[_THISROW].[Membership Number])
)
)
)
Pics attached below for reference.
Thanks in advance.
Tim
Solved! Go to Solution.
Thanks MultiTech, I really appreciate your reply.
I’ll have a go at switching to the method you suggest and report back.
For what it’s worth, I also discovered the reason why the TEST version was slow!
There was a mis-match between the key columns of the two versions.
The DEV Members table used MemberID as the key, and the Related Attendances ref’d this to the Attendance table.
The TEST Members table used a UniqueID column as the key, but “MemberID” was ref’d to the Attendance table.
I updated both apps to use (and properly reference) the UniqueID column as the key, and now the format icon updates instantly, while the data sync occurs in the background.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |