Forum Discussion
MarkShnier__You
Qrew Champion
Davis, do you have a Relationship where one Sono has Many Notes?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
DavisWard
2 years agoQrew Trainee
No, but one could be easily added. Since the notes table was just an ingest into QB table, I hadn't added one.
------------------------------
Davis Ward
------------------------------
------------------------------
Davis Ward
------------------------------
- MarkShnier__You2 years agoQrew ChampionWell you can create a combined text summary field to rule out text from children up into a parent record. The trick is how to control the sort, because they will sort alphabetically.
So I have a collection of crazy formulas that attempt to deal with the sort issue, but I will need to test before posting.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- DavisWard2 years agoQrew TraineeI just remembered why I haven't added a relationship. Each day, that table is automatically cleared after the data is pulled into the destination table (all records deleted). This is because there is no unique ID to link up/merge to when a new legacy program csv is pulled each day.
------------------------------
Davis Ward
------------------------------- MarkShnier__You2 years agoQrew ChampionActually, I can't really picture what you want the result to be. Can you post an example with an example of what you want the result to look like and in which table the result would be.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------