Check checkboxes based on CSV file input

Ui.Vision HowTo
1

A user asked us:

I hope this message finds you well. I am writing to seek guidance on how to select multiple checkboxes based on the answers provided in a single field of a CSV file. Despite my best efforts, I have not found any information on the support site or through various online searches.

Could you please provide some direction or resources on how to achieve this task? If possible, a sample code or detailed instructions would be greatly appreciated.

Thank you for your assistance, and I look forward to your response.

2

Thanks for providing a test website. → I recorded a macro on this website and found that Ui.Vision records several commands for each checkbox click. But only one of the commands is correct! You need to delete the other commands from the macro:

record and replay
record and replay801×486 102 KB

Once that is done, you can use “IF” command to control the click based on the content from the CSV file:

checkbox click from CSV
checkbox click from CSV799×336 78.2 KB

{
  "Name": "checkbox from csv",
  "CreationDate": "2025-5-7",
  "Commands": [
    {
      "Command": "open",
      "Target": "https://form.jotform.com/251178891979074",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "check",
      "Value": "a3",
      "Description": "This would be content from the CSV, e. g. ${!COL3}"
    },
    {
      "Command": "store",
      "Target": "check",
      "Value": "a4",
      "Description": "would be ${!COL4}"
    },
    {
      "Command": "if",
      "Target": "${a3}==\"check\"",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "id=label_input_5_2",
      "Value": "",
      "Description": "click on box to check it"
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "if",
      "Target": "${a4}==\"check\"",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "id=label_input_5_3",
      "Value": "",
      "Description": "click on box to check it"
    },
    {
      "Command": "end",
      "Target": "",
      "Value": "",
      "Description": ""
    }
  ]
}