Relationships- Duplicates adding Education Loop

Carol Grant
Carol Grant
Seventh Anniversary Kudos 5 First Reply Name Dropper
in SKY Developer General Discussions

Hi all- I'm struggling a bit on how to get the correct formatting for a table I am putting into a Word Merge document.

I am filtering the list constituents relationships to get Child. Then I want to pull the Child's Education if we have any on their record. Some of the children have multiple education records and some children don't have any.

I have Get a Constituent with the Child's system ID, and then List Constituent Educations with the Child's system ID.

I add the Child's Name to Append to Child Array

Then I have Apply to each (Loop) for each Child and their School Name, Class Year and I add these values to the same array used above Child Array.

My end result is:

fd65f83b004446310b77b540bf60a50a-huge-im

How can I get the education to move up a row if possible?? OR get rid of the 1st row and have Joe Smith appear twice with his education? I've tried UNION but they aren't duplicate rows. I've tried putting them in two different arrays but the issue is some children don't have a school like Hillary so I would be missing those if I didn't have the name in a separate array. I've also tried a condition if the School wasn't blank but it doesn't pull in Hillary Smith if the array was in the No section.

Thanks for any help!

Carolyn Grant

Middlebury College

Tagged:

Comments

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 5 Name Dropper Participant

    @Carolyn Grant
    Creating a single table from multiple arrays can be tricky for sure. You usually end up needing to build the table manually in JSON. I outlined this process on another post recently, take a look at it here and see if it helps you. The most straight-forward way of doing this would create your second option - it would put the name on every row.

    Let me know if you need help troubleshooting.

  • Carol Grant
    Carol Grant
    Seventh Anniversary Kudos 5 First Reply Name Dropper

    @Ben Regier

    Hi Ben- thanks for replying. I think that's what I'm doing here but I'm not sure. I'm looping through each child (Body is a filter array= Child from List Relationships)

    I want to get every child's name so I append each name to an array.

    351d05927cfcede2b927cebf1d200f3a-huge-im

    Then children may have many School records. Some have 3 education records. So I have to loop through each School below.

    c3098aebd19e79a989bba57a9585d8a0-huge-im

    Inside the education loop I have this append to the same Array called Child Array.

    197c639543718957e1d46ac162294e57-huge-im

    I've searched many things like append an array to another array but none of them seem to help with what if the child has no school records. It's like combining two loops.

    Thanks for any help!

    Carolyn

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 5 Name Dropper Participant

    @Carolyn Grant
    You're very close.

    The simplest solution would be to delete your first Append to array action and add the name and age to the Append action inside your school loop. But as you noted, this would mean that children with no school records would not show up on your list.

    If it were me, I'd use a conditional here. What you want is a flow that checks if there are any results returned from your “List constituent educations - CHILD” action. If there more than zero results, you want it to loop through them and append them all to your array, including the name and age of the child. If there are no results, you want to append a single row to your array that contains only the name and age.

    You can use the length() expression to return the number of results from your education action. If you haven't used expressions like this before, let me know and I can provide an example.

  • Carol Grant
    Carol Grant
    Seventh Anniversary Kudos 5 First Reply Name Dropper

    @Ben Regier

    That worked!! I swear I tried doing a condition and nothing ever came up in my No Side. For some reason using Count worked.

    f4d37544c294a771d8efe7744a1fe7c9-huge-im
    add81c5a51babdcb79485a20e5df0d2f-huge-im
    78591fe800b4964d1a935e51fe7eccd4-huge-im

    I did a Final Compose outside of the condition loop and everything is in there. Children without education and children with education listing each school.

    THANK YOU!!

    Carolyn


Categories