Forum Discussion

OwenMorgan's avatar
OwenMorgan
Qrew Member
6 years ago

display image based on field content

I want to display a particular image depending on the content of a status field so that we can have a highly visual indication of the status of a record. 

I have created 4 images but dynamic form rooms don't apply to text field. I assume this will need some custom script unless someone has found a way to work such thing. 

The images look like this....


------------------------------
Owen
------------------------------
  • You should be able to do this easily, either using a formula which will calculate to the correct image, or with form rules. There is no reason why you cannot do it the simple way and use form rules.

    Can you describe further work for rules are not working for you?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • OwenMorgan's avatar
      OwenMorgan
      Qrew Member
      Thanks Mark. 
      I have placed the image on the form using a text block but I cannot create a rule based on a text box. 
      I have avoided placing the image in a field as I thought the formatting would be strange.

      ------------------------------
      Owen Morgan
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        OK, now I understand. So what do you want to do is instead build a rich text formula fields to display those same images. Then you will be able to control the appearance of that field using form rules.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------
  • If you find you have the need to display your images in your reports, you can add them to an HTML table within a formula rich text field. I used this for an Ergonomic Risk Assessment app and created a report that allows users to scroll through a list all of the job assessments and get quick descriptive visual information.   



    ------------------------------
    Adam Keever
    ------------------------------
    • KenLoder2's avatar
      KenLoder2
      Qrew Member
      Thanks, Blake.
      There was a typo in the formula and it is working now.

      Ken
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        It looks like you just need to update your formula. Right now you have this:

        <img src=&'https://*                 and 
        <img source&=https://*


        This should be:

        <img src='https://*

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quickbase Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------