Discussions

Expand all | Collapse all

Button to Save & Close Child Record

  • 1.  Button to Save & Close Child Record

    Posted 24 days ago
    Hello,

    I have a form for store records. Within that form, I have a report for some child records. When I click the edit button to edit a child record, I'm taken to the child record form in edit mode. All good so far.

    Within the child record form, I have a few task completion buttons that update the date and time the task was completed. When I click on one of those buttons, I'm taken out of edit mode, so the save and close button disappears. At that point, I have no way to get back to the parent record.

    Here's the formula for the task completion button:

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

    "&rid=" & [Record ID#] &

    "&apptoken=999" &

    "&_fid_77=" & URLEncode(Now()) &

    "&rdr=" & URLEncode(URLRoot()&"db/" & Dbid() & "?a=dr&dfid=11&rid="&[Record ID#])

    Is there a way I can:
    a. Add a button to the bottom of the form to save and return to the parent record?
    or
    b. Add functionality to my rich text button to keep the form in edit mode?
    or
    c. Something else I haven't though of?

    Hoping this is something that I'll feel silly about not figuring out myself... :)

    Thanks in advance for your help!

    Kim

    ------------------------------
    Kimberley
    ------------------------------


  • 2.  RE: Button to Save & Close Child Record

    Posted 24 days ago
    Hi Kimberly,

    Try this syntax

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

    "&rid=" & [Record ID#] &

    "&apptoken=999" &

    "&_fid_77=" & URLEncode(Now()) &

    "&NextURL=" & URLEncode(URLRoot()&"db/" & Dbid() & "?a=dr&dfid=11&rid="&[Record ID#])

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