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...
Forum Discussion
Hi dwhawe, that was not working, but I found a workaround. I created a formula button, that sends the user directly to the report in grid edit mode, which superceded any role settings. I would still like to know why the option you state above didn't work for me, but I didn't have time to mess around haha!
Hi Ursula,
I have a similar work case that I need to work on.
Could you please explain in a little more detail on how you created this formula button to link it directly to grid edit mode
Regards,
Shubhangi
------------------------------
Shubhangi Singhal
------------------------------- MarkShnier__You
Qrew Legend
This syntax will launch into Grid Edit and on save return to the original report
URLRoot() & "db/" & [_DBID_SUPPLIER_POS] & "?a=q&qid=33" & "&dlta=mog&navBack=true";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
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
------------------------------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
------------------------------
