DISPLAY TEXT/RESULTS FROM ANOTHER FIELD ON A FORMULA URL BUTTON

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a form that includes a formula url button that when clicked opens another form for editing certain fields on the same record.  I would like the button to display the results from another field (multiple choice) in the same record (ie: complete, in progress dispatched, etc).  Is there a formula for this type of thing?  Thanks. 
Photo of Jennifer Scharpenberg Thomas

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
You will want to make a formula-text field, to be able to insert the text as desired.


"<a class='Vibrant Success' href='" & [Your Formula URL Field]& "'>Your Button Text</a>"

You can make it conditional if the url changes based on the status.
Or, if your URL is always the same, but you just want the button text to change you can use something like this

"<a class='Vibrant Success' href='" & [Your Formula URL Field]& "'>"&[Your Multiple Choice Field]&"</a>"


Let me know if that helps