Discussions

Expand all | Collapse all

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

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

    Posted 09-12-2018 21:17
    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


  • 2.  RE: Display text from a multiple choice field directly on a Formula URL button.

    Posted 09-12-2018 21:41
    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.






  • 3.  RE: Display text from a multiple choice field directly on a Formula URL button.

    Posted 09-13-2018 13:57
    Jennifer, the field with the button formula has to be a formula - Rich Text field. It won�t work as a formula - text.


  • 4.  RE: Display text from a multiple choice field directly on a Formula URL button.

    Bronze
    Contributor
    Posted 09-13-2018 17:05
    You should be saying &rid=[Record ID#] not &key.


  • 5.  RE: Display text from a multiple choice field directly on a Formula URL button.

    Posted 09-13-2018 18:15
    Key is also an acceptable parameter. 
    Try on your own url, replace rid with key.