Forum Discussion

ShontaySmith's avatar
ShontaySmith
Qrew Assistant Captain
9 years ago

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#])&"&_fid_138=" &URLEncode ("Request") &"&z=" & Rurl()

Forms
Formulas and functions
Relationships

11 Replies

Sort By
Show More
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Yes you are correct. It should be

    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";

    var text URLTWO = 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.