Ability to have multiple calculated columns in reports

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Acknowledged
Ability to have multiple calculated columns in reports
Photo of Michael Kochen

Michael Kochen

  • 70 Points

Posted 8 months ago

  • 0
  • 1
If this is a question, the answer is no.  Typically you will just create extra fields assuming that you have admin access to the app.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,368 Points 10k badge 2x thumb
Currently reports are set up to just have the ability to add a single calculated column. Instead if multiple formulas are needed we recommend creating fields in your table that can be added to the report. This way there are not a number of formulas held just within a report. While that is the case now if you feel this would be helpful for your usage of Quick Base I would recommend putting that feedback into our User Voice. User Voice is a tool used by our Product Management team to gauge user interest in future features and enhancements to existing features. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the left of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. It allows other users with similar needs to add their vote and show their support for ideas. I often recommend when an idea is submitted to UserVoice that a link should also be posted here in this thread so that others with the same need can add their vote. Thank you very much for your feedback.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
You can always concatenate several fields together to display in the custom column
var Text cellA = Upper(Left([FieldA], 1)) & Lower(NotLeft([FieldA], 1));
var Text cellB = ToText(2 * [FieldB]);
$cellA & ", " & $cellB

Unfortunately you can use a Rich Text Formula field as a custom column so you can't synthesize HTML.