Question

Photo of Brandon Gamache

1

Adding Grade Attribute to Group Members

Does anyone know if there is a current field type that can grab a student's grade/graduation date for a group attribute (or any attribute at that)? I know I can create a key value list but if there is a way it would automatically grab the student's grade that would be best.

  • Photo of Jeremy Hoff

    0

    Hi Brandon,

    (The image didn't come through in the post. . . .)

    I think I understand.  You want to be able to add columns to the Group page based on Person Attributes.  I don't see a way to reference a current person attribute, but the idea has merit.   If you could key that into the "Ideas" area referenced below, that would be very helpful:  

    http://www.rockrms.com/Rock/Ideas

    Thank you!

  • Photo of Jeremy Hoff

    0

    Hi Brandon,

    I'm sorry, I'm not 100% certain I understand the question - are you asking that a Group attribute reference a Member's Attribute?  Are you trying to display the member's information within the list of group members?  Something else?

    If you are willing to provide some details I can help further. :-)

    Thank you!

  • Photo of Brandon Gamache

    0

    Yes and Yes. This is just a group I am testing and playing with but I'm just wondering if there is a field type that would display the student's grade. Below I'm just using a value list for the Grade column/attribute I set up with different grade options but if there is a way to retrieve a person's info and use it as an attribute that would be quicker and easier than setting up a list. Not worried if there isn't, just seeing if there is a quicker/better way than making lists when the data is already present in the database.

  • Photo of Michael Garrison

    0

    Brandon,

    I know I'm butting into a thread I haven't been a part of, but (depending on how the ROCK developers did this, of course) I'd be afraid of data getting out of sync somehow. Would it satisfy your need to simply be able to generate a report (something you'd view online or print out) which gives you a list of all group members, together with their current graduation year/grade? That way it's not actually an attribute of the person's group membership, but rather remains an attribute of the person.

    I'm trying to create such a report right now and actually running into trouble doing so, even though I've made a few other reports to date. I'll keep looking =)

    Got it. Here's how to create the report:

    1) click "Tools" , "Data Views"
    2) You need to create a data view for the group you want the report on, so click an existing category (like "Foundational Views") or "(+) Add Category" to create a new one (like "groups"), then click the "(+) data view" button
    3) Set this Data View to apply to "Person", then add a filter for "In group" and select the desired group. Select other filters as you wish to customize or limit your report.
    4) Now click "Tools" , "Reports"
    5) You need to create a report for the group you want the report on, so click an existing category (like "Members") or "(+) Add category" to create a new one (like "Group Age Reports")
    6) Set this report to apply to "Person", then select the Data View you created above. Add whatever fields you want below (First Name, Last Name, Graduation Date, etc) and save it.

    Now, here's the nice thing: all of that was just a one-time process (per group). From now on to get the list you wanted, just click "Tools" , "Reports" and select the report you want - and the list with the data you requested just shows up, and can be exported to Excel. Woo hoo!

    ReportScreenshot.png

    (note that my name doesn't have a graduation date in the report because I'm listed as an adult in Rock =)

    • Brandon Gamache

      I can use this but I think it would still be beneficial to display it in a group. You wouldn't necessarily be changing the data, just retrieving it from the db to display in the group. Not a big concern, just playing around to see what could be the best result. Thank you very much for the report walkthrough. I will definitely play around with this as well.

  • Photo of Carolyn Walker

    0

    I'm needing this same thing for a group. I need the grade to show up when I view the students in the group. I've added school grade as a member attribute on my group but the grade is still not showing. Not sure what I'm doing wrong. Grade on Group.JPG

  • Photo of Jeremy Hoff

    0

    Although this is an old thread, it's worth adding the solution for posterity.

    The following steps will allow you to add a Grade column to the Group Viewer,. 

    1. As an Admin (or anyone with security rights to edit pages/blocks) navigate to the Group Viewer page, 
    2. Hover over the bottom right of the browser window to reveal RockRMS' CMS Tools, and select "Block Config"
    3. Hover over the CMS Tools for the Group Member List block, and tap the "Gear" to edit.
    4. Find the "Custom Grid Options" tab and tap the "+" to add a new column. Then set the header text to "Grade" and set the Lava Template to "{{ Row.Person.GradeFormatted }}". Optionally, set the column number and offer to place the column in the position you prefer - I chose "First Column, +3" to place it just to the right of the person's name.

    I hope that helps,