Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Gentlemen, is it possible to place the value of a table in a variable?
I need to use an existing value in a table, and it does not have a connection link with other tables in the application.
HI,
since it is a table from your data model you can just load it during load script.
Let vYourVariable = Peek('YourField', 0, 'YourTable'); // 0 is a first row in that table
If your table has many rows and you want users to pick value from UI by selecting single value in your table you can just use "=Only(YourField)" or "'MaxString(YourField)" or similar (depending what your value actually is) formula which will make it dynamic to user selections.
cheers
HI,
since it is a table from your data model you can just load it during load script.
Let vYourVariable = Peek('YourField', 0, 'YourTable'); // 0 is a first row in that table
If your table has many rows and you want users to pick value from UI by selecting single value in your table you can just use "=Only(YourField)" or "'MaxString(YourField)" or similar (depending what your value actually is) formula which will make it dynamic to user selections.
cheers
Thanks friend, this solved my problem!
How would you do this if the source was a table in the UI? Is it possible?