Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Combine element

Topic Labels: Formulas
190 1
cancel
Showing results for 
Search instead for 
Did you mean: 

60B45693-89F9-4597-B5CD-0932795869F8_4_5005_c

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
673EE9E9-5552-41F6-9198-5B305DB7CBA2_4_5005_c

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.