Discussions

Expand all | Collapse all

Highlight Row based on Multipule Choice Field

Archive User03-08-2018 01:39

QuickBaseCoach Dev./Training03-06-2018 21:42

Archive User03-08-2018 01:26

QuickBaseCoach Dev./Training03-08-2018 01:45

QuickBaseCoach Dev./Training03-08-2018 01:46

Archive User03-08-2018 01:46

Archive User03-08-2018 01:46

  • 1.  Highlight Row based on Multipule Choice Field

    Posted 03-06-2018 21:36
    New to Quickbase.  Looking to highlight a row based on the status drop down.  I have the multiple choice drop down but cant figure out how to get it to highlight the row based on what is chosen.


  • 2.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-06-2018 21:41

    If([status]="value","#CCDDFF","")

    ^^ that would go into the report configuration. Do you know where that is?



  • 3.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:39
    no


  • 4.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-06-2018 21:42
    Is this a Multiple Choice field type or a Multi select field type.


  • 5.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:26
    Multi Select


  • 6.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:44
    var text MultiTextFormat = ToText([my multi sect field]);

    IF(
    Contains($MultiTextFormat, "apples", "red"),
    Contains($MultiTextFormat, "bananas", "yellow"),
    Contains($MultiTextFormat, "apricots", "orange"))

    for the actual colour codes I suggest using the hex codes in this app by another QSP Laura Thacker.  for example use say #FF6EB4 instead of red.

    https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1


  • 7.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:45
    That code goes in the row colorization box for a table report type.


  • 8.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:46
    Actually it is now called 

    Color-code rows using a formula


  • 9.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:46
    i don't see that option


  • 10.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:48
    Are you saying that you don't see 

    Color-code rows using a formula

    at the bottom of a table report configuration screen?


  • 11.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:52
    where is the table report configuration screen?


  • 12.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:54
    Have you build a report?  If so, just "Customize this report" at the top right when viewing the report.

    If you have not built a report, then go to Reports and Charts and create a new report of type Table.


  • 13.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 02:03
    Got it.  Now have this error.

    The types of the arguments or the number of arguments supplied do not meet the requirements of the function Contains.

    The function is defined to be Contains (Text u, Text v).


  • 14.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 02:06
    My IF has the brackets in the incorrect place.

    In future please post your code when you have a syntax error.

    IF(
    Contains($MultiTextFormat, "apples"), "red",
    Contains($MultiTextFormat, "bananas"), "yellow",
    Contains($MultiTextFormat, "apricots"), "orange")


  • 15.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-08-2018 01:46
    ok but where do I put that code?


  • 16.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-13-2018 16:07
    This worked only for my home screen.  When I click on the other screens they are not highlighted.

    Please advise.


  • 17.  RE: Highlight Row based on Multipule Choice Field

    Posted 03-13-2018 16:25
    Each separate report will need to have it's own formula for the row colors.  You will need to copy the formula to the other reports.