Skip to main content
Question

Button to Save & Close Child Record

  • May 6, 2020
  • 0 replies
  • 23 views

Forum|alt.badge.img+9
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 6, 2020
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
------------------------------