ProductsProductVendorOrder DateAdvance Payment DateMaterialsMaterial VendorsMaterial Vendors (Line Breaks)Material Order DatesMaterial Order Dates (Line Breaks)AppleVendor 1Jan 2, 2020Jan 5, 2020BoxCartonsSealing TapeMaterial 4Material 5MaterialsNameProductsVendorMaterial VendorOrder DateMaterial Order DateBoxAppleVendor 1Box = Jan 8, 2020CartonsAppleVendor 2Cartons = Sealing TapeAppleVendor 3Sealing Tape = Jan 8, 2020Material 4AppleVendor 4Material 4 = Material 5AppleVendor 5Material 5 = VendorsNameProductsMaterialsVendor 1AppleBoxVendor 2CartonsVendor 3Sealing TapeVendor 4Material 4Vendor 5Material 5Material Vendorprop("Name") + " = " + prop("Vendor")Material Vendors (Line Breaks)replaceAll(prop("Material Vendors"), ",", "\n")Material Order Dateprop("Order Date") ? (prop("Name") + " = " + formatDate(prop("Order Date"), "YYYY-DD-MM")) : (prop("Name") + " = " + "Pending")Material Order Dates (Line Breaks)replaceAll(prop("Material Order Dates"), ",", "\n") By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
