Skip to main content
Nintex Community Menu Bar
Solved

count records

  • July 11, 2024
  • 5 replies
  • 43 views

Forum|alt.badge.img+14

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.

Best answer by Skuidward_Tentacles

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

5 replies

Forum|alt.badge.img+17

{{$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.


Forum|alt.badge.img+14
  • Author
  • July 12, 2024

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”.


Forum|alt.badge.img+17

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


Forum|alt.badge.img+17
  • Nintex Employee
  • July 12, 2024

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


Forum|alt.badge.img+14
  • Author
  • July 12, 2024

Thanks Raymond