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

Related Content

Data Source with random amount of lines

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

Generate a random number within a range

entering random keys

Random factor calculation for Load Profile= Random

Recent Discussions

Onscreen Object Selector Slowness

aqObject.CheckProperty() slowness

Problem with generated data table and keyword test

WebView2 support does not work

System checks for Object for every test