Hello. So I am writing logic to match “App: Sales” entry as it happens (row inserted) event to what the user was trying to buy. In my case, a user can purchase multiple instances of a service I am offering via my App. User can try multiple instances of my service in trial mode and then decide to pay for the one (or more) they like. Since the “App: Sales” sheet only contains email, name, SKU and item name, how can I map the sales row to exactly one instance of service the user was intending to buy?
So to narrow it down further, I introduced a checkbox (terms and agreement) before the user went on to compare plans and buy one. The checkbox would give me another value to narrow it down from a set of trial records the user is building. This is kind of a work around because the user may check the box and then decide not to proceed with payment then go to another instance, check the box and pay for that one.
However, this is still not full proof. Can there be another unique ID that I can pass in the checkout process that allows me to identify the exact instance the user was intending to buy?
On the same topic, will the row inserted event be triggered if multiple people made transactions at the same time? It would be very bad if row added event is missed due to concurrency limitations.
Thanks for help.