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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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
Photo of Jennifer Scharpenberg Thomas

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
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.




Photo of Forrest Parker

Forrest Parker

  • 598 Points 500 badge 2x thumb
Jennifer, the field with the button formula has to be a formula - Rich Text field. It won’t work as a formula - text.
You should be saying &rid=[Record ID#] not &key.
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
Key is also an acceptable parameter. 
Try on your own url, replace rid with key.