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

The Digital Backbone of Modern Manufacturing: Trends in Backend Software and Workflow Integration

Jul 10, 2025

In 2025, the manufacturing sector – particularly in the UK and USA – is undergoing a profound transformation. While much attention is given to robotics, AI, and smart factories on the production floor, an equally important revolution is happening behind the scenes: the modernization of backend business software. From quoting and CRM to invoicing and […]

READ MORE

ConnectWise Sell vs QuoteWerks: A Comparison

Jul 09, 2025

📝 Introduction: A Reseller’s Perspective As a long-standing QuoteWerks Reseller and Solutions Partner, we at Hilltops IT have proudly supported businesses across the UK, Europe and Worldwide in streamlining their sales quoting processes. Over the years, we’ve seen first-hand how QuoteWerks empowers teams with flexibility, speed, and reliability. However, in recent months, we’ve observed a […]

READ MORE

🎥 Help Us Help You: What QuoteWerks Challenges Should We Cover Next?

Jul 08, 2025

At Hilltops IT, we’ve spent years helping businesses get the most out of QuoteWerks, from streamlining product imports to customizing PDF layouts, integrating with downstream systems, and everything in between. Now, we’re excited to launch a new series of webinars and YouTube videos designed to tackle the most common (and not-so-common!) QuoteWerks challenges. But here’s […]

READ MORE