Dynamically Select item with Click Activity from built-in notebook

Help StudioX
,
1

Hi all! I am using a “Click” activity within the “Use Browser” resource. I want the bot to select a specific day on a webpage based on the value in cell B4, ‘Date’ tab from the built-in excel notebook. So let’s say that cell B4 in the ‘Date’ tab of the built-in notebook is showing a value of “08/13/2024”. I want the bot to select that value (in this case “08/13/2024”) in the webpage by using the “Click” activity. Please advise

2

@alberto.lombardi

please try this

  1. Read Cell (B4 from Date Sheet) → Assign to dateValue
  2. Format Date (if necessary) → Assign to dateValueFormatted
  3. Use Browser Activity:
    • Open URL
    • Click Activity:
      • Selector: <html title=‘Your Web Title’…>…
3

Hello @alberto.lombardi ,
If you want to select from a menu list, you can use the ‘Select Item’ activity. In the ‘Item to Select’ field, you can use your date variable, which allows it to work dynamically.

4

@alberto.lombardi
Use Excel File ‘YourExcelFile.xlsx’
Read Cell ‘Date!B4’ → dateFromExcel (String)
Assign formattedDate = DateTime.Parse(dateFromExcel).ToString(“MM/dd/yyyy”)

Use Browser ‘YourTargetBrowser’
Click ‘Date’ → Use a dynamic selector with formattedDate

5

Hi Naveen, thanks for the reply. Not sure where to go on the last bullet point " * Click Activity:

  • Selector: <html title=‘Your Web Title’…>…"
6

hi @sayali.p , thanks for the reply. I’m getting this error when trying this option . My target is not a valid UI element
image

7

Hi @Krishna_Raj , thank you. Where can I find the dynamic selector in the Click Activity?

8

@alberto.lombardi ,

We can’t find the dynamic selectors, we need to modify the static selectors to dynamic.

Please share the complete selectors which you are getting for the click activity based on that we can able to suggest you.

thanks

9

Hi @alberto.lombardi
could you share the website where you’re trying this?

10

This error occurs because your input is not in the menu items. It’s better to use the Click activity, and from the Selector property, select Fuzzy Selector. Pass your date variable through that.

Thanks Sayali,

11

hi @naveen.s , sorry for the delay in my response. This is what I see from “properties”

image
image411×1018 35.4 KB