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
Jul 01, 2021 11:45 PM
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
Jul 06, 2021 07:02 AM
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.