Variable Data Question: Pulling Data from one text box and duplicating it in another text box
So here is the scenario: I am creating a series of flyer for the company I work for. The initial request was make all the flyers have the ability to pull data from a form that feeds to a CSV and output multiple flyers with with different content on each. I completed this easily using the data merge tool.
Then I hit an issue... the people doing the flyer generation with the data merge, don't know how to use data merge and because we only get two or three requests a month, and they don't feel it is necessary to use data merge to create the flyers. So they have requested that I generate a version of the flyer in InDesign that is easy for them to place the necessary data in it manually from the CSV that the form feeds to. I generated an ingenious flyer that uses a call-out system, where I have highlighted each section using a non-print layer, and provide instruction as what column they can find it on the CSV file. This way they can input the info, export the print ready PDF and the non-print instruction/call-out layer doesn't populate through to the final document.
Now I want to improve on this flyer, since even though I have locked the non-print layer, and I have provided thorough instruction, I envision an issue that the users might touch other parts of the design that they shouldn't and screw up the layout. I also want to make it easier for the user to decipher the data and enter it into the document in a linear fashion (instead of column H, then A, then C it would be Column A, then B, then C, etc.). I also have a few of the pieces of the data repeat throughout the flyer, so hopefully this would allow me to map the data from one point to multiple points.
Basically, I want to create a "form" that sits next to the flyer. This form will be on a non-print layer (the flyer itself will be locked down from adjusting the layout). As the user inputs data into this "form" the corresponding data in the flyer itself changes. Is this possible? The data needs to be able to change in it's formatting as well.
One solution I had was to create a PDF with one page being a "form" and the second being the flyer, and to have duplicate fields so when you enter data in one, it changes in the other. The problem I hit was that I couldn't figure out a way to have the formatting change in one field and not the other, and the data doesn't feed well when it is in a string of text.
Anyways, if anyone know if this is possible, please let me know. If not, I will just make my coworkers move forward with this modified version. Thanks!
Again, I know this is a much simpler task if done with data merge, I am just trying to create a simple solution for those who are not as savvy in InDesign. ![]()