Forum Discussion

Qrew Trainee

3 years ago

Need some help understanding how to sort or index in order to concatenate fields across records

I have two tables, a source table that receives a CSV daily, and a destination table that is interacted with by users. The source table drops in multiple records with the same order number. The differ...

Qrew Trainee

I need the notes in the third column to all be merged into a matching record in another table (merged by SONO) and entered into a text field that sorts the notes by [datetime]

------------------------------
Davis Ward
------------------------------

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

Davis, do you have a Relationship where one Sono has Many Notes?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

DavisWard
Qrew Trainee
3 years ago
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
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  Well 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
  ------------------------------
  - DavisWard
    Qrew Trainee
    3 years ago
    I 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
    ------------------------------