Check a checkbox based on the value "Quantity" next to it in Oracle

[sgarcia (Salvador G.)]

Hello, i’m new in UiPath and i ran into a little problem.

I want to check a checkbox in the Oracle cloud system, based on the value of the “Quantity” column, but UiPath doesn’t seem to detect this as a table.
Also, i would only need it to check once, even if there are multiple values with the same Quantity.

The value i’m comparing it to is from an excel and it changes each loop in the for each excel row.
Most times this is a lone value and it works just fine, but sometimes, in examples like the picture, multiple options appear, any help is appreciated.
Thanks in advance.

[Jeroen_van_Loon]

Knowing these types of Oracle screens, there is no clean way to do it if you follow best practices. So time for a wee bit more crude solution.

Making some assumptions here:
The selectors for all quantity fields are the same. They have the same name, properties etc, except for UiPath own little friend: the ‘idx’ property.

The trick is to just loop through them.
If field with name=‘Quantity’ and idx=‘[your loopcounter]’ exists:
get the text and compare to your excel.
if it matches, check the checkbox with the same idx value.

Carefull though, these fake tables usually scroll poorly. If you scroll down in your screenshot to row 30, the idx’s will most likely still be 1 through 7. So compensate your loop counter for scrolling.

[sgarcia (Salvador G.)]

Thank you very much, i’ll give it a try, scrolling would be a very rare thing, so i think it would be fine.
How would i go arround looping them? And also adding the counter into the idx

[Jeroen_van_Loon]

you create a do while loop, or fixed repeat loop if you have a fixed number of lines.
In the properties of such a loop you can define a counter integer which keeps track of each loop iteration automatically.
instead of idx=‘1’ you get idx=‘{i_LoopCounter}’ where i_LoopCounter is your variable.
Depending on your version it might not accept the integer there, if that happens cast it to a string and embed the string variable into the idx instead of the integer.

[sgarcia (Salvador G.)]

You are a live saver, thank you!