Help to fix my formula to check the completed box but return back to the same record

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Hey Everyone,

I need a little help with my redirect in my URL formula, to make sure I stay in the record I'm in while ticking off the check box in the related table for checklists

If you look at the pic, you see a record with an embedded report.  In the report is a Complete button.  I want to be able to click that button, which will check the completed checkbox, but to redirect\leave me right back in the record I was in (basically, when you hit complete, the item falls off the report, and you can just click the button and keep going... see the pic).

Here is my formula.  It is correctly changing completed to check, but it does't bring me back to where I want to be (back to the original record where I clicked the button).

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

"&apptoken=d8wv68d97fw4dbi4y35mpwivc3"&

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

"&_fid_9=True" & 

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

Can someone help me out?

Thanks!

Photo of Michael

Michael

  • 20 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
The problem is that you are refreshing to the child record when you really want to refresh the Parent.

Try this as the last line

"&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_of the Parent record from Adanced Table Properties] & "?a=dr&rid=" & [Related Parent])