URL formula button: remain on form after adding record
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()
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()
