Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Column query and resizing

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

5 Replies

Sort By
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    8 years ago
    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.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    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.


  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    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.

  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    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.
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      8 years ago
      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.