Ranorex Forum

Hi All,

I have a field that requires a unique value for each iteration, the obvious answer is to data drive this field.
However, this value is written to the database, and its not going to be always possible to clear the DB down before each run. I was wondering if it is possible to use formulas in a spreadsheet used to data drive tests?

If so i can just prefix or suffix my unique field with the date e.g

In Excel formula =Today() tc1
resulting in
19/08/14 tc1
19/08/14 tc2
19/08/14 tc3

and so on.

any help/advice would be greatly appreciated

Pete

Pete,

Yes, you can use formulas in your Excel data.

You could also create a user code method that creates the unique data for you at run-time by adding the date/time to the value right before you use it in your test.