Please either Logon or create a New Account.
Automatically copy data from one field to another
Hi All,

First post for me and hopefully the first step on the path to feeling more positive about Powerschool!
Within the student table, I have two fields - Student_Web_ID and Student_Email. Student_Email is exactly the same as Student_Web_ID except with the addition of on the end.

I would have thought there would be a straightforward way of copying the data from one field to another, but I have so far been stumped. I thought I had solved it using ~([01]Fieldname) but this only produces the right results within Powerschool (as it interprets the call on the fly). I need to fill the field with the correct data, as I will be exporting this data for use within Follet Destiny.

Right now, I am thinking I will simply export the relevant data, amend it as necessary and then import it back in to the email field. However, I find myself relying more and more on external software to manipulate and present the data held in Powerschool. Does anyone know of a way to complete what I feel is a basic task, solely within Powerschool?

Many thanks for any suggestions,

Tags: PowerSchool  DDA
2 Responses to "Automatically copy data from one field to another"


Unfortunately there is no automatic way in PS to move values from one field to another. It probably could be done by writing some java scripts, but for a one time mass change it would be faster to export the fields (make sure you export the Student_Number), manipulate it and then reimport it back into the Student_Email field. 

Just to clarify and not b/c it matters, Student_Email is a custom field correct? 

Wayne Wiens
ESU 10

Yes, the email field is custom. Earlier today, I gave up and exported-modified-imported. The thing is, I am doing this kind of thing more and more - using third party software for data manipulation and presentation - because PS either doesn't have the function I want or it is such a headache to make it perform a task.

Some of the problem may be due to my expectations. When I build an interface for a database, I want to make sure it is as simple to use as possible, while offering as many options as I can imagine. Referencing an existing value and filling a field with that data is pretty rudimentary and I can imagine many other applications for such a function.

I guess what I mean is that I am spending too much time trying to make PS do what I think it SHOULD do, rather than simply working with the functions I KNOW how to use. In the end, as long as I can get the result I want, I should opt for the simpler method, whether it is outside of PS or not.
Would you like to comment? Join The PowerSchool Community for a free account, or login if you are already a member.