ChrisChris
9 years agoQrew Assistant Captain
Custom Add Button to take me to the new record just created
Hi,
How would I modify the code below to take me to the newly created record rather than back to the source FEEDBACK form where the button resides?
If(
[# Plant added to DMR database]=0,
URLRoot() & "db/" & [_DBID_PLANTS] & "?a=API_AddRecord"&
// fid from destination DB table //
"&_fid_6=CCNA-" & URLEncode([New Plant-Name])&
"&_fid_14=" & URLEncode([New Plant-Region])&
"&_fid_15=" & URLEncode([New Plant-Code])&
"&_fid_16=" & URLEncode([New Plant-State or Province])&
"&_fid_17=" & URLEncode([New Plant Manager])&
"&_fid_18=" & URLEncode([New Plant-OPD])&
"&_fid_20=" & URLEncode([New Plant-Cost/Min])&
"&_fid_24=" & URLEncode([New Plant Manager Email])&
"&_fid_29=" & URLEncode([New Manager acts as AP])&
"&_fid_32=" & URLEncode([New Plant-SPM])&
"&_fid_46=" & URLEncode([New Plant-SAP])&
// Record ID# is written to the [Related Feedback ID] in Plants table //
"&_fid_33=" & URLEncode([Record ID#]) &
"&rdr=" & URLEncode(URLRoot() & "db/"& [_DBID_FEEDBACK] & "?a=dr&rid="&[Record ID#])&"&apptoken=24dsencpv4i3udrbiyp3ciakxgg",""
)
How would I modify the code below to take me to the newly created record rather than back to the source FEEDBACK form where the button resides?
If(
[# Plant added to DMR database]=0,
URLRoot() & "db/" & [_DBID_PLANTS] & "?a=API_AddRecord"&
// fid from destination DB table //
"&_fid_6=CCNA-" & URLEncode([New Plant-Name])&
"&_fid_14=" & URLEncode([New Plant-Region])&
"&_fid_15=" & URLEncode([New Plant-Code])&
"&_fid_16=" & URLEncode([New Plant-State or Province])&
"&_fid_17=" & URLEncode([New Plant Manager])&
"&_fid_18=" & URLEncode([New Plant-OPD])&
"&_fid_20=" & URLEncode([New Plant-Cost/Min])&
"&_fid_24=" & URLEncode([New Plant Manager Email])&
"&_fid_29=" & URLEncode([New Manager acts as AP])&
"&_fid_32=" & URLEncode([New Plant-SPM])&
"&_fid_46=" & URLEncode([New Plant-SAP])&
// Record ID# is written to the [Related Feedback ID] in Plants table //
"&_fid_33=" & URLEncode([Record ID#]) &
"&rdr=" & URLEncode(URLRoot() & "db/"& [_DBID_FEEDBACK] & "?a=dr&rid="&[Record ID#])&"&apptoken=24dsencpv4i3udrbiyp3ciakxgg",""
)