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 opens and opens the form designated in the Form Roles section.  Here is my current URL for the button:

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

It doesn't matter if I change "11" to "2" whatever is select in the form roles section opens.

Can I specify the form to open and still have it open in Edit mode?

Thanks,

Brian



------------------------------
Brian Dunk
------------------------------
  • 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

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



      ------------------------------
      Brian Dunk
      ------------------------------
    • BrianDunk's avatar
      BrianDunk
      Qrew Cadet

      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

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