Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[leezer3]

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-

[gappie]

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:

Code: [Select]

[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

Code: [Select]

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