Discussions

 View Only
  • 1.  Column query and resizing

    Posted 04-05-2017 13:44
    In the attached link is a sample add-in for something else, written in HTML5 and JQuery, that allows a person to resize and query on a data column just like a spreadsheet.  Is there such a thing for QuickBase?  I have looked through the Apps folders and seen nothing, but maybe a QSP has created something?  Or is such a thing even possible in QB?

    https://www.mrc-productivity.com/mrcjava/servlet/CUSTOMERS.I01401s?slnk=1&TEMPLATEID=26


  • 2.  RE: Column query and resizing

    Posted 04-05-2017 14:07
    As far as I know, with a native quickbase report, there is not a way to control field display width in an absolute or defined manner. There are probably hacky ways of doing it but you'd have to intercept and hijack the native quickbase style sheet, which is not recommended.


  • 3.  RE: Column query and resizing

    Posted 04-05-2017 15:14
    I was able to manually apply this library to achieve the effect.

    http://www.bacubacu.com/colresizable/

    See the screenshot where I am actively resizing the Phone column.

    However, I think you would have to hunt around for a better library or extnesion (there are dozens of these things) as there was some jerkiness to the process.




  • 4.  RE: Column query and resizing

    Posted 04-05-2017 15:31
    Apparently you can do this using jQueryUI resizable method although there is not a demo of resizing a table on the jQueryUI page:

    https://jqueryui.com/resizable

    QuickBase uses jQueryUI so there is no additional library to load. I spent like a minute on this so you would have to explore this option further.

    See this codepen:

    http://codepen.io/clarmond/pen/bdapme

    Here is a screenshot of me resizing the ContactTitle column after manually injecting a small amount of script.



  • 5.  RE: Column query and resizing

    Posted 04-05-2017 15:35
    Danimal is the man.  Again this group comes through!!!  Jerkiness is not the problem, at least for now, it's the lack of controls like a spreadsheet when I want to view data.

    I will look into this.

    Get the sorting part and the package is complete!

    Thank you for the help here and with others questions, which I have found extremely useful as a new user to the process.


  • 6.  RE: Column query and resizing

    Posted 04-05-2017 15:43
    This is what I typed into the console:

    var thHeight = $("table[qbdbid=bf3zb9bqt] thead td:first").height();$("table[qbdbid=bf3zb9bqt] thead td").resizable({
      handles: "e",
      minHeight: thHeight,
      maxHeight: thHeight,
      minWidth: 40,
      resize: function(event, ui) {
        var sizerID = "#" + $(event.target).attr("id") + "-sizer";
        $(sizerID).width(ui.size.width);
      }
    });

    on this page:

    https://haversineconsulting.quickbase.com/db/bf3zb9bqt?a=td

    I have no idea what most of the parameters do without investigating - I just borrowed from the codepen and changed the selector to target QuickBase's headers.