AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Highlighting of Gen...
 
Notifications
Clear all

Questions Highlighting of Generic Inquiry Rows or Columns in Data Table Widgets

 
Page 1 / 2 Next
Acumatica Generic Inquiries & Pivot Tables
Last Post by Michael Shirk 2 months ago
28 Posts
7 Users
1 Likes
3,676 Views
RSS
paulsw
Posts: 12
 paulsw
Topic starter
January 21, 2020 11:13 pm
(@paulsw)
Eminent Member
Joined: 3 years ago

Can someone point me to where I can find some documentation of the colors available or how to select a color?

27 Replies
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 22, 2020 12:07 pm
(@wyatt-erp)
Estimable Member
Joined: 3 years ago

I am not sure if they have documentation anywhere, but these are the options:

bad, good, neutral, red, red60, red40, red20, red0, orange, orange60, orange40, orange20, orange0, green, green60, green40, green20, green0, blue, blue60, blue40, blue20, blue0, yellow, yellow60, yellow40, yellow20, yellow0, purple, purple60, purple40, purple20, purple0

 

If you check out .\*YourSiteFolder*\App_Themes\Default\00_Controls.css and look for anything that is .GridRow.[Style] you can find the css code.  I ended up creating a custom theme.  You can add extra css files and create your own custom GI styles by adding the files 01_Controls.css, 02_Controls.css, etc.  If, for example you wanted to add Bold or Italic, you can create an 01_Controls.css file and add the following:


.GridRow.bold {
font-weight: bold;
}

.GridRow.italic {
font-style: italic;
}

.GridRow.red20bold {
background-color: rgba(255, 0, 0, 0.2) !important;
border-bottom-color: rgba(255, 0, 0, 0.2) !important;
font-weight: bold;
}

.GridRow.red20italic {
background-color: rgba(255, 0, 0, 0.2) !important;
border-bottom-color: rgba(255, 0, 0, 0.2) !important;
font-style: italic;
}

.GridAltRow.italic, .GridAltRow.bold
, .GridAltRow.red20italic, .GridAltRow.red20bold {
filter: brightness(98%);
}

Reply
paulsw
 paulsw
(@paulsw)
Joined: 3 years ago

Eminent Member
Posts: 12
January 23, 2020 12:55 pm
Reply toWyatt.ERPWyatt.ERP

@wyatt-erp

Thank you!

How did you learn about these values in the Controls.css?

Do you know if this same ability to add colors is available for the dashboard tiles?

Reply
Michael Shirk
 Michael Shirk
(@michael-shirk)
Joined: 2 years ago

Active Member
Posts: 8
July 12, 2023 11:50 am
Reply toWyatt.ERPWyatt.ERP

@wyatt-erp Hey Wyatt, I'm needing to add some additional style options to the GI row styles options.
I created the "01_Controls.css" file and added your example css, but I'm not seeing them in the formula builder with the other styles.
I'm assuming there are additional steps I'm missing, or this file needs to be added via a customization project?

My understanding of css is fairly limited.

Thank you!

Reply
Michael Shirk
 Michael Shirk
(@michael-shirk)
Joined: 2 years ago

Active Member
Posts: 8
July 12, 2023 12:03 pm
Reply toMichael ShirkMichael Shirk
Wyatt.ERP

Wyatt,
Update: After reading your reply below about using the browser tools to inspect the page, I did the same and discovered that it was actually pulling styles from the new file I had created. (I had copied the entire "00_Controls.css" file and added your examples to it.)
After seeing that, I went into the GI and replaced the color style in the formula with one of the new ones I had added and it worked, even though those styles were not showing as available in the formula editor!

Were you able to make your custom styles show up in the formula editor?

 

Thanks for the tips!

Reply
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 23, 2020 2:38 pm
(@wyatt-erp)
Estimable Member
Joined: 3 years ago

@paulsw

