Skip to main content
Question

Showing images instead of labels in reports

  • May 8, 2017
  • 0 replies
  • 26 views
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.  
      This topic has been closed for replies.

      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.
      • ArshadKhwaja
      • Author
      • Quickbase Alumni
      • May 8, 2017
      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.  
      • MCFNeil
      • Quickbase Alumni
      • May 8, 2017
      Why not store the company image on the company table?
      Terms & ConditionsAccessibility statement