MichelVH Posted July 29, 2008 Posted July 29, 2008 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
comment Posted July 29, 2008 Posted July 29, 2008 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?
MichelVH Posted July 29, 2008 Author Posted July 29, 2008 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
comment Posted July 29, 2008 Posted July 29, 2008 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.
Recommended Posts
This topic is 5962 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now