Discussions

Expand all | Collapse all

Need to increase the columns width of Grid Edit Report

  • 1.  Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 14:20
    Hi Team,

    I have a Grid Edit Report and I want to increase column width of this report (see attachment). I know we can do it with the help of IOL technique but need some guidance in that way.

    I have seen some solutions on community to create the formula fields to use some HTML but that will not work for my work as I have to use this grid edit report for updating multiple records.

    Please let me know if you need any additional information.

    Thanks,
    Gaurav


  • 2.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 14:29
    The only way I have done this is to customize the Grid Edit Report Field Column Properties to add ________ on the end of the Field Names.  This means the basic grid gets larger.  Since Column Properties are a report-only feature; it only affects that one report, in this case the one used for Grid Edit.  

    If you are doing the grid editing within a record (embedded report), you most likely won't want the _____ to appear on a regular-embedded report, so consider using one report /Report Link field for Grid Edit-only uses (Edit mode); and the regular embedded report for viewing only.  If necessary put your Grid Edit for data-entry into a separate Form.


  • 3.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 15:27
    I have tried but it's not working your first solution.


  • 4.  RE: Need to increase the columns width of Grid Edit Report

    Top
    Contributor
    Posted 04-18-2017 15:41
    Is this an "embedded" report, or a custom Grid Edit report?

    Most of the time it automatically resizes for me, but if you have a lot of columns then it can only resize so much...


  • 5.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 16:07
    Matthew, this is a custom Grid Edit report and It has around 120 columns.


  • 6.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 17:06
    Is your embedded report on a Form or is it a URL Link they open up?


  • 7.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 17:08
    It is a URL link


  • 8.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 17:21
    I did a quick test and built a formula-URL button with this format and it launches my pre-built report with custom-report-column properties set.

    URLRoot() & "db/" & Dbid() & "?a=q&qid=6&dlta=mog~&ridlist=61893&qskip=0&navBack=true"

    which generated my report looking like this.  The age formula column has a space between the field name and the __________, hence the splitting



  • 9.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 18:35
    What is here ridlist?


  • 10.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 18:44
    I don't think you will want the ridlist in your formula; since each time I generate the report from a different Record the ridlist changes.  I took that out, and the button still functions the same.  https://laurahillier.quickbase.com/db/bhfdbnjwq?a=q&qid=6&dlta=mog~&qskip=0&navBack=...


  • 11.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 19:39
    Laura, It is not working for me. I don't know why? Maybe I have around 120 fields.

    Here is my formula for your formula:

    https://elevateservices.quickbase.com/db/bmqar9tmq?a=q&qid=8&dlta=mog~&qskip=0&navBack=true"


  • 12.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-18-2017 19:53
    Try a version of this with say 20 fields, or less and see if it works.  I think that QuickBase Support would tell you that 120 fields in a single report is simply too many.

    Does the Grid Edit feature work without trying to customize your field headings?


  • 13.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-20-2017 19:02
    It looks like it is because of too many fields. Yes, Grid edit feature works for me with fewer fields.

    Thanks,
    Gaurav


  • 14.  RE: Need to increase the columns width of Grid Edit Report

    Top
    Contributor
    Posted 04-20-2017 19:07
    If you have more than 20 fields that you are using for grid edit entry, I'd say you are doing something wrong with your data structure or entry method.  Just my 2 cents


  • 15.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 04-20-2017 19:03
    Dan, Can you please have a look on this?

    Thanks,
    Gaurav


  • 16.  RE: Need to increase the columns width of Grid Edit Report

     
    Posted 04-21-2017 14:09
    If you are familiar with the IOL technique, then you can restyle the width of the columns within your script. 

    Select each column by its field ID in the table and then set its width to whatever you want, it looks like this: 
    // Insert where needed  $('.gridEmbCell [qbfid="148"]').css({'min-width':'400px'})  // insert the field ID you want to make larger after "qbfid="  // set your width with 'min-width'
    This will restyle each column based on its field ID if you call your IOL script on the grid edit report.

    I will note that this will not fix the size of the input boxes.


  • 17.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 05-03-2017 19:01
    Wao.. Thanks, Sam. It works for me. As I am aware of the IOL Technique So, it is very easy for me to implement.

    Thanks,
    Gaurav


  • 18.  RE: Need to increase the columns width of Grid Edit Report

    Posted 05-03-2017 18:26
    Just sharing. I dropped a grid edit onto a form and was having an issue with my long text field columns being too short as well. I only have two fields that require longer text entry, so the entire table fits well within the browser window.

    I changed the default value for the fields to provide a short explanation as to what should be entered into the field. For example, "Enter a short description of the defect that occurred."

    That caused the columns to widen to accommodate the length of the entry without the unsightly underscore on the field name.  This may or may not be helpful for your application, but for those who are having the same issue as I am, this might be a simple solution. Good luck!


  • 19.  RE: Need to increase the columns width of Grid Edit Report

    Silver
    Contributor
    Posted 05-03-2017 18:37
    Good. But, I have created a Grid edit report and it needs a different solution. I am trying now the above solution (Sam C).

    Thanks,