Is there a way to access a value calculated using an expression with the Toolbox Plugin?
I have a repeating group which is grouped to show a leaderboard of players scores.
I’m using the expression plugin to compare the current cell with the previous and next cells to calculate the leaderboard position (and show an '= sign for values that are the same)
This is displaying exactly how i want in the repeating group
But I need to write these values either to the database or to a google sheet via an API.
Problem is, the only elements i can reference are the sum of values (the score) or the Player. I have no option to access value calculated by the expression (i.e. the value in the blue box).
Hey @craigDS its great you got a ranking method to work!
Consider if the page is opened by an untrusted user, calculations done on the page should not be trusted, i.e. someone could alter the calculation or the rank before the rank is saved.
Consider that the rank is indirect data, so perhaps don’t store the rank but calculate it for display, including in google sheet.
Consider re-implementing the method of ranking, so it is not dependent on being inside a repeating group.
For example, if done with javascript, it can be run on the backend in a server script. Or on the page with run javascript, and the ranks made available in javascript to bubble.
If you give it a try with javascript, me or anyone else can help with the specifics.
