Forum Discussion

Qrew Assistant Captain

9 months ago

How to create a Combined Text summary field using a relationship field

I need to display the field value for each child record of the parent table in a report in a Combined Text summary relationship field. I'm getting this error when trying to create the combined text s...

MarkShnier__You

Qrew Legend

A Combined text summary will only summarize a text field type.

If your field is numeric then you will need to make a formula field to convert it to text. Then summarize that text field.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

ChayceDuncan

Qrew Captain

9 months ago

You can also use a formula query as it is indifferent to field type as compared to your more traditional summary fields.

------------------------------
Chayce Duncan
------------------------------

MarkShnier__You
Qrew Legend
9 months ago
... but Formula Queries have more possibility of impacting performance. :)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------