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..
Solved! Go to Solution.
CONCATENATE(
[Dossagio]],
" ",
[Prodotto].[ColumnNameForTheProduct]
)
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)
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
CONCATENATE(
[Dossagio]],
" ",
[Prodotto].[ColumnNameForTheProduct]
)
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |