Forum Discussion

AhmedSharifi's avatar
AhmedSharifi
Qrew Member
7 years ago

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

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?
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.
    • ForrestParker's avatar
      ForrestParker
      Qrew Cadet
      7 years ago
      It would be great if we could create a summary field that does this for us, but sadly we can't.