Hi!!
I am creating a marketplace.
In the marketplace there are different stores.
The user decides in which store to buy.
Each store has contact information, such as address, telephone, whatsapp.
In google sheet database, I have 2 sheets.
One has the information of each store and I have called this sheet “stores”
And the other is the shopping cart, I have named this sheet “cart”
In the shopping cart I need to create a column that contains the WhatsApp of the store where the user is buying.
How can I bring the whatsapp number from the “stores” sheet and put it in the “cart”?
The first challenge I have is to recognize in which store the user is buying and depending on that information, enter the WhatsApp of the store in the “WhatsApp of the store” column located in the “cart” sheet.
Thanks