Can I create a points ranking with my App?

[neardj]

Hi,
I need your help.

Do you think it is possible to create a points ranking through APPSheet?

I have two tables in my app.
My first table is called “T_FORMAZIONI_DB” and contains the columns:

• IDFORMAZIONEDB
• ID_CICLISTA
• CODICE_AGGREGATIVO

this table shows the cyclists that each coach has selected for a specific race.

The second table is called “T_RISULTATI” and contains these columns:

• IDPUNTI
• ID_CICLISTA
• IDCORSA
• PUNTI
• CODICE_AGGREGATIVO

How can I create a UX view that summarizes the points made by a team present in the results table only if ID_CICLISTA and CODICE_AGGREGATIVO of that row are present in the “T_FORMAZIONI_DB” table?
It’s possible?
Thank you
Luigi

[Steve]

I’d think you could add virtual columns to T_FORMAZIONI_DB that compute the summaries you want per team.

[neardj]

Can I use the LOOKUP function to recall the points made only with that “CODICE AGGREATIVO”? But does LOOKUP function support the verification of two values? Why should I consider ID_CICLISTA and CODICE AGGREGATIVO.

[Steve]

You’d want to use SELECT() rather than LOOKUP().

[neardj]

Can I ask you an information? The SELECT command for AppSheet to which programming language?

I am trying to find information in my language.
I am a beginner and with the examples in English I find it difficult to apply them to my specific case.

[Steve]

neardj:

Can I ask you an information? The SELECT command for AppSheet to which programming language?

I’m afraid I don’t understand.

Please describe what you want in plain language (as if speaking to someone who doesn’t use computers) and I will try to provide further advice.

[neardj]

I’m sorry it’s me who doesn’t speak English well.
I wanted to know which language to use to insert expressions on Appshet.
The “SELECT” command is used in various programming languages such as SQL, MySQL, etc. What programming language should I study to use the function on the AppSheet?

[Steve]

AppSheet expressions is its own language. It is most similar to Excel spreadsheet formulas, but is also very different. I’m afraid I’m not aware of resources for learning AppSheet in other languages.

[neardj]

After days of trying I almost succeeded in my intent to also have the ranking within the app.
Thanks to your tip on Excel sheet formulas I was able to do some things.
Maybe you’ll take me for crazy but I did it like this:

• directly within the Google Sheet I created a column containing an array that generates a unique reference for me to control the formations sent;
• I also created a “TITOLARE” column containing the formula = ISNUMBER (MATCH (F2; T_FORMAZIONI_DB! D $ 2: D; 0))
  if the result is true it means that the cyclist has been deployed;
• I created a column “POINTS_CLASSIFICATION” with a simple formula like = IF (G2 = TRUE; D2; “”) it extracts only the points of the cyclists actually lined up.
• inside AppSheet in the table “T_RESULTATI_CLASSIFICA” I created a virtual column with this formula:

SUM (
SELECT (
T_RESULTS_CLASSIFICATION [POINTS_CLASSIFICATION],
AND (
ISNOTBLANK ([_ THISROW]. [CLASSIFICATION_POINTS]),
([CLASSIFICATION_POINTS] = [_THISROW]. [CLASSIFICATION_POINTS])
),
TRUE
)
)

I have created this UX view:

but to finish my work I would need to sort the UX View table list by putting the total score from largest to smallest (as I wrote in red in the screenshot).
I am unable to place the order on “Group by”
How can I do?
Thanks
Luigi