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

9 months ago

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
  ------------------------------