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.

Best Answer


  • {{$}}

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

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

  • Thanks Raymond

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!