How to export each user's total amount?

Bubble
1

Hi everyone,

In my Bubble.io app, each user has a list of transactions (or an “Amount” field), and I want to export a report from Database that shows how much money each user has.

  • How can I generate and export a list of users along with their total amount?
  • Is it possible to do this as a CSV or Excel export?
  • Do I need to use a plugin, or is there a built-in way with workflows or API?

Would really appreciate any help or examples.
Thanks
Aman Pathak

2
  1. Create CSV from JSON Action
    This action takes a list of data (in JSON format) and converts it into a CSV file.
    The JSON Content is set to: Search for Payments: each item’s users :unique elements: format as text
    This means it searches for all Payments and extracts the unique user values, then formats the list as text suitable for JSON conversion.
  2. Format Content as Text (for each list item)
    This popup formats how each row/item in the CSV should appear.
    The JSON object structure per row looks like this:

Json
{
“User”: “This User’s Name”,
“Payment”: “Search for Payments: each item’s Amount: sum”
}
It means each row will have two columns:
1.User: Concatenation of the user’s first name and last name.
2.Payment: Sum of the Amount field from related Payments.
3. Delimiter
The delimiter is set to , (comma), so the CSV columns are separated by commas.
4. Other Options
File Name is set to “File” (default CSV file name).
Enclose in quotes is unchecked, so the values will not be enclosed in double quotes.
File delimiter is set to comma (,), standard for CSV.

Reply if you have any doubt regarding this.

1 Like