I have an Orders table and I have a Scheduled events table (linked to a Google calendar). Each order should have multiple scheduled events (e.g. order 1 will have dates scheduled for “intake”, “manufacturing”, and “shipping”).
Usually, the recipe I would use is:
But! The issue is: because Scheduled Events is a Google calendar, I can’t add arbitrary real columns. I’ve tried using some of the existing fields (like “event creator” and “web link”) as the ref field, but Google overwrites these values and the connection between the entry and its order is lost. I don’t want to use title and description for appsheet purposes, because these have specific values with specific meanings in my application.
So, I’d love a general answer:
Or a specific answer:
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |