Hello, I am very new to this. I need to fill a website form from a CSV file.
the CSV file contains data with the same order as the form
I need to pick RANDOM fields data each time i play the macro (not a random line)
(for example)
CSV format is: First Name, Last Name, Job title, salary
Michael, Berry, Analyst, 2800
Daniel, Brown, Sales Manager, 4100
John, Doe, IT Specialist, 3500
What i need is that, each time run the macro “Filling form”, it will pick a random First name (Let’s say John), a random Last Name (for example, Berry), a Random job tile (Analyst) and a random Salary (4100)
This will be easy. I can create such a macro for you.
Just to clarify: Do you want to
pick just a random row (e. g. John, Doe, IT Specialist, 3500)
or randomly mix values from all rows in the CSV, e. g. John, Berry, Sales Manager, 2800?
Alternatively if you just need random values of any kind you can use the LLM command aiPrompt with a prompt like
Generate a genuinely random person profile with the following details:
* First name (avoid common examples like John/Jane)
* Last name (avoid common examples like Doe/Smith)
* Job title (avoid defaults like Software Engineer but only reasonable titles)
* Monthly salary in USD (numerical value only, between 2,000-15,000)
Format as a single comma-separated line with no explanations or additional text