Skip to main content
Solved

Scavenger hunt app results

S

Hello,

I’m new to Airtable and I seem not be able to understand how to play with it, that’s why I’m asking for some help.

I built an app for scavenger hunt where the user needs to find some QR Codes around the area. Once found the QR code, they scan it with the app and get some points according to the difficulty.

The app sends and stores immediately the points from a specific user as in one columns I have all users which scans the codes and the other with the points they collected. Something like:
Admin - 30
Admin - 10
User1 - 30
User2 - 10
Admin - 30
User2 - 10
User2 - 10
User1 - 10

What I would like to know is:
-How can I sum up the points done from each user so that I can have some kind of result list?
My idea is to have something like:
Admin 70 points
User1 40 points
User2 30 points

Any help is really appreciated. :slightly_smiling_face:

Best answer by andywingrave

Ah ok!

Here you go. You want to create a table for the scans, and then roll them up :grinning_face_with_smiling_eyes:

Feel free to copy this template:

The totals are in the second tab. Hope it’s clear what I’ve done here

View original
    Did this topic help you find an answer to your question?

    4 replies

    A
    Forum|alt.badge.img+19

    Hey there - Just checking. Do you still need help with this? Not sure if you deleted the original pot or just your follow up.

    S
    • Scalet_t
    • Author
    • New Participant
    • 3 replies
    • April 13, 2020
    andywingrave wrote:

    Hey there - Just checking. Do you still need help with this? Not sure if you deleted the original pot or just your follow up.


    Hi,
    yes I just deleted some follow up because it turned out, once tested not to be exactly working…
    Some help or advice is still greatly appreciated :slightly_smiling_face:

    A
    Forum|alt.badge.img+19
    • andywingrave
    • Inspiring
    • 323 replies
    • Answer
    • April 13, 2020

    Ah ok!

    Here you go. You want to create a table for the scans, and then roll them up :grinning_face_with_smiling_eyes:

    Feel free to copy this template:

    The totals are in the second tab. Hope it’s clear what I’ve done here

    S
    1 person likes this
    • S
      Scalet_t
    S
    • Scalet_t
    • Author
    • New Participant
    • 3 replies
    • April 13, 2020
    andywingrave wrote:

    Ah ok!

    Here you go. You want to create a table for the scans, and then roll them up :grinning_face_with_smiling_eyes:

    Feel free to copy this template:

    The totals are in the second tab. Hope it’s clear what I’ve done here


    Is great! thank you very much!
    really helpful!
    Thanks again

    Reply


    Most helpful members this week

    Terms & Conditions