how to use Random Data every time you run a TC

Question

Hi, I am trying to search for school names when I log in to my login page and then add products for those schools, how can I use a new school whenever I run the test, can anyone guide me, please? I have an Excel sheet that has about 20 names I want to use. so if I run the test 1 time I want it to pick any random name or 1st from the list, then next time when I run the same scenario I want it to use a different name.

if someone can share an example I appreciate it, I am not using any scripting just simple test cases using record options.

thanks, Gill

rraghvani · Answer

To achieve this, you will most likely have to use a script, create a function to read the contents of your Excel spreadsheet, store all the values into an array. Generate a random number, this will be the index value to retrieve the item from the array.
There will be plenty of examples on the Internet, such as https://www.w3schools.com/JS/js_random.asp , https://www.w3schools.com/JS/js_arrays.asp , https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html&nbsp;
&nbsp;

Forum Discussion

how to use Random Data every time you run a TC

1 Reply

Related Content

Data Source with random amount of lines

entering random keys

Generate a random number within a range

how to make Data generator to execute every test for random data

Random factor calculation for Load Profile= Random

Recent Discussions

Audit and Reporting purposes

Textbox values disappear after adding Year value from Date Picker

Values from previous Textbox disappears when it's time to input the date value

How to connect to remote desktop using testcompleted ?

How to verify data from another application, the data which keeps changing