Skip to main content
Question

Report Link Data

  • May 2, 2022
  • 0 replies
  • 18 views
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
------------------------------
This topic has been closed for replies.

Are you trying to create a dropdown of the Team Members in the Teams table?

------------------------------
Paul Peterson
------------------------------
DwightMunson1
Forum|alt.badge.img+8
You can create a report link field and manually set the reference value. Use the related parent record ID.

------------------------------
Dwight Munson
------------------------------
MarkShnierYou
Forum|alt.badge.img+22
@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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement