URL formula button: remain on form after adding record

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I have an "Add Quote" button that adds a record to the Quotes table. 

I want users to remain in the Quotes table after saving the quote record . . . i.e. users should not return to the other table by default. 

I've seen several posts on this topic but am unsure whether my question is as complicated as the others. Is there a way to do this without coding it into the URL formula?


URL formula: 

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_222=" & URLEncode ([Scheduled Service Log ID#])

&"&_fid_18="&[Customer (num ref)]
&"&_fid_8="&[Site Address: Street 1]
&"&_fid_9="&[Site Address: Street 2]
&"&_fid_10="&[Site Address: City]
&"&_fid_11="&[Site Address: State/Region]
&"&_fid_12="&[Site Address: Postal Code]
&"&_fid_13="&[Site Address: Country]
&"&_fid_6="&[Site Business Name]

& "&z=" & Rurl()

Photo of Andrea Pahor

Andrea Pahor

  • 326 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,402 Points 1k badge 2x thumb
I believe you simply need to remove the last line (the "&z" bit).