Formula Query Sorting
Does slist and option=sortorder work within formula queries? In my formula query my items return the correct values but the sort does not work. Also does num-# work with the amount of records you w...
Forum Discussion
Hi Tyrone;
I don't think this would work.
In your "Query" you don't have only query you have also sorting and sorting option
GetRecords formula doesn't accept sorting parameters yet; if I know it correctly
For the number of records you can use "Count" function. I wanted to see number of records so I have created a numeric formula field in my application to capture that.
it is something like this:
Count(ToText(GetFieldValues(GetRecords($myquery, "xxxxxxx"), 3)), ";")+1
I hope this will help.
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
I don't think this would work.
In your "Query" you don't have only query you have also sorting and sorting option
GetRecords formula doesn't accept sorting parameters yet; if I know it correctly
For the number of records you can use "Count" function. I wanted to see number of records so I have created a numeric formula field in my application to capture that.
it is something like this:
Count(ToText(GetFieldValues(GetRecords($myquery, "xxxxxxx"), 3)), ";")+1
I hope this will help.
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------