I have a trouble finding the way to send the SMS to my customers with the completed order and order details. Upon submitted order I have created a automation bot to send the order and the order detail to my customers but only it sends the order information and not the order detail records related to this order ID for the SMS.
1.Order table column names
Order ID
Customer name
Date
Order total
2.Order detail table column names
Order detail ID
Order ID Link (Reference column to order table)
Product
Quantity
Cost
Total
Thank you for your time.
Kind Regards,
Nishat
T
LinkedIn
Twitter
