QUOTEWERKS: Getting the address on documents to "look right"

Are you struggling to get the address on your QuoteWerks document layouts to “look right”?

With all the fields available – Address1, Address2, Address3, City, State, Zip and Country – an actual address might be held in just a few or all seven of these fields.

Then try these formulae – just open your QuoteWerks document layout, click the formula button, give the formula a name (e.g. “SOLDTO_ADDRESS”), click OK and copy/paste the formula in.

Sold To:
documentheaders->soldtoaddress1+(.if.(documentheaders->soldtoaddress1=””.or.documentheaders->soldtoaddress2=””).then.””.else.”, “)+documentheaders->soldtoaddress2+addline(documentheaders->soldtoaddress3)+addline(documentheaders->soldtocity)+addline(documentheaders->soldtostate+(.if.(documentheaders->soldtostate=””.or.documentheaders->soldtopostalcode=””).then.””.else.”, “)+documentheaders->soldtopostalcode)+addline(documentheaders->soldtocountry)

Ship To:
documentheaders->shiptoaddress1+(.if.(documentheaders->shiptoaddress1=””.or.documentheaders->shiptoaddress2=””).then.””.else.”, “)+documentheaders->shiptoaddress2+addline(documentheaders->shiptoaddress3)+addline(documentheaders->shiptocity)+addline(documentheaders->shiptostate+(.if.(documentheaders->shiptostate=””.or.documentheaders->shiptopostalcode=””).then.””.else.”, “)+documentheaders->shiptopostalcode)+addline(documentheaders->shiptocountry)

Bill To:
documentheaders->billtoaddress1+(.if.(documentheaders->billtoaddress1=””.or.documentheaders->billtoaddress2=””).then.””.else.”, “)+documentheaders->billtoaddress2+addline(documentheaders->billtoaddress3)+addline(documentheaders->billtocity)+addline(documentheaders->billtostate+(.if.(documentheaders->billtostate=””.or.documentheaders->billtopostalcode=””).then.””.else.”, “)+documentheaders->billtopostalcode)+addline(documentheaders->billtocountry)

For further assistance with QuoteWerks document and report layout authoring, please do not hesitate to get in touch with us on 0844 357 7360 or email sales@hilltopsit.co.uk as well as having a host of report layout examples that we have developed over the years, we offer very competitive hourly rates for building layouts and reports specific to your business’s requirements.

We look forward to hearing from you!

Related Stories

See all

Copying the QuoteWerks QuoteValet URL to the Windows clipboard

Jan 31, 2019

The script below provides a way to quickly and easily copy the QuoteValet document URL for the current open document in QuoteWerks to the Windows clipboard. This can then be pasted into an email or other document to send to your customer. To implement the script, we suggest copy/pasting the below code into a text […]


User is already logged into QuoteWerks message

Jun 18, 2015

This is a fairly rare issue when working with newer versions of QuoteWerks, but it can be very frustrating when it does occur! The issue may occur if a User’s system crashed or they switched off their PC without first logging out of QuoteWerks and requires you to manually delete the “.lck” file associated with […]


QuoteWerks F2 lookup and double click does not work

May 19, 2015

This is another reasonable common query that our clients have which is usually due to the particular User’s Preference settings that is logged in on a particular workstation. Furthermore it will usually affect the User on any workstation that they try and if they log in as a.n.other User then QuoteWerks will probably behave as expected. Ref. […]