What I’m currently tackling and need your help with is this:
So far people can find the food they want and order it either via phone or email. Or click to the online store of the producer (1 out of 300…).
Now I connected Stripe and made it possible to buy via the app. This creates a problem. People will add several products, and quite possibly from different producers. That’s fine. What I cannot get around is how do I automate the email/notification part.
I created a separate sheet, which copies the “App:Sales” sheet, but adds crucial info like email of the producer and telephone number.
How do I make it so, that the order of 1 person (say 10 items, from 3 producers), is bulked together into 3 separate orders (in the message, that is) and sent to 3 different producers?
I know there must be some sort of google sheets magic. Someone suggested using Rollup on Airtable… there’s also a rollup function within Glideapps, but no idea how to use it.