Reorder Linked Field Values by Another Field

[Alina_Sigitova]

Hi all,

I know that you can reorder linked field values by the Batch Update app, but I was wondering if there was a way to reorder linked values by another field related to that field.

Example: We are linking people’s first & last name between two tables (“Jane Doe”, “Amy Smith”, “Harry Barrel.”) Instead of chronologically sorting them, is there a way to sort by their last name ("Jane Doe, Harry Barrel, Amy Smith)? We have a field that has only their last names, if needed, that is related to the linked field value.

Thanks so much for your help!