The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Re: Linked, lookup and rollup. Need some help sorting this out ;)
Slowly I am getting a better understanding of Airtable :slightly_smiling_face:
I have a table called task:
And a table for completed task:
So far so good.
When a user completes a task, a new record of the task is created in “completed task” along with “device.id” to keep track of which user completed the task.
Then I have a table called “Stats by device”
Where I get the:
• The sum of act/belong/commit score (by user)
• total completed task (by user)
And last, a table called “stats by task”
Where I get:
• A global count on how many times a specific challenge has been completed.
What I would like to get, but don´t know how to:
• a count that shows how many times a specific challenge has been completed by a specific user (i.e. User A has completed challenge “kaste ball” 5 times)
I reckon that the answer to the question above will also give me the solution to the “top 5 challenge” stat - a list where you can see which 5 challenges has been completed by you the most times.
Regards,
Tor Martin
