Forum Discussion

KimRavizza's avatar
KimRavizza
Qrew Cadet
5 years ago

Button to Save & Close Child Record

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
------------------------------
  • 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
    ------------------------------