How could I create a report from "user-specific" columns?

[Robert_Petitto]

Ya…no easy solution. If you’re looking for JUST an export of data for yourself, you can export a table by right clicking on it from the data editor.

However, if you’re looking to create in-app reports/leaderboards etc using completion data, then you’re best bet is to either add new rows to a “completion log” sheet (row intensive) or by using the “trebuchet method” to create a comma separated list of users that have created a challenge (very lean, but doesn’t capture any additional data past “who completed what”).

Here’s a video I just created that outlines how:

The Trebuchet Method

In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…