July 29, 200817 yr I have 5 fields ( f1 - f5) with 10 repetitions (r1 - r10) each that looks like a table. I am trying to move (cut) the info in r3 ( or whichever rep I choose) of all of the fields to a single text field with a couple of spaces between each field's info. I made a script that works for r1 but can't figure how to get the info from a certain repetition across the range of all the fields. This can't be too hard, right? Thanks
July 29, 200817 yr Try: f1[n] & " " & f2[n] & " " ... & f5[n] where n is the chosen repetition. This can be done in a calculation field without a script. What is this arrangement good for?
July 29, 200817 yr Author I am using it for a maintenance list so the completed stuff has to be removed. File clone is attached. I want the info from 6 fields to get cut and pasted to the "done" field. if you put info and the cursor in the first repetition and run script 8 that is what I want it to do
July 29, 200817 yr Something went wrong with your attachment. Going by your description alone, it doesn't seem to be a good method. If you have multiple tasks, they should be in a related table, not in repeating fields.
Create an account or sign in to comment