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 difference between each record is that in this other program (the source of the CSVs) is listing any notes/messages on the order as a separate line. I want to concatenate them in a text field in order of their posting. How would I go about doing that?------------------------------Davis Ward------------------------------

Davis,To make sure the data looks something like this assuming five columns of data:2, 4, 6, Count, Address This was a strange thing make sure sales ...3, 7, 11, Count, Address Really good lead move to the front of the list ....and what you want is this with six columns2, 4, 6, Count, Address, This was a strange thing make sure sales ...3, 7, 11, Count, Address, Really good lead move to the front of the list ....------------------------------Don Larson------------------------------

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------------------------------

Davis, do you have a Relationship where one Sono has Many Notes?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

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------------------------------

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------------------------------

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

DonLarson
Qrew Elite
3 years ago
Davis,

To make sure the data looks something like this assuming five columns of data:

2, 4, 6, Count, Address
This was a strange thing make sure sales ...

3, 7, 11, Count, Address
Really good lead move to the front of the list ....

and what you want is this with six columns

2, 4, 6, Count, Address, This was a strange thing make sure sales ...

3, 7, 11, Count, Address, Really good lead move to the front of the list ....

------------------------------
Don Larson
------------------------------
- DavisWard
  Qrew Trainee
  3 years ago
  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
    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
    ------------------------------

Forum Discussion

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

Related Content

Custom Record Titles

Record Details

Using Grid Edit to Edit Multiple Records at Once

Copy Records Step - Skipping All Records

Missing Records/Data Issue