Skip to main content
Question

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

  • September 13, 2018
  • 0 replies
  • 95 views
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
    This topic has been closed for replies.

    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.




    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.
    Terms & ConditionsAccessibility statement