Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody.
I have a problem with a table and textboxes.
I have a selection of data to be displayed in the textbox as colored. If I have only one entry in my data table the required text box is highlighted.
Once more data are available in the table, the mark is no longer running.
What can I do?
For example a qvw is added.
greetings Sven
try with combination of Datum_verg&Schicht&HALLE.
=IF(index(concat(Datum_verg&Schicht&HALLE,','),'1A1')>0,Red(),
IF(DAY(MakeDate(Year(Today()),Month(Today()),1))<DAY(Today()),Green(),White()))
You can try like this.
SubStringCount('|' &Concat(Datum_verg, '|')& '|','|1|')
Karthik
You can achive the result using concat and index function.
Example for Datum_verg=5, Schicht='A' and HALLE=1
=IF( index(concat(Datum_verg,','),'5')>0 and index(concat(Schicht,','),'A')>0 and index(concat(HALLE,','),'1')>0,Red(),
IF(DAY(MakeDate(Year(Today()),Month(Today()),5))<DAY(Today()),Green(),White()))
Attached the updated QVW file for your reference
Thanks,
K.Raja
Thanks for your help
I tested the the formula but I have no success.
Can you please explain the formula nearer.
I tested the formula in other textboxes.
And for the example aboth if I change the Schicht A to B, the textbox will also colored to red. Although in the data table no Schicht= B for Datum-Vergl=5.
try with combination of Datum_verg&Schicht&HALLE.
=IF(index(concat(Datum_verg&Schicht&HALLE,','),'1A1')>0,Red(),
IF(DAY(MakeDate(Year(Today()),Month(Today()),1))<DAY(Today()),Green(),White()))