VICH Posted August 17, 2005 Posted August 17, 2005 i have a script that copies information from one field to another but the field copied to may already have information in it and if it does the paste is right next to the current info with no spacing...how can i get spacing there and maybe even a date on each paste
Slobey Posted August 17, 2005 Posted August 17, 2005 Use set field instead of paste and calculate it. if(isempty(field);info;field & " " & info)
VICH Posted August 17, 2005 Author Posted August 17, 2005 i can't use set fields because my fields that i would be setting are on different tables so it doesn't work...or atleast thats what they told be when i asked about how to transfer data from table to table
Slobey Posted August 17, 2005 Posted August 17, 2005 Create a global field and set that first, then set the field with the global.
VICH Posted August 17, 2005 Author Posted August 17, 2005 excuse me for this one but do global fields carry over tables
-Queue- Posted August 17, 2005 Posted August 17, 2005 You can trim the calc a little, too. If( not IsEmpty(field); field & " " ) & info
VICH Posted August 18, 2005 Author Posted August 18, 2005 are you guys telling me to set this up as a script or a calc field...sorry its early
-Queue- Posted August 18, 2005 Posted August 18, 2005 It would be a calculation in a script step. Once your global field is set and you are on the desired layout and record, Set Field [someField; If( not IsEmpty(someField); someField & " " ) & globalField] If you want it to put the global's value on a new line, use ¶ in place of " ". Does that help clarify?
Recommended Posts
This topic is 7039 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