Forum Discussion

GaryBoyd's avatar
GaryBoyd
Qrew Assistant Captain
7 years ago

Change default field background color- on form in display record mode

Hi,
In edit mode, the fields have a white background so look good in the browser.
In display mode, the fields have a grey background - not so good for some formula rich text fields, that display info based on choices in my app.

Using this works well, but still leaves a small grey border-
"<div style=\"background-color:white;\">"&

if I could make that border white, then the field looks totally clear, apart from text. Hoping someone can tell me how to make background and the border white/ clear.
Tried this, but it only adds another border:
"<div style=\"background-color:white;border: 20px solid White;\">"&

Many thanks.
APIs and custom code
App builders
Ask about Quickbase functionality
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    It is the containing <td> that is setting the background of the cell not the contents of the cell. So there is no formula that will change the background of the containing <td>. You have to use script to change the background using this line of code:
    $("table.LabelsLeft td.cell").css({backgroundColor: "white"});
    You can try this line of code by pasting it into the console and then implement it using the IOL technique.
  • GaryBoyd's avatar
    GaryBoyd
    Qrew Assistant Captain
    7 years ago
    Thanks Dan. 
    Seems to be a lot you can do with IOL and BOL so thought I better start with IOL as seems a little safer for a noob. Questions:
    1. Any security risk with others being able to run scripts with either of these techniques, and access info they shouldn't?
    2. I assume these techniques are fine to use with app tokens.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    1) Only an admin can setup the IOL technique so it is safe as long as you trust your admin.

    2) yes
  • GaryBoyd's avatar
    GaryBoyd
    Qrew Assistant Captain
    7 years ago
    You can try this line of code by pasting it into the console and then implement it using the IOL technique."

    Hi Dan,
    I have not been able to get this to work. What do you mean by pasting into console as I have just added the line to the codepage that already loads the iol
    Thanks


  • GaryBoyd's avatar
    GaryBoyd
    Qrew Assistant Captain
    7 years ago
    Apologies - your code works as stated. However it only works if you have section headings on the forms set as: 'to the left of fields' and not 'above fields'.

    This was really frustrating me and took a long time to figure out why it wasn't working as I have almost all forms set to above fields.

    Any advice on how to get it working on both types of section headings would be great, but this is still a big improvement from the standard view form with they grey backgrounds so many thanks yet again!
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      Try this for labels above:
      $("table.LabelsAbove div.cell").css({backgroundColor: "white"});