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:
Sure.
โฆ how? Virtual columns require formulas. Whatโs the formula to get it to store the key for its parent?
Good question! How would you know which row is its parent?
I donโt really follow your question.
Typically, creating a real column of ref type + marking it as โpart ofโ will automatically 1) alter the parentโs form to allow the user to add a child to it. 2) automatically populate that column with its parentโs key upon creation of a new row. If I create a virtual column with some made up formula, then change it to ref and โpart ofโ, I can achieve the first, but AFAIK, not the second.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |