Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Adding a Name Field

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Ryan_Schaper
6 - Interface Innovator
6 - Interface Innovator

Can you add a field type specifically for names, which would include first name, last name, prefixes and suffixes as an individual part of that field type? I would like to have my first (name) column be a first and last name, but sorted by the last name. And in references to that record, on linked sheets, be able to specify what portion of that name to display (i.eโ€ฆ just the last name, or last name, first name.)

6 Comments
Katherine_Duh
10 - Mercury
10 - Mercury

Ooh, this is very interesting. I donโ€™t know if weโ€™ve actually received this particular request before, but I like it! And we do sometimes get questions about how to sort by last names. Iโ€™ll pass this on to the rest of the team.

Ruth_H
4 - Data Explorer
4 - Data Explorer

Iโ€™d love this. I just got started and donโ€™t know how to sort by last name. Ryanโ€™s suggestion would cover that and much more. :slightly_smiling_face:

Tech_Tylercivic
7 - App Architect
7 - App Architect

I have a NAME column which is populated by the FORMULA. LNAME & ", " FNAME.
Maybe this might be of use.

David_Temple
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 for this. For example, my iPhone allows me to list names as Last, First or First Last; it separately lets me sort by Last or First. Very necessary!

John_McNamee
5 - Automation Enthusiast
5 - Automation Enthusiast

This is what I have too. Mine is a member roster, so the ID field is the FORMULA. LNAME & ", " FNAME field. It works pretty well. But, if they added this field type, Iโ€™d probably migrate to that.

Tech_Tylercivic
7 - App Architect
7 - App Architect

Thatโ€™s my solution, too. โ€ฆ and I add a pseudo suffix for โ€˜duplicateโ€™ "John Doe"s.