kevinbellnj
IS-IT--Management
I have recently found out that CR 8.5 (which was shipped with Goldmine 6) is not completely compatible with Goldmine 6.5 and so you must upgrade to CR9.
Well I have done this and my formula fields have turned to jibberish(sp?)...
I have tried to rebuild the formula fileds in the new appication (CR9) but to no avail.
I have to think that this is a bug or something because when I insert the field it originally is legible. Its when I resize the field to see the entire result that the field turns into something illegible.
The formula field is written as follows:
StringVar sCompanyNameAddress:='';
StringVar sCompany:= If isnull({CONTACT1.COMPANY})
or {CONTACT1.COMPANY} = ''
then '' else 'Company: '+ {CONTACT1.COMPANY} ;
StringVar sDBA:= If isnull({CONTACT2.UDBA})
or {CONTACT2.UDBA} = ''
then '' else chr(13) + 'DBA: '+ {CONTACT2.UDBA} ;
StringVar sAKA:= If isnull({CONTACT2.UALIAS})
or {CONTACT2.UALIAS} = ''
then '' else chr(13) + 'AKA: '+ {CONTACT2.UALIAS} ;
StringVar sAddress1:= If isnull({CONTACT1.ADDRESS1})
or {CONTACT1.ADDRESS1} = ''
then '' else chr(13) + 'Address: '+ {CONTACT1.ADDRESS1} ;
StringVar sAddress2:= If isnull({CONTACT1.ADDRESS2})
or {CONTACT1.ADDRESS2} = ''
then '' else chr(13) + ' ' + {CONTACT1.ADDRESS2};
StringVar sCity:= If isnull({CONTACT1.CITY})
or {CONTACT1.CITY} = ''
then '' else chr(13) + ' ' + {CONTACT1.CITY} + ', ';
StringVar sState:= If isnull({CONTACT1.STATE})
or {CONTACT1.STATE} = ''
then '' else {CONTACT1.STATE}+ ' ';
StringVar sZip:= If isnull({CONTACT1.ZIP})
or {CONTACT1.ZIP} = ''
then '' else {CONTACT1.ZIP} + chr(13);
Does anybody work with goldmine enough to have seen this before? I am ssuming its a software issue and not a scripting issue because it worked fine in the previous version of the application. This is not the only field, it is happening with any of the formula fields that combine more than one piece of data
Well I have done this and my formula fields have turned to jibberish(sp?)...
I have tried to rebuild the formula fileds in the new appication (CR9) but to no avail.
I have to think that this is a bug or something because when I insert the field it originally is legible. Its when I resize the field to see the entire result that the field turns into something illegible.


The formula field is written as follows:
StringVar sCompanyNameAddress:='';
StringVar sCompany:= If isnull({CONTACT1.COMPANY})
or {CONTACT1.COMPANY} = ''
then '' else 'Company: '+ {CONTACT1.COMPANY} ;
StringVar sDBA:= If isnull({CONTACT2.UDBA})
or {CONTACT2.UDBA} = ''
then '' else chr(13) + 'DBA: '+ {CONTACT2.UDBA} ;
StringVar sAKA:= If isnull({CONTACT2.UALIAS})
or {CONTACT2.UALIAS} = ''
then '' else chr(13) + 'AKA: '+ {CONTACT2.UALIAS} ;
StringVar sAddress1:= If isnull({CONTACT1.ADDRESS1})
or {CONTACT1.ADDRESS1} = ''
then '' else chr(13) + 'Address: '+ {CONTACT1.ADDRESS1} ;
StringVar sAddress2:= If isnull({CONTACT1.ADDRESS2})
or {CONTACT1.ADDRESS2} = ''
then '' else chr(13) + ' ' + {CONTACT1.ADDRESS2};
StringVar sCity:= If isnull({CONTACT1.CITY})
or {CONTACT1.CITY} = ''
then '' else chr(13) + ' ' + {CONTACT1.CITY} + ', ';
StringVar sState:= If isnull({CONTACT1.STATE})
or {CONTACT1.STATE} = ''
then '' else {CONTACT1.STATE}+ ' ';
StringVar sZip:= If isnull({CONTACT1.ZIP})
or {CONTACT1.ZIP} = ''
then '' else {CONTACT1.ZIP} + chr(13);
Does anybody work with goldmine enough to have seen this before? I am ssuming its a software issue and not a scripting issue because it worked fine in the previous version of the application. This is not the only field, it is happening with any of the formula fields that combine more than one piece of data