Discussions

 View Only
  • 1.  Using IF statement to create a button based on stage level 1-8

    Posted 08-14-2019 21:41
    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? 


  • 2.  RE: Using IF statement to create a button based on stage level 1-8

    Posted 08-14-2019 21:54
    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