Forum Discussion

SamW's avatar
SamW
Qrew Cadet
5 years ago

How to create lists of entries in a single field?

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 cu...
Formulas and functions
Relationships
Tables and fields
AustinK's avatar
AustinK
Qrew Commander
5 years ago
I know you said you do not want to track them in a separate table but this is exactly what that is for with a relationship. That way you could have an unlimited amount of aliases and also control exactly how they are written there.

What is the reasoning for not wanting to do this in a separate table? Maybe there is an issue you have with it than can be overcome.
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Just to add to Austin's post above, the solution is to have the data entry be into a child table, as Austin suggested but then use a combined text summary field to float the alias names up to the parent so they can be seen on reports.  The words can be formatted to be vertically separated or with a semi colon or any separator.  That way they would be all standardized format.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------