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.


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.


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

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

Thanks Raymond