Forum Discussion

JimBoozer's avatar
JimBoozer
Qrew Trainee
3 years ago

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
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        .. 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
        ------------------------------