I’ve inherited a wonderful database that someone has asked me to modify. I need to change the value of a column from one field to another, but I need to do this on about 400 views. I obviously don’t want to do this manually. Is there a way to do this programmatically? The current view is called ‘Additional Info’ and is assigned the field partinfo. Partinfo doesn’t display anything, as it is a rich text field. I would like to assign it to partinfotext, which is the same field converted to plain text. The Additional Info column is programmatically also named partinfo, in every view.Any ideas as to the quickest way to update these columns? Any help is appreciated.
Subject: NotesViewColumn object
You could drill down from the NotesDatabase object to get each NotesView and then look into the NotesViewColumn object. This will allow you to change certain things about the view column (header, formula etc)
Mike