Hey all!
I’m working on lokalnahrana.org, an app that lets people easily find local food producers all over Slovenia (localfood.glideapp.io is the stripped down English version, which was recently featured).
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.
Any thoughts?