count records

Can a UI-Field be used to count the number of records selected in a query? The first record would be “1”, the second “2”, the third is “3” etc.

{{$Model.INSERT_MODEL_NAME_HERE.data.length}}

would give you a count of all the rows in a model if you use it in a template/rich text/text or UI formula.

Thanks Raymond.

That give me the total records selected.

1.png

The “Number” field is an UI-Only field with your formula. I would like the first record “Number” to be “1”. If there were 3 records. then the “Number” would show “3”.

See this post on {{Index}}.

the first row is 0 so you may want to do {{Index}} +1 in your formula

http://community.skuid.com/discussion/7674111/display-the-row-number-in-skuid-table

Raymond - you are the best! Thanks for the multiple good answers.

Thanks Raymond