Roll-up based on the logged in user

I want to build a simple glide app expenses tracking app, where multiple users record their expenses.
Is there a way to summarize these records based on different parameters and limited to the signed in user only?

Applying Row Owners will automatically restrict data to only the rows that belong to the signed in user.

Depending on your other parameters, you can usually create a relation using template columns that contains multiple values, and then base your rollup off if that relation.

Thanks Jeff,
Much appreciated but not sure I get it :flushed:

Would that be too much to ask if you can share a more detailed explanation/ example?

Thank you!

Applying Row Owners is pretty self explanatory.

As for your other parameters, it would help if you explained what your data looks like and what you are looking to achieve. I can give you a generic answer, but it may or may not apply to your specific situation.

1 Like

Thanks @Jeff_Hager
Sounds like you’re a real pro :slight_smile:

Saying my table structure looks like this

  1. Row ID
  2. Transaction Value (Numeric)
  3. Category (Closed list)
  4. Active (Boolean)
  5. Row Owner (Email)

I want to summarize the transaction value based on the logged-in user, and to make it juicier - I want to filter out the non-active transactions.

Thanks ahead

  • In your Transactions table, create an if-then-else column:
    – If Active is checked, then Value
  • Now add a rollup column (in any table) that targets that if-then-else column.

The rollup can be a sum, count, max, min, average, etc.
As long as your Row Owners are correctly applied, that is all that is required.

Note that when you look in the Data Editor it might appear that the rollup is considering all rows, but again as long as your row owners are correctly applied, it will work as expected in the published App.