VICH Posted August 17, 2005 Share 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 Link to comment Share on other sites More sharing options...
Slobey Posted August 17, 2005 Share Posted August 17, 2005 Use set field instead of paste and calculate it. if(isempty(field);info;field & " " & info) Link to comment Share on other sites More sharing options...
VICH Posted August 17, 2005 Author Share 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 Link to comment Share on other sites More sharing options...
Slobey Posted August 17, 2005 Share Posted August 17, 2005 Create a global field and set that first, then set the field with the global. Link to comment Share on other sites More sharing options...
VICH Posted August 17, 2005 Author Share Posted August 17, 2005 excuse me for this one but do global fields carry over tables Link to comment Share on other sites More sharing options...
Slobey Posted August 17, 2005 Share Posted August 17, 2005 yes they do Link to comment Share on other sites More sharing options...
-Queue- Posted August 17, 2005 Share Posted August 17, 2005 You can trim the calc a little, too. If( not IsEmpty(field); field & " " ) & info Link to comment Share on other sites More sharing options...
VICH Posted August 18, 2005 Author Share Posted August 18, 2005 are you guys telling me to set this up as a script or a calc field...sorry its early Link to comment Share on other sites More sharing options...
-Queue- Posted August 18, 2005 Share 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? Link to comment Share on other sites More sharing options...
VICH Posted August 18, 2005 Author Share Posted August 18, 2005 yes thank you very much Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6680 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