Forum Discussion

UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
8 years ago

Set Grid Edit for specific report only

I have a large table with many records. The roles are not allowed to grid edit on this table, however, I need them to have access to grid edit ONE report from the many that are on this table. Is there...
Grid edit
ShubhangiSingha's avatar
ShubhangiSingha
Qrew Member

Hi Mark , 
Thanks for the quick reply. 
Could you please tell me what's [_DBID_SUPPLIER_POS] in the syntax ? 

I'll write out my use case :
There is a role in my application that does not have access to Multiple Record Edit option. However there is this one report where I need to provide Grid Edit functionality to this role.
Not going ahead with Grid edit Report as I need it to have filters as well. 
So basically , I need to add a button in report which takes me to the grid edit mode with the filtered records , and back to the main report once I hit save in Grid edit mode.

I am fairly new to Quickbase and need support with syntaxes and logic. 

Regards,



------------------------------
Shubhangi Singhal
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

The [_DBID_SUPPLIER_POS] is the table alias which you can see in the Advanced settings for the table.  

or else you can just run the report  and grab the whole URL and then suffix it with 

&dlta=mog&navBack=true

 and make that be a button  or a formula URL somewhere.

This parameter causes Grid Edit  

&dlta=mog

This parameter seems to control where to go to on the save.

&navBack=true



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • ShubhangiSingha's avatar
    ShubhangiSingha
    Qrew Member
    2 years ago

    Hi Mark,

    Thanks for the explanation , it helped and worked well , however one concern remains.
    Upon clicking the Formula URL , All the records in the report are being displayed in grid edit mode. My requirement is to have only the filtered records in the grid edit mode. Would that be possible to achieve ?

    Regards,



    ------------------------------
    Shubhangi Singhal
    ------------------------------
  • ShubhangiSingha's avatar
    ShubhangiSingha
    Qrew Member
    2 years ago

    Another concern is navback does not seem to be working , as I am still in grid edit mode after hitting the save button!
    ( Not the priority here , but just curious what I might be doing wrong so that its not working for me)



    ------------------------------
    Shubhangi Singhal
    ------------------------------