Hello
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?.
Every time I insert or update a collection.
It doesn’t have to be online, I can use a script every 30 min if needed but i gues with hooks it will be online which is better.
@meirhasin and be aware that if you delete the price value of record#1 from collectionA after that, it won’t remove it from the general collection unless you modify the code.