Skip to main content
Question

Dynamic Column Names in a Report

  • February 16, 2022
  • 0 replies
  • 81 views

Is there any way to change the name of the column dynamically?  I want to change the column name to JAN YEAR(TODAY()). Or a value in field.

------------------------------
Jim Boozer
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • February 17, 2022
Yes.  You can create a formula field to calculate the value you want. Then have a pipeline run every night to run a Make a Request

 URL 
https://mycompany.quickbase.com/db/xxxxxx

Method
POST

Content type
application /xml

NAME
QUICKBASE-ACTION

VALUE
API_SetFieldProperties

body
<qdbapi>
<usertoken>xxxxxxxxx</usertoken>
<fid>716</fid>
<label>{{a.label_ats_wk1}}</label>
</qdbapi>



in the body above the target fid to update is 716 and the formula field that has the name is in the field 
[label ats wk1]

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------