in my database (table) I have the field Name (type is Single line text), where every row of my table contains the full name and format like this:
So it is Name and Surname. Sometimes (rarely) it may be also like this (with middle name):
John William Norton
Evelyn C. Baker
If I want to sort it by Surname, itš not possible, it is always sorted by first name.
Is there any workaroud how can I achieve the sorting by surname (which means second, or better last word - if the middle name is present - from the field)?
I can even imagine that there could be a small update of Baserow product where an ew type of field (it could be called Name type) is introduced and there could be an additional “Sort by last word” checkbox when editing this type of field.