This is my search. It takes a long time, how can I better optimize this search?
Workflow → When button is pressed for an approval, add that user to the tracking data type under the To Be Reviewed list of users with the current page’s approval.
Your database structure needs improvement. A tracking object currently contains an approval, and the approval object holds a list of trackings. This design is generally not ideal. Additionally, could you clarify if a user can be associated with multiple tracking → to be reviewed objects?
1 Like