You're quite welcome, Rob.
>How can I update fields 1 & 3 for the entire list...
A script like the one that I gave you can do this. Edit the fill string as needed and try it.
>Normally we just click on "fill field" and select fields 1 & 3, but this is not an option for our users.
Macros can be very slow, as you have found. As a practical matter, it seems to me that your choice is either to teach your users how to use Fill Field from the menu, or to use a simple script like my example above. You will need two versions, one for each field, or you could use one subroutine with an input box to allow the user to type or paste in the fill string. I can give you a example of using an input box, if you like.
The alternative would be to use result sets, a fast but more demanding LotusScript technique, and one that in my opinion would be overkill for this task. If you are new to scripting, you may find result sets to be heavy going. There are examples of them at Xpertss.com, but unfortunately the site is unavailable at the moment while they switch to another host.
Doug Mackie
http://www.xpertss.com
"SmartSuite forums and downloads"
Return to top
. . . . . . . . . . . . RE: Script Not Needed? (Doug Mackie 28.Aug.09) 
Print this page
