Initial in Spanish
I'm new to FM and Db's in general. I'm a film producer and have the need to create a contact Db of cast and crew members who have collaborated with us through the years, as well as a location Db and a prop/art department inventory.
Thing is I live in a spanish speaking country and I don't know how to access a FM solutions in Spanish. So I've opted to translate the contacts solution field by field. So far it has worked, save for a hitch that is the initial in the show all contacts field. I've translated the initial field and Ive been quite thorough.
The calculation is as follows:
Upper (Case (not IsEmpty ( Apellido ) ;Left ( Apellido ; 1 ) ;not IsEmpty ( Nombre ) ;Left ( Nombre ; 1 ) ;not IsEmpty ( Empresa ) ;Left ( Empresa ; 1 ) ;not IsEmpty ( Celular & Convencional ) ;"#" ;not IsEmpty ( Mail ) ;"@" ;" -- "))