ContributionsMost RecentMost LikesSolutionsRe: Need some help understanding how to sort or index in order to concatenate fields across recordsIt's a bit convoluted, but this is what I did: I created a relationship between the notes table and the destination table with a combined text summary field. Then seeing the lukewarm response from the key stakeholders to the formatting (they want a separate line for each and for no shortening of the words in the reports), I then used the Part function to split it out into separate lines in a formula text field. The only thing needing solving at this point is that when the child data is dumped daily, all the notes will disappear on the parent record until the child table receives its new notes for the day. But I think I'll solve this using a second table I created in the past that minimizes the downtime between refreshes. ------------------------------ Davis Ward ------------------------------ Re: Need some help understanding how to sort or index in order to concatenate fields across records The above is the source field (blue) and the destination field (red) Completed it should look like this, but in order by date (text field) ------------------------------ Davis Ward ------------------------------ Re: Need some help understanding how to sort or index in order to concatenate fields across recordsI 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 ------------------------------ Re: Need some help understanding how to sort or index in order to concatenate fields across recordsNo, but one could be easily added. Since the notes table was just an ingest into QB table, I hadn't added one. ------------------------------ Davis Ward ------------------------------ Re: Need some help understanding how to sort or index in order to concatenate fields across records 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 ------------------------------ Need some help understanding how to sort or index in order to concatenate fields across recordsI 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 ------------------------------ Re: Formula Help - Getting a Field Name based on Maximum valueThat did the trick. I had to add a "Max Value" equivalent field. I was just attempting to do it without a middleman field. Thanks! ------------------------------ Davis Ward ------------------------------ Formula Help - Getting a Field Name based on Maximum valueHere is my formula, which returns the value of the maximum. But I'd like the field name of the maximum: If([Sample Size]>1,ToText(Max([Bird Damage],[Bruise],[Corking],[Decay],[Discoloration],[Growth Crack],[Hail Damage],[Insect Damage],[Leaf/Limb Rub],[Mechanical],[Mixed Sizing?],[Mold],[Open Suture],[Potato Skin],[Russeting],[Scar],[Shriveled],[Silvering],[Slip Skin],[Soft],[Soft Tip],[Speckling],[Split Pit],[Staining],[Stem Pull],[Sun Burn],[Undersize],[Worm],[Worm Hole],[Glass/Metal/Rocks/etc.])),null) ------------------------------ Davis Ward ------------------------------ Re: Creating a form with tabbed sections in the middle, but a non tabbed section beneath it.I would think this would be a good feature request for the future, because I have several use cases where it'd be helpful. ------------------------------ Davis Ward ------------------------------ Creating a form with tabbed sections in the middle, but a non tabbed section beneath it.I'm not sure if this is an easy thing I am just forgetting, but I want to have a two tabbed section in the middle of my form (vertically), and have a section beneath them with status and such that displays regardless of tab choice. Is this possible? ------------------------------ Davis Ward ------------------------------