Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SetInputFieldValue

Hello community!


Please help find solution of the following problems:
The application uses a field of type Input FIeld.
The application logic needs to select some of these field values ​​and assign a new value.
Assigning new values InputField should be done in a macro, which is activated by pressing a button.
Access to selected / available field values ​​can be obtained using methods GetSelectedValues ​​or GetPossibleValues. The new value can be assigned InputField calling method SetInputFieldValue.The method requires a parameter offset.
Is there a way to get the Offset value in a macro?


P.S. Sorry for the bad English.

1 Solution

Accepted Solutions
tanelry
Partner - Creator II
Partner - Creator II

Maybe it is easier to use SetInputFieldCell to write inputvalues into (hidden) tablebox or chart.

  set table = ActiveDocument.GetSheetObject("TB01")

  for RowIter = 1 to table.GetRowCount-1

        'write new value into each row, second column

        table.SetInputFieldCell RowIter-1, 1, "new value"

  next

View solution in original post

2 Replies
tanelry
Partner - Creator II
Partner - Creator II

Maybe it is easier to use SetInputFieldCell to write inputvalues into (hidden) tablebox or chart.

  set table = ActiveDocument.GetSheetObject("TB01")

  for RowIter = 1 to table.GetRowCount-1

        'write new value into each row, second column

        table.SetInputFieldCell RowIter-1, 1, "new value"

  next

Not applicable
Author

Thank you! Your answer helped me a lot.