You’re welcome.  I learned about them initially from Acumatica’s summit last year.  Once I had a version of 2019 R1 to test with, I added the purple20 style to a GI result.  I used browser F12 tools to inspect the HTML and saw it added the purple20 style as a class on the element, and saw the css class for it on the side.  I used windows search to look through the website files to find files with “purple20” in their contents.  The other stuff about controls I picked up from either trial and error, Googleing articles about custom themes, or investigating their Indigo theme. 
As for Dashboards, I don’t know if the styles carry over from GI into the Dashboard grid.  If you use the browser F12 tools you should be able to investigate the element to see!  It might just need a different css class to activate it besides “.GridRow.”.  I have a feeling if it’s not there, it would be coming in a future release. 

Reply
Tim Rodman
Posts: 3044
 Tim Rodman
Admin
February 19, 2020 11:43 pm
(@timrodman)
Famed Member
Joined: 8 years ago

I can see a list of colors by clicking the Pencil Icon in the Row Style field on the RESULTS GRID tab of the Generic Inquiry (SM208000) screen, then click the Styles category:

Reply
Erzi Zairbekova reacted
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 15, 2020 1:06 pm
(@erzi-zairbekova)
Active Member
Joined: 3 years ago

Does conditional formatting in GI allow to use nested formulas? 

I tried to apply color to only open bills that are past due, and it didn't work: 

=IIf( [APInvoice.Status]='open', Switch([APInvoice.DueDate]<Today(), 'red'), 'default')

Reply
Ryan Brown @xByte Hosting
Posts: 84
 Ryan Brown @xByte Hosting
April 22, 2020 3:16 pm
(@ryanxbyte)
Estimable Member
Joined: 3 years ago

I am not sure if you already found a solution, but if the switch doesn't work,  I know nested if's work.  You could do:

=IIf( [APInvoice.Status]='open', IIf([APInvoice.DueDate]<Today(), 'red', 'default'),'default')

 

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Active Member
Posts: 6
April 22, 2020 6:16 pm
Reply toRyan Brown @xByte HostingRyan Brown @xByte Hosting

@ryanxbyte Thank you for your reply! 

I just tried your way - didn't work either, not sure why... 

Reply
Ryan Brown @xByte Hosting
Posts: 84
 Ryan Brown @xByte Hosting
April 22, 2020 10:59 pm
(@ryanxbyte)
Estimable Member
Joined: 3 years ago

Have you been able to get any color to show up?  If you put something simple like ='red' into the row style, does it turn everything red?  And then something else like =iif(1=1,'yellow','red') should turn everything yellow.  You could then try nesting the if to be =iif(1=1,iif(2=2,'green','yellow'),'red').  That should turn everything green.  If that works, then the problem is in the iif statement logic and not with nesting iif's.  

Reply
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 23, 2020 9:45 am
(@erzi-zairbekova)
Active Member
Joined: 3 years ago

If I put =IIf( [APInvoice.DueDate]<Today(), 'yellow60', 'default') - it turns due date that are less than today to yellow, including those are closed, 

when i put =IIf( [APInvoice.Status]='open', IIf( [APInvoice.DueDate]<Today(), 'red','default'), 'default') - it doesn't' do anything.

Reply
Ryan Brown @xByte Hosting
Posts: 84
 Ryan Brown @xByte Hosting
April 23, 2020 11:27 am
(@ryanxbyte)
Estimable Member
Joined: 3 years ago

I tried changing the order a little and then changing APInvoice to be CuryOrigDocAmy and got my new version to work change color as expected so the issue is not with the nested IIF.  There is something wrong with APInvoice.Status.  I tried several variations of the logic: ='Open',='O',=Open.  All of the variations resulted in a false value.  Maybe someone else has gotten the APInvoice.Status to work in a condition.

 

My working example

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryOrigDocAmt]>1000, 'red','yellow'), 'green')

Reply
Ryan Brown @xByte Hosting
Posts: 84
 Ryan Brown @xByte Hosting
April 23, 2020 3:42 pm
(@ryanxbyte)
Estimable Member
Joined: 3 years ago

