Page 1 of 1

Use Table as Input data

Posted: Tue Dec 17, 2024 12:10 am
by ilcaa
I saw an older video that used Data.Input to return data from table to use as an InputValue
I dont see that function in the Trial.

if i have a table of 5 columns and 30 rows and I want the values of each column to be used within seperate Browser.InputValues

i see I can do a query But how do I query using the current sequence # as the ID and how do I extract the value of the row (5 values) to specific InputValues

PseudoCode:
Sequence.Take
- 50 (the number of rows in my Table)
-Action.QueryScalar
--Select * from myDB where ID=(current Loop Value)
---as currentRow

-select.ckExact
-Browser.InputValue
--currentRow[0]
(based on query of current row which has 5 columns, i use [array] to return input value)

-select.ckShowDetails
-Browser.InputValue
--currentRow[1]


-select.inputState
-Browser.InputValue
--currentRow[2]

hope i made sense.... thanks. Cool tool, hard to learn