Need a little help to get some direction in order to achieve my goal.
I have multiple data collections with the same fields,each data collection belongs to specfic user.
I want to take specfic rows from all the data collection and insert them into one data collection.
For example, search all data collection, if the field "price" is not null, take the entire row and copy it to another data collection. This way I will merge rows from multiple data collection into one data collection.
Where should I begin from?.
I saw some staff about field links and symbol links but that's not what i need, i think i can achieve my goal only with a code, I thought to achieve it with hooks, on each data collection I will insert hook "if field x is not empty,insert the following fields into data collection x as well".
Is it possible?.