Default value - BusinessAddress- Pernames.ntf

HCL Domino Domino Forum
1

the businessaddress field in pernames.ntf (R6), has a default value which takes the value of Office Street, ZIP, State, etc. fields.

The weird thing (at least for me) is that if businessaddress field has any value it will be refreshed every time you modify the Office street, zip, state fields.

Since it’s the default value, shouldn’t it evaluate the formula when the document is created only??

If businessaddress is blank, it will always be blank, it seems that the formula is not evaluated.

does anyone know why??

thanks!

2

Subject: Default value - BusinessAddress- Pernames.ntf

it’s a bug. A fix has been submitted to the R7 codestream.

To fix your names.nsf, modify the Contact form and add the bolded code to the Exiting event of the CompanyName field:

if doc.isnewnote then

doc.OfficeStreetAddress=othernote.OfficeStreetAddress

doc.OfficeCity=othernote.OfficeCity

doc.OfficeState=othernote.OfficeState

doc.OfficeZip=othernote.OfficeZip

doc.OfficeCountry=othernote.OfficeCountry

doc.BusinessAddress=othernote.BusinessAddress

end if

3

Subject: RE: Default value - BusinessAddress- Pernames.ntf

http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg21111043

http://www-1.ibm.com/support/docview.wss?rs=475&context=SSKTWP&context=SSKTMJ&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB560&dc=DB540&dc=DB510&dc=DB550&q1=BusinessAddress+and+names&uid=swg21180750&loc=en_US&cs=utf-8&lang=en

This issue was reported to Quality Engineering and was addressed in Notes 7.0 Client. This issue will not be addressed in Notes 6.x.

Workaround:

Change the Business column formula in the Contacts view from:

@Trim(

@If(CompanyName != “”;CompanyName;“”):

@If(JobTitle != “”;JobTitle;“”):

@If(BusinessAddress != “”;OfficeStreetAddress :

@Trim(OfficeCity + @If(OfficeCity != “” & OfficeState != “”;“, “;””) + OfficeState + " " + OfficeZip) :OfficeCountry;“”)

)

to:

@Trim(

@If(CompanyName != “”;CompanyName;“”):

@If(JobTitle != “”;JobTitle;“”):

@If(BusinessAddress = “” & OfficeStreetAddress=“” & OfficeCity=“” & OfficeState=“” & OfficeZip=“” & OfficeCountry=“”;“”;OfficeStreetAddress :

@Trim(OfficeCity + @If(OfficeCity != “” & OfficeState != “”;“, “;””) + OfficeState + " " + OfficeZip) :OfficeCountry)

)