Forum Discussion

RossonLong1's avatar
RossonLong1
Qrew Cadet
5 years ago

Creating a URL to grid edit children. (Like a report link but grid edit rather than view).

Creating a URL button to instantly grid edit the children of a specific parent. I know that I can have a button that shows me all the children associated with the parent (report link) but I am tryi...
Forms
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Let's first rule of the obvious normal way.  If the parent has an embedded table of the children  and you edit the form properties for the report link field you can put the children into grid edit mode automatically when you edit the parent record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RossonLong1's avatar
RossonLong1
Qrew Cadet
5 years ago
The children are part of another app so having them set as "editable" in the form rules doesn't seem to make them editable by default when I view them. I still hit "Grid Edit" on the list of related children. Is it possible I'm doing something wrong and that's why the children records are not editable when I arrive on the form?

Our employees do this every day and they are in China so their page load times are typically a bit slower so I'm trying to decrease the number of page loads they need to perform a rather monotonous task.

Right now the fastest way is still to click the report link and then click "grid edit" on the top right hand side.

Mainly just curious if I can make this any faster and just have them arrive on a page where they are already editing the children.

------------------------------
Rosson Long
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    There is a report type called Grid Edit.

    Make a perfect report with an <ask the user> field on related Parent.
    run the report and answer the question with any parent.

    Observe the URL and mimic it

    URLRoot() & "db/xxxxxxx" & "?a=q&qid=99&nv=1&v0=" & [record ID#]


    That says to run a report #99 which has 1 question (nv=1) and the answer to the zeroth question (it likes to start numbering at zero) is [Record ID#]





    ​

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------