Skip to main content
Question

Automating duplication of template Dashboard and Reports/Charts

Forum|alt.badge.img+5

When we add a new customer Project to our Quickbase database, we currently have to manually duplicate a "Template" dashboard and the associated standard reports and charts across the various tables. This is very time consuming as you need to manually go in and copy each page/report/chart, rename the copy then link  report/charts on the new dashboard pages.

Is there a way of duplicating  template pages/reports/charts and renaming to a new project name and link on the new dashboard pages?

I was thinking of a new table where you could enter the new Project name and a button. I looked at pipelines but that appears to only handle tables. Would this require maybe  Javascript or is there another way?

Thanks.



------------------------------
Grant K
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    There may be a far better approach. Why can't everybody have access to a dashboard where the reports are filtered to their personal preferences.

    You canThere may be a far better approach. Why can't everybody have access to a dash port, where the reports are filtered to their personal preferences.

    You can have a table of users where the key field is the user ID.  On that record, you set the users preferences like which companies they are involved with or which projects they  involved with.

    then you build relationships from that table down to any of your detail tables were the reference field is a Formula field that calculates to the current user. The formula for that is simply.

    User()

    then you look up any fields you need from the user table and make one set of filtered reports that filters on the users preference. The magic is that each different user while looking at the same report, and the same dashboard will see a completely different set of results. But that way you only need one report or one set of reports on the dashboard to satisfy all users. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement