one value from field of numbers

[miro_kopecky]

Hi
I've got field of numbers and i need to use only one of them in expression...is it possible to filter this number of that field?
Thanks in advance

[Thiago_Justen_ · Accepted solution]

Miroslav,

You can filter it into load script just like this:

Load

Your_Fields

From Your_Base Where Number=Your_Number;

If what you want is filter it on user interface, maybe this will help you:

Only({<Number={1}>}Number)

Cheers

[miro_kopecky]

Thanks, its working but i have another question...These numbers are currency rates from the website which is daily updated. Does it update these numbers in my app too ?

[Thiago_Justen_]

My solution was not a dynamical one. So, in this case I'd suggest you something like this:

Only ({<Date_Field={$(=today ())}>}Number_Rate)

Then you will get only today's rate.