Redirect to new record
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 nat...
Forum Discussion
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
------------------------------
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
Qrew Legend
Qrew LegendIf 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
------------------------------
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
------------------------------
- Thank you :) That does exactly what I need
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------