URL button to populate a field
Can someone look at my formula and tell me why field 138 not populating the word Request when I click the URL button URLRoot() & "db/" & Dbid() &"?a=er&dfid=12&rid=" & URLEncode ([Record ID#])&"...
Forum Discussion
Shontay,
The code I posted was not meant to be complete code, but was intended to give you direction. If you want to get into the world of using APIs in URL formulas, one source of training is an app I have posted to the Exchange called URL Formuals for dummies.
The actual suggested code would be this
var text URLONE = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_138=Request";
URLRoot() & "db/" & Dbid() &"?a=er&dfid=12&rid=" & URLEncode ([Record ID#])
& "&z=" & Rurl();
$URLONE
& "&nexturl=" & URLEncode($URLTWO)
The first statement should edit the record to put Request into field ID 138. The second part will then display the record in edit mode.
The code I posted was not meant to be complete code, but was intended to give you direction. If you want to get into the world of using APIs in URL formulas, one source of training is an app I have posted to the Exchange called URL Formuals for dummies.
The actual suggested code would be this
var text URLONE = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_138=Request";
URLRoot() & "db/" & Dbid() &"?a=er&dfid=12&rid=" & URLEncode ([Record ID#])
& "&z=" & Rurl();
$URLONE
& "&nexturl=" & URLEncode($URLTWO)
The first statement should edit the record to put Request into field ID 138. The second part will then display the record in edit mode.