Forum Discussion

vikaspasula's avatar
vikaspasula
Qrew Member
9 months ago

RE: Updating text multiple choice field using url button

Hi,

Can someone please assist me in how to create a url button to update text multiple choice field using URL botton.



------------------------------
vikas pasula
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    9 months ago

    Text MC will be the same setup as a generic text field - so your URL button will be something like: 
    API_EditRecord&rid=___&_fid_10=OPTION

    Where 10 is the field ID of your dropdown. The only catch with a multiple choice field is that you have to provide a valid option in the dropdown if you have it set so you can't add new options. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      9 months ago

      vikas

      Here is an example of a formula URL button to set the value of a field and refresh the page.

      var text Approve = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_99=" & URLEncode("Order Approved"); // change the 99 to the field ID# of the Multiple choice field field 

      var text RefreshPage =  URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

       
      $Approve
      & "&rdr=" & URLEncode($RefreshPage)



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------