If I copy information from one field in file A and paste it in another field in field B I get a number. Copy "Purple" paste 10064897. Any ideas what I can do to fix this?

Thanks

Hi,

Is this copy/paste scripted ?

Make sure the field A is on the layout, or you'd be copying the content of another field (probably a number in this case) instead.

SetField[ ] should be preferred to Copy/Paste anyway.

No, It is not in a script. It happens when you do it manually. I have some users that like to copy out of the database and paste into documents. So the field is on the layout that they are copying from.

Hi,

A number? It looks like a serial. I suspect a script is using your clipboard to capture an ID to paste and establish a relationship on the fly. If, after a User copies a field, ANY script is ran you need to check the script for the Copy/Paste[] script-step. Clues: Script for layout switch to form displaying a portal.

Set Field is certainly better to use within a script; however, using clipboard is fine as long as protections are in place to restore the clipboard contents after the script is finished to prevent surprising Users in this way. You can use products such as ClipSave or even script your own clipboard restoration.

Test: Copy text from a field, immediately paste back into same field. Do not click anything else which might activate a script. Does it paste correctly? I believe Ugo is referring to a script using your clipboard, not Users using a script to copy/paste. Things go on behind the scenes sometimes that Users aren't aware of.

That was the problem. I had a small script that used copy/paste, when I got rid of it the problem was gone. Thanks to both of you for your help.

Elizabeth