INTERACT FORUM
More => Old Versions => Media Center 14 (Development Ended) => Topic started by: leezer3 on January 25, 2010, 03:49:01 pm
-
OK, it's that time of year again- I'm on another major library cleanup and standardisation.
One thing I've noticed is that I have a *lot* of files with both an original title (French, Japanese etc. etc.), and a translated English title. I'm currently using two fields for this (Title_ENG & Title_OL)- This works fine until I find a file which only has one of these filled.
Anyone have a clever way to bind these two together?
Ideally I'd like to be able to work both ways, so that I can either view the original titles, with English where these aren't present, and English titles, with the originals where the English is missing :)
-Leezer-
-
you could make a calculated field to bind them into a list field.
make a library field. set the library field to list and call it for instance all titles. close the library manager.
(this seems like a step to many, but is important, that way the library will remember that it is ment to be a calculated list field.)
open in the library manager the same field and set it to calculated field.
now you could try something like this:
[title_ol];[title_eng]&datatype=[list]
now this could give you sometimes ; that might or might not get in the way.
to get rid of it this could work
if(isempty([title_eng]),[title-ol],if(isempty([title-ol]),[title_eng],[title_ol];[title_eng]))&datatype=[list]or something like that. could be missing some ()) did not test it, just hope it gives you an idea.. when you get stuck please post again.
:)
gab