Forum Discussion

Blake's avatar
Blake
Qrew Member
3 years ago

Report Link Data

Hello! 

I currently have two tables. One is Team Members and one is Team. I have linked all of the team members to their respective teams. I created a report link within the relationship and I am able to view a report of what team members are a part of each team. However, I am wanting to have a "Team Members" field within the Teams table. Is there a way to list out each team member on the Teams table without using a report link? I'd ideally like for the team members to be a user field within the teams table so that I can use this for setting up rules. 

Thanks in advance!

------------------------------
Blake
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    Are you trying to create a dropdown of the Team Members in the Teams table?

    ------------------------------
    Paul Peterson
    ------------------------------
  • DwightMunson1's avatar
    DwightMunson1
    Qrew Assistant Captain
    You can create a report link field and manually set the reference value. Use the related parent record ID.

    ------------------------------
    Dwight Munson
    ------------------------------
  • @Blake
    You can make a text field on the child join table of Team Members with a formula of
    ToText([Team Member Userid]).

    Then use a Combined Text Summary field to float up the Team member userids in text format up to the Team Record. 

    Ahh, but those are just words and not userids and you want a List User field to use in form rules or formulas ..... 

    no problem, then make a List User Formula field on the Teams Record 

    var text value = ToText([Combined Text User (text format)]);

    ToUserList(
    ToUser(Trim(Part($value,1,";"))),
    ToUser(Trim(Part($value,2,";"))),
    ToUser(Trim(Part($value,3,";"))),
    ToUser(Trim(Part($value,4,";"))),
    ToUser(Trim(Part($value,5,";"))),
    ToUser(Trim(Part($value,6,";"))),
    ToUser(Trim(Part($value,7,";"))),
    ToUser(Trim(Part($value,8,";"))),
    ToUser(Trim(Part($value,9,";"))),
    ToUser(Trim(Part($value,10,";"))),
    ToUser(Trim(Part($value,11,";"))),
    ToUser(Trim(Part($value,12,";"))),
    ToUser(Trim(Part($value,13,";"))),
    ToUser(Trim(Part($value,14,";"))),
    ToUser(Trim(Part($value,15,";"))),
    ToUser(Trim(Part($value,16,";"))),
    ToUser(Trim(Part($value,17,";"))),
    ToUser(Trim(Part($value,18,";"))),
    ToUser(Trim(Part($value,19,";"))),
    ToUser(Trim(Part($value,20,";"))))


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------