Just had a random thought while poking around Acumatica and it worked.  Use the style below and it should work.  Change colors to whatever you want.  Since Status was giving us problems, I found another field that gave the same results.

 

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'red','yellow'), 'green')

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Active Member
Posts: 6
April 23, 2020 4:36 pm
Reply toRyan Brown @xByte HostingRyan Brown @xByte Hosting

@ryanxbyte

This is what the outcome 🙁 

image

 

 

Reply
Ryan Brown @xByte Hosting
 Ryan Brown @xByte Hosting
(@ryanxbyte)
Joined: 3 years ago

Estimable Member
Posts: 84
April 23, 2020 4:41 pm
Reply toErzi ZairbekovaErzi Zairbekova
Ryan Brown @xByte Hosting

@erzi-zairbekova You're going to have to change the colors back to what you wanted.  I did the multiple colors to better trace what was happening.

 

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'default','red'), 'default')

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Active Member
Posts: 6
April 23, 2020 5:15 pm
Reply toRyan Brown @xByte HostingRyan Brown @xByte Hosting
Erzi Zairbekova
Ryan Brown @xByte Hosting

@ryanxbyte I see, but I meant was, that it applies color even to those are closed:

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'default','red'), 'default')

image

 

 

Reply
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 23, 2020 5:22 pm
(@erzi-zairbekova)
Active Member
Joined: 3 years ago

So far This is how I got the closest to what I wanted:

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryDocBal]>0, 'red0','default'), 'green')

image

But, for some reason, the formula picked up the closed bill as green. 

Thank you for your help Ryan  - the APInvoice.CuryDocBal was a good workaround about APInvoice.Status not working properly.

Reply
Ryan Brown @xByte Hosting
Posts: 84
 Ryan Brown @xByte Hosting
April 24, 2020 3:16 pm
(@ryanxbyte)
Estimable Member
Joined: 3 years ago

Try using docbal.  If not, then look over the data and see if there is any other combination of fields that would give you the same results as status='open'.  I have also had luck creating cases with Acumatica.  There may be an easy solution for how to compare Status.

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.DocBal]>0, 'default','red'), 'default')

Reply
Tim Rodman
Posts: 3044
 Tim Rodman
Admin
July 13, 2020 11:18 pm
(@timrodman)
Famed Member
Joined: 8 years ago

Don't you need the Status Code rather than the word "Open"? Does this work?

=IIf( [APInvoice.Status]='N', Switch([APInvoice.DueDate]<Today(), 'red'), 'default')

image

 

image
Reply
Lorne W.
Posts: 25
 Lorne W.
June 3, 2022 8:33 pm
(@lweinstein)
Eminent Member
Joined: 1 year ago

I am trying to set conditional formatting on GI by row for shipping status in shipments.  My goal is to have the row highlighted green if the status is "On Hold".  However, every combination that I try fails.  Can anyone suggest a formula?

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 8 years ago

Famed Member
Posts: 3044
June 10, 2022 11:10 am
Reply toLorne W.Lorne W.

@lweinstein Can you screenshot the formula that you are using?

Reply
Lorne W.
 Lorne W.
(@lweinstein)
Joined: 1 year ago

Eminent Member
Posts: 25
June 10, 2022 11:22 am
Reply toTim RodmanTim Rodman
Lorne W.

@timrodman =IIf( [SOShipment.Status]='Open', 'green', 'default' )

Reply
Tim Rodman
Posts: 3044
 Tim Rodman
Admin
June 10, 2022 11:27 am
(@timrodman)
Famed Member
Joined: 8 years ago
Posted by: @timrodman

Don't you need the Status Code rather than the word "Open"? Does this work?

=IIf( [APInvoice.Status]='N', Switch([APInvoice.DueDate]<Today(), 'red'), 'default')

Ah, yes, this is the same issue that I mentioned above.

In your case, here are the codes for SOShipment.Status that you can see by using CUSTOMIZATION -> Inspect Element:

image
Reply
Page 1 / 2 Next
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,359 Topics
  • 10.3 K Posts
  • 3 Online
  • 1,979 Members
Our newest member: Penny Tingle
Latest Post: Timecard reports/queries
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×