0

alphabetical index

Hello,
I have a table with all my clients, I would like to group them by the first letter in order to have an alphabetical index, someone would have an idea of the formula to use

thank you in advance for your help!

2 replies

null
    • Ivan_Savochenko
    • 5 yrs ago
    • Reported - view

    Hi,

    In your Clients table add formula field e.g. Index. Insert there formula substr('firstname', 0, 1) like this. Show that Index column in your table and make it Grouped.

    • Administrateur
    • 5 yrs ago
    • Reported - view

    great it works as I wanted thank you very much!

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1029Views