Report Link Field - Display More Information
Good Afternoon All, A little context before I ask my question: I am putting together a report for a customer that is requesting some information (date, departure location, passengers, etc.). She ...
Forum Discussion
No Problem
I assume that you have a relationship where One Trip has Many Passengers.
Create a Summary field on the relationship as a Combined Text Summary of [Passenger Full Name])
Then you will likely not like the format of it on the trips record, so you may want to make a new formula txt field like this
SerachAndReplace(ToText([Combined Text Summary PassengerFull Name]), " ; ", "\n")
That will give the names in a vertical list.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I assume that you have a relationship where One Trip has Many Passengers.
Create a Summary field on the relationship as a Combined Text Summary of [Passenger Full Name])
Then you will likely not like the format of it on the trips record, so you may want to make a new formula txt field like this
SerachAndReplace(ToText([Combined Text Summary PassengerFull Name]), " ; ", "\n")
That will give the names in a vertical list.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
