Skip to main content
Nintex Community Menu Bar

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


Reply