Discussions

Expand all | Collapse all

Is it possible to display related records (from another table) as a comma separated list in a text formula field?

  • 1.  Is it possible to display related records (from another table) as a comma separated list in a text formula field?

    Posted 07-18-2018 22:10
    Is it possible to display related records (from another table) as a comma separated list in a text formula field?

    For example, if table A has many records in table B. I want to show all records from table B in a formula text field in table A as "Record From B 1, Record From B 2, ..."

    is this possible?


  • 2.  RE: Is it possible to display related records (from another table) as a comma separated list in a text formula field?

    Posted 07-18-2018 22:22
    You would need to make a series of reverse relationships to float up text values from the first few child records up to the Parent. There is not simple formula for this.


  • 3.  RE: Is it possible to display related records (from another table) as a comma separated list in a text formula field?

    Posted 07-20-2018 17:39
    It would be great if we could create a summary field that does this for us, but sadly we can't.