Showing images instead of labels in reports

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a summary report where I am listing position by banner.   How do I show certain jpg images (logo of business) to replace labels in this report?  I do have a separate table where I store my images.  
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Not tested, but. but try this as a formula text field with HTML enabled (checkbox)

// first determine which logo to use. We need to calculate the Record ID number where to logo is stored.
Replace the 1, 2, 3, etc with the correct Record ID numbers.

Var text LogoRecordIDNumber = ToText(Case([Banner],

"BWS",1,
"Dan Murphy's",2,
"Metro",3,
"Woolworths",4,
"Woolworths Petrol",5,
"Countdown",6,
"Big W",7,
"Masters",8,
"FreshChoice",9,
"Thomas Dux",10,
"Online",11,
"Super Value",12));

//I'm not sure off hand if the single apostrophe will work OK for Dan Murphy's

"

Replace the 13 with the field ID number of the file Attachment field.

Play with height to get the logo size you like.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Many thanks. So assuming this check box sits in the logos table and when linking to these records from my stores table, I understand I will need a web reference of each record? Is that right.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 49,572 Points 20k badge 2x thumb
I'm not sure what you mean by a checkbox. Also, I'm not sure what you mean by "a web reference".

You said in your post that you had a table of logos.

My solution will work in a table report. I have not ever used a logo image in a summary report, for the row or columns, but it should work.
(Edited)
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks. Will leave it for you to find a resolution otherwise. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 49,572 Points 20k badge 2x thumb
I did a test and logos will work fine in a summary report for the row and column headings.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks. Just sent you an email and this is one of the issue therein.  
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Why not store the company image on the company table?