I'm attempting to create a custom fillable order form, using a data merge. I have successfully turned cells in the data mege template into text fields using the "Buttons and Forms" menu. However, after creating my merged document, and exporting the result to PDF, whenever I enter information into one of the form fields, it populates all subsequent fields.
Each data merge entry has a few fields, which each have unique names. However, once I create my merged document, each record has fields with the same names as those in the previous record. This is a problem for me, because I am trying to set up a system where I generate a few dozen of these documents a week, so manually renaming 100 or so fields on each document would be prohibitively time consuming.
I've found the following thread, which appears to be about the same issue. However, I have not been able to get either script to work.
For anyone following this, it looks like the reason why the script was not effecting the Text Fields, was becasue they are embedded in tables. Currently trying to figure out how to work around this. If anyone has any insight, it would make my day!