Hi everyone, trying to select an option in a google form based on the value read in the current row in the excel table. Here is an image of the options
I have managed to create a variable for the text that I want to select. The variable is called Event_value , however I cannot seem to get my automation to click on the correct value.
My fuzzy selector is "<webctrl aaname='{{Event_value}}' tag='SPAN' check:innerText='{{Event_value}}' />" and my strict selector is <webctrl aaname='{{Event_value}}' tag='SPAN' /> and my window selector is <html app='chrome.exe' title='RPA Form' />
I did not select an anchor. When I select the “Morning” option the fuzzy selector is "<webctrl aaname='Morning' tag='SPAN' type='' class='aDTYNe snByac OvPDhc OIC90c' check:innerText='Morning' />" and the strict selector is <webctrl aaname='Morning' tag='SPAN' /> . For the “Supper” option the selectors are "<webctrl aaname='Supper' tag='SPAN' type='' class='aDTYNe snByac OvPDhc OIC90c' check:innerText='Supper' />" and <webctrl aaname='Supper' tag='SPAN' />
I would really appreciate some help on this matter, thank you.
Yep, running it seems to be really weird, even after I have changed to a dynamic selector, it will still select the old option. E.g. if i used selector on “Afternoon” and then changed the selector, it will still select “Afternoon”. If i used selector on “Supper” and changed selector, it will still select "Supper:
I have tried putting in a default value for the variable but makes no difference. I have uploaded the strict selector in my original post. Here is the code file
Weird. This might mean also that the variable is not updating.
Can you add a log message/message box before the click to check what the Event_Value variable contains? that would be the only explanation i can think of.
if you can share the sample form, we would be able to test.
Update: Fixed it. I cleared the default value (dont think that is the issue though). Turns out my targeting methods was set to Fuzzy Selector and image. Switched it to strict selector and it worked. Thank you so much everyone