Discussions

Expand all | Collapse all

URL formula button: remain on form after adding record

  • 1.  URL formula button: remain on form after adding record

    Posted 02-20-2019 03:16
    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()



  • 2.  RE: URL formula button: remain on form after adding record

    Posted 02-20-2019 11:46
    I believe you simply need to remove the last line (the "&z" bit).