Discussions

 View Only
  • 1.  Grid Edit Report

    Posted 07-09-2019 15:15
    Hello All

    Just created a Grid Edit report to update approx. 5 fields.

    When I re-opened report it was junked up with additional fields (very hard to navigate).

    When I open the "Customize the Report" tab it appears correct.

    What am I doing wrong?


  • 2.  RE: Grid Edit Report

    Posted 07-09-2019 15:21
    Are they lookup fields?  If so, you can't grid-edit them directly; rather, you have to edit the reference field, so grid-edit presents the reference fields alongside the lookup fields.


  • 3.  RE: Grid Edit Report

    Posted 07-09-2019 15:57
    They are, but I don't even want to see them on this particular Grid Edit report.  I am not editing them, and they just create navigation headaches.



  • 4.  RE: Grid Edit Report

    Posted 07-09-2019 16:26
    Hi Dirk,

    One thing that can be helpful to check is to go into the settings for that table, and go into the forms section and specifically the option to set how roles use forms and there is a column that shows what the behavior is for Grid Edit, you might want to make sure someone hasn't set up a report to override all of your grid edits, typically if you want a report to show just what is on the report in Grid Edit you want to make sure that it is set to standard behavior. The override can be done on the role level or on the report level so checking both places can just help make sure you aren't running into a setting issue. I hope this suggestion is helpful.



  • 5.  RE: Grid Edit Report

    Posted 07-13-2019 15:13
    Evan:

    My apologies for not responding sooner.  Unfortunately, I wear several hats and am just getting back to Quickbase today.

    Your insights were accurate and helped me resolve issue.

    Thank you very much.

    Dirk




  • 6.  RE: Grid Edit Report

    Posted 07-15-2019 13:47
    Hi Dirk,

    Not a problem at all, I am just glad to hear that helped. I have run into the exact same thing myself when trying to troubleshoot an app.