Discussions

 View Only
  • 1.  Report Link Data

    Posted 05-02-2022 15:48
    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
    ------------------------------


  • 2.  RE: Report Link Data

    Posted 05-02-2022 20:14
    Are you trying to create a dropdown of the Team Members in the Teams table?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 3.  RE: Report Link Data

    Posted 05-09-2022 08:24
      |   view attached
    You can create a report link field and manually set the reference value. Use the related parent record ID.

    ------------------------------
    Dwight Munson
    ------------------------------



  • 4.  RE: Report Link Data

    Posted 05-09-2022 08:32
    @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
    ------------------------------