Forum Discussion

JenniferScharpe's avatar
JenniferScharpe
Qrew Member
7 years ago

Display text from a multiple choice field directly on a Formula URL button.

I have created a formula URL button that takes me to a different form for updating information such as status, etc.  But I would like the button to display the text results from a multiple choice (complete, canceled, Open, etc) field that is in the same table.  I have created a formula text field and used the following formula...

"<a class='Vibrant Success' href='" & [Update Status_Facilities]& "'>"&[Facilities_Status]&"</a>"

And this is the formula i am using for my button 

URLRoot() & "db/" & Dbid() & "?a=er&key="&[Record ID#]&"&dfid=14"


but this is not working. Sure i am missing something? Any help would be greatly appreciated? 

Thank you
Formulas and functions
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    Hello Jennifer, 

    This URL should be working, can you confirm that the url itself is working to open the record in Edit mode in the form id 14?
    URLRoot() & "db/" & Dbid() & "?a=er&key=" & [Record ID#] & "&dfid=14"


    The other request, I do not know how to show the values of a drop down text field dynamically in a formula. I would have to hardcode them into the formula.




  • ForrestParker's avatar
    ForrestParker
    Qrew Cadet
    7 years ago
    Jennifer, the field with the button formula has to be a formula - Rich Text field. It won�t work as a formula - text.
    • KevinSlider's avatar
      KevinSlider
      Qrew Trainee
      7 years ago
      Key is also an acceptable parameter. 
      Try on your own url, replace rid with key.