topic Re: Alternate Column Color Based on Date Range, and Conditional Text in App Development

Alternate Column Color Based on Date Range, and Conditional Text

bruce_sorge — Fri, 02 Apr 2021 08:24:59 GMT

Greetings,

I have attached a spreadsheet to show the information I am referring to.

I need to color the columns based on conditions. If the Complete field has an x, then it should be blue. The first column that doesn't have an x in Complete is the step the item is at, and it should be green. If the column has exceeded the baseline in days, it should be red.
I also want to show a text box above the table that shows the step that the item is at based on the first column for Complete being blank. (I am basing display of table data based on GetFieldSelections function)

Thanks in advance

Bruce

lorenzoconforti — Fri, 17 Apr 2020 15:02:09 GMT

Hi Bruce, can you share a sample application with this data?

It would be easier to help you

bruce_sorge — Mon, 20 Apr 2020 12:17:02 GMT

Sure, attached is my .qvd file.

Bruce