Skip to main content
Question

Using IF statement to create a button based on stage level 1-8

  • Aug 15, 2019 1:41 AM UTC
  • 0 replies
  • 32 views
Our company currently uses stages to determine what needs to be done on a particular job. I currently have a Text-Multichoice field that allows a user to select which stage the job is currently on when they update the form and then it displays this choice on the report.
I would like to set this up as a Formula-Rich Text field that displays a colored button based on the stage the user selects when editing the form.

example:
Stage 1 = Blue Button 
Stage 2 = Green Button
Stage 3 = Yellow Button
Stage 4 = Red Button 
etc.

Can anyone assist with writing up a IF statement I can go off of? 
    This topic has been closed for replies.

    Here is an example
    Case([Priority],
    "Low",    "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";,
    "Medium", "<img src=https://images.quickbase.com/si/16/223-point_yellow.png>";,
    "High",   "<img src=https://images.quickbase.com/si/16/221-point_red.png>";
    )

    There are 502 handy icons in 5 convenient sizes here https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160
    Terms & ConditionsAccessibility statement