Data from unrelated field populating text box publisher data merge

[JustMeTrying]

Hey All,

 Hoping someone can help with this weird data merge issue. I have text boxes that I have assigned individually to their own respective fields within the csv. For some reason though, the data from the active field is filling into ones that should be blank. Each of these text fields have their own name and instance in the layers window and each has its own field in my data. Why are they deciding to auto populate with unrelated data? Only the bottom row of fields should be populated at the moment.

Also, I've tried searching but keep coming up with the wrong instance, how can I make the text scale to the text box. As in make it shrink to fit when using the data merge, so scale the width but keep the height the same. I know this is an option in indesign but I need that same option in publisher.

Thanks

[lacerto]

I tried this on both platforms with 6 text boxes getting data from a .csv file with the first three columns blank and data only in the remaining three, but the text boxes get correctly populated, so more information or an example with merge setup would be useful in an effort to reproduce. Are the text boxes correctly populated when you assign fields to text boxes using the Fields panel and only getting confused at merge time?

As for you second question, I do not think that you can have selective formatting applied based on merged content in Affinity Publisher so the best option would probably be going through afterwards the text boxes and apply e.g. paragraph formatting with horizontal character scaling etc. for ones with overflowing or wrapped content.

[JustMeTrying]

5 hours ago, lacerto said:

I tried this on both platforms with 6 text boxes getting data from a .csv file with the first three columns blank and data only in the remaining three, but the text boxes get correctly populated, so more information or an example with merge setup would be useful in an effort to reproduce. Are the text boxes correctly populated when you assign fields to text boxes using the Fields panel and only getting confused at merge time?

As for you second question, I do not think that you can have selective formatting applied based on merged content in Affinity Publisher so the best option would probably be going through afterwards the text boxes and apply e.g. paragraph formatting with horizontal character scaling etc. for ones with overflowing or wrapped content.

Ugh THANK YOU. I to decided to do a new test with the layout and realized that the issue was something with the linking of the original text boxes to the fields. I had *thought* I had "re-assigned" the text boxes to the fields, but apparently it just kept adding additional assignments, you can assign more than one field to a box? I ended up going through and re-deleting all the text I had in the text box and double clicking on the field again and it appears to have corrected itself.
What I'm thinking happened is I had already assigned a field to a text box, then when I later changed what field it is assigned to, I assumed it cleared out the previous assignment. Which I believe is false. So I went through and deleted and re-assigned and it seems to be working well now.

As for the formatting, that is annoying for sure but thank you for the tip on the scaling as I had been looking for it and wasn't able to find it. I used that to create some saved styles which will hopefully make adjustments easier in the future. (Window->Text->Character incase anyone else is looking in the future)