Forum Discussion

Re: Flip Report, Transpose

Phelan,
I have not thought this through completely, But it seems to me that we could come up with a formula URL button combined with an automation which would copy the data from your original table into a temporary table for reporting purposes. The URL formula but would wipe the data in the target table and then will trigger a series of automations Steps  would run Saved table to table imports.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

4 Replies

  • ShaneMiller1's avatar
    ShaneMiller1
    Qrew Cadet

    Also looking to do something similar. Has QuickBase created a resolution for transposing child records to view horizontally rather than vertically in a report?



    ------------------------------
    Shane Miller
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain

      Not within the report / native capabilities, no. To Mark's most recent post, in order to transpose it you would need to likely build out some kind of staging area / table where you could reformat and cluster the data in a way that QB could report with that transposed format. Pipelines should make this easier than it was before - but in order to actually achieve this with native reports you'll need to transform it. 

      A custom code page would also do it if you're familiar - just extract the data and rebuild the table for yourself. You could render it for view or build your own custom CSV downloader with the format you want. 



      ------------------------------
      Chayce Duncan
      ------------------------------
      • ShaneMiller1's avatar
        ShaneMiller1
        Qrew Cadet

        Hey Chayce,

        I appreciate your feedback. One other "minor" detail I left out is that they want to edit the fields in that spreadsheet like report. The reason they want this out of excel and into Quick Base is because our business currently uses a shared drive and it has become a labyrinth in which nobody can find the file/ data that they need without asking several people where it is located. 



        ------------------------------
        Shane Miller
        ------------------------------