You could use conditional formatting to hi light the rows.
You could have two buttons, one of which is conditionally hidden.
Thank you for your reply. I have the following issues:
1. How do I use conditional formatting for the whole row and not for a
2. how can I compare the two tables so I can highlight the selected rows
and not be able to select them again (similar example like having a product
list and a cart with some products selected, I want to highlight the
products already in my card when I search the product list)
To highlight the whole row you select the leftmost field in your list layout, duplicate it, make it large and tall as the body part is, put your conditional formatting onto it, set the padding to 5000, send it to back. Also make sure that the other fields have no fill set.
When you select a line, add its ID to a global variable $$CurrentSelection: Set Variable [$$CurrentSelection; List($$CurrentSelection; YourLineID)]
The conditional formatting will be based upon PatternCount( ¶ & $$CurrentSelection & ¶; ¶ & YourLineID & ¶) being 1 or not.
To deselect the line you substitute YourLineID in $$CurrentSelection with "XXXX".
Can you help me with the comparison between the two tables? I have tried using ExecuteSQL to get the IDs and do the comparison but I was unable to do it.
Is ExecuteSQL the right direction to do this comparison and use it in the conditional formatting?
the ExecuteSQL was to fill the data in one of the two arguments for
I used filter values and the conditional formatting worked OK