Data Merge Field as Last Entry will not fill

[MaxClass]

I have a Data Merge Field as the last entry in a file. There are no characters after the last field except the § indicator.

When the Field tag is the last character of a block of text the data will not show when “Preview with record” is checked, but, all other data fields will show the correct data.

As odd as it might seem simply adding a ‘return’ character after the last field to move to the next blank line solves the problem and the merged data appears. Remove the return so only § character follows the last field and all the other merge data will show but not the last field.

I have been able to repeat this time after time. This only happens if a field is the very last entry in a Text Frame so I consider it a bug that should be easy to fix.

MaxClass

[Dan C]

Hi @MaxClass,

Thanks for your report!

I'd like to request a copy of your .afpub file and the data merge document in use, so that I can get this logged with our developers.

Can you please upload these to the below link for me?

https://www.dropbox.com/request/6cx60zwUOgQqsEqZuS9k

Once provided, please reply here to let me know

[StuartRc]

Could it be this?

I had a similar problem a long time ago!.. where you just needed an extra field entry to balance the process

 

[Old Bruce]

I notice this kind of behaviour when copying text with tabs and carriage returns from a text file and pasting that into a spreadsheet, it doesn't work. The final line needs a carriage return for this to work. I suspect that there is something similar happening here.

[MaxClass]

Without going too deep, “Old Bruce” said it in a nutshell.

If the last entry in a document is a Merge Field without a “return” following it that last Merge Field will fail to fill in on a “Preview with record”.

You must have a “return” character following it in order for the Merge Data to appear in that field as “Old Bruce” mentioned above.

The only time this happens is if the last Merge Field followed only by the section character “§”.

This should be very easy to duplicate.

It doesn’t so much cause a problem if you add the “return” character so it’s only a partial bug in that sense but should be fixed for the next release.

Great work guys. The Affinity application are amazing.

Max Taylor

[Dan C]

Thanks for confirming that for me.

I've created a test document here with a Data Merge .csv file, then within Publisher I have a text frame with multiple data merge fields added - and no return after the last entry.

When using 'Preview with record', all merge fields are populated for me, as expected.

Can you please provide a sample .afpub document & data merge file to the above link that shows this for me?

Many thanks once again