AnsweredAssumed Answered

Script to copy text from a field into a generic text box not assigned to a field?

Question asked by trialuser1111 on Oct 2, 2009
Latest reply on Oct 5, 2009 by trialuser1111

Title

Script to copy text from a field into a generic text box not assigned to a field?

Post

I need a little help with a script; I'm essentially trying to replicate the "paste values" function in Excel in FileMaker.  What I'd like to do is have a script that copies all the text from Field A for every found record in a set on Layout A, and pastes them into corresponding text boxes in Layout B that are not assigned to a field.  The text in Field A is a paragraph or so of descriptive text, and in Layout B, I'd like to let users customize that text before finalizing in a PDF, BUT I don't want to create another field for the text in Layout B because the customization would be specific to that user for that particular report and would never be needed again after PDF.

 

My thinking is that I need to assign a variable to each Field A in a found set (and I'm still very new to variables, so I'm not sure if that's feasible or my best option), and then have the script paste that set of variables in order.  So if I have 3 found records in Layout A, starting the script will turn Field A (record 1) into the variable $Text1, Field A (record 2) into $Text2, Field A (record 3) into $Text3, and then in Layout B, I could paste $Text1 into record 1, $Text2 into record 2, and $Text3 into record 3.

 

Also, I'm not sure if this matters, but I'd like to be able to specify where the text is located in the body so I can maintain my layout.

 

Thanks 

Outcomes