Combine element

Topic Labels: Formulas
389 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I would like to Combine this become Below Result :

65 Kodi (Seri warna) , 10 Kodi (Pilih Warna)

If I simply using Concatenate For This
it simply Show like This

I am Using This Formula

CONCATENATE({Jumlah Pesan (from Pesan Ke Sup)},{Satuan Pesan},{VarianPesanan (from Pesan Ke Sup)})

Is There Any Can Help , TQ

Screen Shot 2021-07-02 at 15.35.41

1 Reply 1

Welcome to the community, @Sunaryo_PS! :grinning_face_with_big_eyes: Unfortunately Airtable formulas don’t provide a way of splitting the data from multiple fields so that items are paired properly. However, because you have three lookup fields all pulling from the same linked source (I presume), the solution is to build the combination in that source table using a formula field, then lookup that formula field.