Function FieldValue without the distinct values

[richters]

Hi all,

I am using the FieldValue- function to set my variables with a specific data row of a table (loop through the table). The problem is that the function takes distinct values of the column in the table which means that if a value is twice in there, the second one will be missed out.

Is there a function that gives me the value of row x in the table?

What I try to do is :   Let valueX = FieldValue('MyField',$(rownumber));

Thank you!

[Gysbert_Wassenaar · Accepted solution]

You can use peek and specify a row number: peek('MyField', $(rownumber),'MyTable')

[richters]

Thank you, great. Didn't know that peek() works out of a load-statement. Thank you very much!

[#4]

it doesn't work when I call peek function in a text object properties..... what can I do?

Thanks

K

[Anonymous]

I wish I read this about 2 hours ago!!

Exactly what is the purpose of the Fieldvalue function to begin with is my question.?? 

I made the mistake of copying somebody else's example using Fieldvalue and went on a wild goose chase until I discovered it was omitting repeat values.

[marinasbc]

Hi Gysbert,

And if you need to use this on the front-end, do you have any ideas how to?

Thank you,

Best Regards,

Marina