Individual fields
TUV Prerequisite Data
Replicate Fields
TUH Research Data
...
- Entity Created
...
- Entity fields created
Based on this article, https://knowledge.technolutions.com/hc/en-us/community/posts/360056255411-Replicate-Blocks-and-Configurable-Joins I built this Research Form Export with Custom SQL query that returns one row per person, with all of their research experiences:
...
A variation on this query powers the research table in the current old dashboard, which is built on the GSBS Reader Dashboard Portal:
...
Will need to clear all of the data and do a single upload once I am sure it works to avoid duplication--there is no unique id to match on, [and no need to create one, if we do them all at once.]
Thought: is there any reason to move them over? I can just inactivate the old fields, and move forward with these. The data will be there, should anyone ever want it, and eventually should be removed. Principle: do not go looking for work, plenty will find you anyway!
...
- Built out new Research Portal page for reader, with new Research-scoped fields
...
Note: TUH: Faculty of Interest field remains as three separate fields:
...