0

Display multiple records in one line in formula

I'm looking for a way to show different lines from one table as formula on an other table (in a single field).

So, I have a table InventLocation, where the display field (formula) needs to be added.
A subtable contains following fields:
  - reference to InventLocation
  - reference to VendTable (from which I use the Abbreviation column)
  - Reference (just a text field)

I added the formula field as follows: InventReference.VendTable.Abbreviation + " " + InventReference.Reference

Data in the InventReference (for one selected InventLocation) is
  - AA, 111
  - BB, 222
  - CC, 333
Result of formula:  "AABBCC 112233"
Where I would like to see  "AA 111 - BB 222 - CC 333"

So the grouping of the different values is wrong. I guess I have to make some kind of loop ?

Can someone help me out ?

12 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Does this work in your situation? : join(InventReference.VendTable.Abbreviation + " " + InventReference.Reference," ")

    Didn't try myself (lack of time) 

    Steven

    • Frederik_Depuydt
    • 4 yrs ago
    • Reported - view

    Thanks for the reply, but it seems like function "join" does not exist?

    • Mconneen
    • 4 yrs ago
    • Reported - view

    Are you trying to do something like this?? 

    • Mconneen
    • 4 yrs ago
    • Reported - view

    (oops.. )   Are you trying to do something like this?? 

    parentChild

    • Frederik_Depuydt
    • 4 yrs ago
    • Reported - view

    Yes, indeed. The result should be something like

    "Child 1 = 2, Child 2 = 2"

    I left out the "This is Parent Record - " piece of the sting for readability
    Behind the =-sign is the number of attachments value

    So a combination of 2 fields from a signle record, and each record separated by a , or ; or whatever  :-)

    • Frederik_Depuydt
    • 4 yrs ago
    • Reported - view

    I've found a workaround myself.

    Created a formula field (called DisplayVendReferenceFull) on the child table:     VendTable.Abbreviation + " " + Reference
    Then added a formula field on the parent table:     concat(InventReference.DisplayVendReferenceFull)

    It works, but I'm still interested in a single formula if that would be possible  :) 

    • Nick
    • 4 yrs ago
    • Reported - view

    I have something similar (if I understand you correctly)...

    Master table > Subtable

    Screen Shot 2019-10-03 at 22.56.46

    If this is what you want, the code for the above formula is:

    ---

    join(Subtable.("Date: " + Date + "
    Text: " + Text + "
    Amount: " + Amount), "

    ")

    ---

    I hope it helps

    • Nick
    • 4 yrs ago
    • Reported - view

    or

    ---join(Subtable.(Date + " - " + Text + " - " + Amount), "
    ")

    ---

    Screen Shot 2019-10-03 at 23.10.44

    • Nick
    • 4 yrs ago
    • Reported - view

    pffff!

     

    join(Subtable.(Date + " - " + Text + " - " + Amount), "
    ")

    • Frederik_Depuydt
    • 4 yrs ago
    • Reported - view

    Thanks, that's exactly what I wanted to achieve!!

    • Etienne_Rossouw
    • 4 yrs ago
    • Reported - view

    Hi.

    Annotation 2020-02-03 164427

    I am looking for a similar solution but for use in a Table. Code sworks fine in a multi line field but not in a table.

    I would like to show product pack sizes underneath each other or atleast make it easier to read without having to go into link first.

    • Support
    • 4 yrs ago
    • Reported - view

    Create a new column showing only the name:
    –––
    first(split('Product Full Name', " ("))
    –––

    Birger 

Login to reply

Content aside

  • 4 yrs agoLast active
  • 12Replies
  • 3278Views