Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
7 months 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...
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
7 months 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
    7 months ago

    Getting an error on Save:

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



    ------------------------------
    Brian Dunk
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain
      7 months ago

      Sorry about that - I was going quickly and wasn't writing it properly for QB. 

      &dfid=11&_fid_11=" & [Employee ID] & "&z="& Rurl()



      ------------------------------
      Chayce Duncan
      ------------------------------