Redirect to new record

Question

Hello -I am using a formula URL to create a new record in a table. The intent of the button is to essentially copy certain aspects of a record to a new record. (note: I know there are a couple native copy functionalities within QB but their limitations do not work for this use case) I would like to redirect the user to the new record&nbsp; in EDIT view but I am not sure what to add to the formula to do so. Currently, the end of my formula includes this (which redirects to the record on which the button was clicked):&nbsp; &amp; "&amp;rdr="&amp;URLEncode( URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; RurHow do I need to alter my formula to redirect to the created record in EDIT view so they can make any changes needed from the original record?------------------------------Thanks in advance,Jennifer Paschal------------------------------

markshnier__you · Answer

If you are using API_AddRecord and include the peramwter&amp;disprec=1then it will display the record that it just created.&nbsp;
If you have any trouble with this post your whole formula------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jenniferpaschal · Answer

Thank you! Okay so this change took me to the home page of the app. How would i have it open the created record in edit mode or even just the add form with the field info passed through so the user can make changes before officially saving the record?

Here is my formula
URLRoot() & "db/" & [_DBID_INTAKE] & "?a=API_AddRecord"

//copy as is
& "&_fid_8=" & [Initiative Type]
& "&_fid_7=" & [Requesting Business Unit]
& "&_fid_117=" & [Initiative Name]
& "&_fid_743=" & [Simplified Description]
& "&_fid_16=" & [Problem Statement]

//Change Request? = Yes
& "&_fid_474=" & "Yes"

//copy as is
& "&_fid_116=" &
& "&_fid_359=" & [Arch Roadmap]
& "&_fid_11=" & [Channel(s) Impacted]
& "&_fid_12=" & [Product(s) Impacted]
& "&_fid_17=" & [Customer Experience(s)]
& "&_fid_18=" & [Employee Experience(s)]
& "&_fid_19=" & [Quantifiable Benefit Estimate]
& "&_fid_20=" & [Benefit Calculation]
& "&_fid_137=" & [Detailed Description]

//test record = Yes --remove after go live
& "&_fid_856=" & "Yes"

//redirect
& "&rdr=" &URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect=1" & Rurl())

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------

markshnier__you · Answer

If you want to just land the user on an input form, use a different API

URLRoot() & "db/" & [_DBID_INTAKE] & "?a=API_GenAddRecordForm"

//copy as is
& "&_fid_8=" & [Initiative Type]
& "&_fid_7=" & [Requesting Business Unit]
& "&_fid_117=" & [Initiative Name]
& "&_fid_743=" & [Simplified Description]
& "&_fid_16=" & [Problem Statement]

//Change Request? = Yes
& "&_fid_474=" & "Yes"

//copy as is
& "&_fid_116=" &
& "&_fid_359=" & [Arch Roadmap]
& "&_fid_11=" & [Channel(s) Impacted]
& "&_fid_12=" & [Product(s) Impacted]
& "&_fid_17=" & [Customer Experience(s)]
& "&_fid_18=" & [Employee Experience(s)]
& "&_fid_19=" & [Quantifiable Benefit Estimate]
& "&_fid_20=" & [Benefit Calculation]
& "&_fid_137=" & [Detailed Description]

//test record = Yes --remove after go live
& "&_fid_856=" & "Yes"

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

jenniferpaschal · Answer

Thank you :) That does exactly what I need------------------------------Thanks in advance,Jennifer Paschal------------------------------

Forum Discussion

Redirect to new record