August 17, 200520 yr 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
August 17, 200520 yr Use set field instead of paste and calculate it. if(isempty(field);info;field & " " & info)
August 17, 200520 yr Author 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
August 17, 200520 yr You can trim the calc a little, too. If( not IsEmpty(field); field & " " ) & info
August 18, 200520 yr Author are you guys telling me to set this up as a script or a calc field...sorry its early
August 18, 200520 yr 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?
Create an account or sign in to comment