Semi-automated way to fill affinity docs

[marcvanderpeet12]

Dear all,

 

I drafted a simple form in Affinity. For example:

Obviously, my real document is a little more sophisticated but this is just for example purposes :). What I want to do know now is to create several of these files with different names and addresses. So I am looking for a way in which I can merge an Affinity file with an Excel doc. So let's say I have an Excel file with:

Name, Address

Henk, Applestreet1

Josh, Bananastreet1

 

Then I am looking for a way to define my name section as a name section and address section as an address section. And then I am looking for a macro-ish thing which allows me to place an Excel file and a template in one folder. After which I can create a "filled up" version of the template (based on the information in the Excel file. Is there anybody who can tell how I can achieve this in Affinity. 

[Callum]

Hi marcvanderpeet12,

Welcome to the forums

As far as I'm aware there is no way to do this in Affinity I'm afraid.

Thanks

C

[Alfred]

 

[carl123]

See if this workaround for a simple data merge helps (using Publisher)

https://forum.affinity.serif.com/index.php?/topic/75332-dynamic-text-in-publisher/&do=findComment&comment=393091

 

[v_kyr]

https://forum.affinity.serif.com/index.php?/topic/52778-programming-photo-or-designer/&do=findComment&comment=267410

Make with  Affinity an SVG template with coresponding placeholder entries (#name, #address et.) and then merge that one via some scripting or Excel related VBS etc. with your Excel csv output.