Dynamic Column Names in a Report
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 -------------...
Forum Discussion
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
------------------------------
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
------------------------------
Thank you. I’ll give that a try.
- .. I'm lazy and the Quickbase steps are free so I run that every night. That way if my Pipeline fails it will just run the next night.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Worked PERFECTLY. Thank you!
