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:
- create a real column in the events table. Make it type “ref” pointing to Orders table. Tick off " is apart of".
- this automatically creates a virtual column in Orders.
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:
- can I make one table a child of another using a virtual column?
Or a specific answer:
- how do I make a Google calendar table a child of another table without sacrificing fields like description and title?