How to do the equivalent of a replace query. Example situation:
a) I have a grid I created called 'projectsomiro' . Now all the items in it (at top level) have the field 'projectsomiro' set to true.
b) I now see I'll have 50 projects, and to make reporting/etc easier, I want just one 'text field' which would contain "somiro", "project x" or another project's name. I don't want 50 true/false fields of course.
How to now basically say: "for each item, if projectsomiro = true then project = "somiro"
Then I would delete my true/false flags.
Based on my early usage I think this will be a common thing to do.