Ability to have users on one line without flattening

I would like to not have to flatten lists in order to have users on one line (one record per student).

I would like to be able to flatten households within an advanced list. Currently, we need to filter by something in order to flatten. This would be very helpful to have the families on one line so that we can easily export it out.

I'd like a better way to organize and manage list related to Peer to Peer Relationships.

  • Deleted User
  • Aug 10 2015
K-12 Core / Basic/Advanced Lists & Classic Reports
  • Attach files
  • Guest commented
    September 22, 2015 15:28

    I understand why it doesn't work this way; this is just the consequence of the database structure, and to do this you have to be able to determine (or have the user provide) which fields are one-to-many (like child-parent) and which are one-to-one. I wrote a spreadsheet add-on for Google Sheets to flatten any multi-line list. That could be a good interim way to do it.

    Attachments Open full size

Related ideas