I have 2 tables: Parent table has the following columns.
The child table has the following columns
When I view the Child Table details, I will be able to see the Parent Name via the virtual column's formula. The problem with this setup is due to my company's sequence of operations.
(The actual scenario is the Child Table contains rows of quotations to client, and the Parent Table is the Purchase Order received which can encompass multiple quotations).
This has mostly worked for many months. But recently there were some Child Table rows that do not show the Parent Key (ie: sometimes the bot does not work properly).
My Proposed solution: Rebuild the Child Table without the Parent Key column. Use a virtual column to display the Parent information. Thus, no more bots.
However, this would mean I need to use a resource expensive formula for the virtual column such as ANY(SELECT(Parent Table[Parent Key],CONTAINS([LIST OF CHILD KEYS],[_THISROW].[CHILD KEY])). My app is already very slow due to large amounts to data in Google Spreadsheet.
Any suggestions for how I can accomplish my goal while using less resources?
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |