Forum Discussion

JenniferScharpe's avatar
JenniferScharpe
Qrew Member
8 years ago

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

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. 
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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