Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
2 years ago

Formula URL Button to Open Specific Form Being Controlled By Role Form Settings

I am trying to create a Button that opens a specific form from a table within my app.  I change the "fid_XX" to any of the form ID's and it doesn't matter.  The form roles are overriding what form op...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

If you're trying to open a specific form the syntax will be dfid=11 or whatever ID corresponds with your form.  

So: URLRoot() & "db/" & [_DBID_NOTES] & "?a=API_GenAddRecordForm&dfid=11&z=" & Rurl()



------------------------------
Chayce Duncan
------------------------------
  • BrianDunk's avatar
    BrianDunk
    Qrew Cadet
    2 years ago

    Ok how do I tie the submission to an Employee ID?



    ------------------------------
    Brian Dunk
    ------------------------------
  • BrianDunk's avatar
    BrianDunk
    Qrew Cadet
    2 years ago

    When I add back this part of the formula the role settings seem to take over.

    " & URLEncode ([Employee ID])& "&z="



    ------------------------------
    Brian Dunk
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain
      2 years ago

      You can include the _fid_ syntax to populate fields the same way you originally had it in addition to adding dfid. 

      So dfid=11&_fid_11=[Employee ID]



      ------------------------------
      Chayce Duncan
      ------------------------------
      • BrianDunk's avatar
        BrianDunk
        Qrew Cadet
        2 years ago

        Getting an error on Save:

        URLRoot() & "db/" & [_DBID_NOTES] & "?a=API_GenAddRecordForm&dfid=11&_fid_11=[Employee ID]& "&z=" & Rurl()



        ------------------------------
        Brian Dunk
        ------------------------------