Currently, two of my tables include aliases for individuals and organizations. So at the top of each record I have the fields Name and Aliases. Name is just as regular text field, while Aliases is currently a multi-line field, as sometimes a person or organization has multiple different names/different spellings of names.
Users are supposed to separate each alias with a semi-colon. However, to my endless annoyance, many don't, using new lines or commas.
I was hoping for a workaround for this problem. I was thinking one solution would be a system to only allow the generation of one alias at a time, a bit like a multiselect field. However, a multiselect field would make everyone's aliases available to all the records, which I don't want.
Is there another option I'm not thinking of? Some other sort of way to create manual lists within a single field?
(I should add that aliases are not something we want to track in a separate table).
var text replaceCommasAndSpaces = SearchAndReplace([Aliases (separate with ";")],", ",";");var text replaceSpacesAndCommas = SearchAndReplace($replaceCommasAndSpaces," ,",";");var text replaceCommas = SearchAndReplace($replaceSpacesAndCommas,",",";");var text replaceSemiColonsAndSpaces = SearchAndReplace($replaceCommas,"; ",";");var text replaceSpaces = SearchAndReplace($replaceSemiColonsAndSpaces," ",";");var text addBackSpacesAfterSemiColon = SearchAndReplace($replaceSpaces,";","; ");