Replace property address fields if empty with main address fields

[fergal]

Hi,
I have a template were there is an address box which appears in the envelope window and another text box which contains the property address on another part of the template, what I need to do is if the property address box fields are empty on some letters then put the address from the other box in it keeping both

my fields are as follows, address box in envelope window
Add1
Add2
Add3
Add4
Add5
Add6

Address in property box
Property1
Property2
Property3
Property4
Property5
Property6

Your assistance would be appreciated

[jchamel]

Unless your Template is very complicated, it is simply a matter of checking the content of your Property field using a script.

This can be achieved in your Datamapper where you would fill the Property fields with those of the Addresses fields when those of Property are empty.

It can also be achieved in your Template when you are using script for your placeholder. You check if the fields for Property are not empty and if they are, you use the values from the Addresses ones.

[fergal]

Hi Jchamel,

I tried to do it in the datamapper using an action after the extraction but I could not get it to work using and tweaking the information that marten and Phil posted from these threads

Datamapper and .replace empty cell

Hi guys. I’m trying to use the .replace javascript function so that when it finds a blank cell within a field, it replaces it with the text of my choice. For example, I use the following with great success to change text in the field to either differing text or to show as blank, however for the life of me I can’t do it the other way around. data.extract(‘Field_1’,0).replace(/\OLD_TXT/g, ‘NEW_TEXT’); data.extract(‘Field_1’,0).replace(/\OLD_TXT/g, ‘’); Example 1 shows how I replace text from …

Datamapper - how to test for empty values in the source XML file and replace with a default.

you could add an additional data field to your data model and assign the XML field or a default value depending on the content of the original XML data; this could be done with JavaScript in an Action step.

I will have another look in the template script and see if I can work out how to do it in there

[jchamel]

Can you anonymized your Datamapper and share it?
If not, send me a private message and I will give you my email address so you can share it with me and i will look into it.

[Erik]

There are multiple ways to do this. In Designer you could use a single script that calcs the length of your Add fields and based on the outcome copy the contents of the box holding the main address to the Add box. It could look something like this:

The box on the left is my Add box (I assigned an ID called ‘add’) and the box on the right holds my main address (has an ID called ‘main’). I’m using query(’#main’).html() to retrieve the contents of the main box.

[Erik]

When the address data is in a JSON data field it could look something like this:

More information on JSON data fields can be found here:

Simplify your Data Model using JSON data fields

[fergal]

Hi Erik,
My main Address placeholder is called @Address@ in a text script and my other placeholder text script is called @PropAddr@

If the PropAddr is empty i want to put the details from the @address@ in the @PropAddr@ box

I amended your script to suit this but its not working, can you check it please in case i have made a mistake

var PropAddr = (record.fields.Property1 + record.fields.Property2 + record.fields.Property3 + record.fields.Property4 + record.fields.Property5)

if( !PropAddr.length) {
results.html( query(’#Address’).html() )
}

@Jchamel
I will send you pm shortly

[jchamel]

Hello @fergal,

Has what I sent you fixed your issue?

[fergal]

Hi Jchamel,

Yes, that worked perfectly

Thank you so much, for your help its very much appreciated.