The solution is to be able to find & recode individual transaction lines across all tabs.
So you could use advanced query to filter out lines where project is not empty, then set project to be empty in bulk.
We already have advanced query and ability to see which transaction lines have project set. What we don’t have is ability to recode single field in bulk.
Yes, you can use Batch Update
but it would be better if this could be done within the program.
Another thing I’m pursuing is ability to purge historical data. So for example, if you are purging transactions more than 5 years old, then that would also clear out tabs that haven’t been used for long time.
So eventually this will be solved one way or another.