VC formula to join lists of 2 columns

[bolognesiedalla]

hi everyone i created these tables for an app that builds fertilization plans:

RIGHE INTERVENTI tables is a part of RIGHE PIANI that is a part of PIANI

in UX RIGHE INTERVENTI_inline, i would like to add the value of RIGHE INTERVENTI [DOSAGGIO] next to each product name

for example:  5,1 Magic Crop - 10 Fitophos K ecc..

considering that the number of RIGHE INTERVENTI for each RIGHE PIANI is variable, how should I modify the field [related Product], to add [DOSAGGIO]?

THIS IS THE FORMULA AND THE FIELD CREATED..

[JuneCorpuz]

Hey.

Under the the Right Intervenni table, you can create a virtual column that concatenates the Dossagio and Prodotto and make it as your label for that table so when you select the items in Right Intervenni (assuming you are selecting the ID) then it will give you the result of (5, 1 Magic Krop, etc)

[bolognesiedalla]

what formula do you recommend to concatenate the [PRODUCT] and [DOSAGE] values ​​in a laternated way?

I can get

PRODOCT1, PRODUCT2, PRODUCT3, DOSAGE1, DOSAGE2, DOSAGE3

but how do i get it

DOSAGE1 PRODOCT1, DOSAGE2 PRODUCT2, DOSAGE3 PRODUCT3

[JuneCorpuz · Accepted solution]

CONCATENATE(
[Dossagio]],
" ",
[Prodotto].[ColumnNameForTheProduct]
)