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": ""
    }
  ]
}
3

Can you show how it would be done if you are given this csv file https://drive.google.com/file/d/1aZPYT5mTjUIH8241jCdAEFp4Suh4nADa/view?usp=sharing

4

Does it have to be in this format? The csv input file would be easier to parse (for the ui vision macro) if you have one column per check box.

So instead of

image
image959×175 24.1 KB

use

date, first, last, phone, question1, question2, question3

28 Apr 25, Joe, blow, 999 888 777, check, - , check

In my example, question 1 and 3 would be checked, question 2 not.

5

Yes it does have to be in this format. I was able to do this no problem in imacros