Hi all! I've searched and searched all day and can't seem to find exactly what I'm looking for - I've searched the wiki, the forum, the internet, etc. including google and youtube. I must be putting in the wrong wording so I'm coming to you all for help now.
I have an employee training detail grid based on a sql table. I have a few options in adding employee training records to this employee training detail grid. My primary keys are both the employee id and the course id fields. My options right now are:
1. I can type in individual training records into the employee training detail grid for each person. When I type in the person's employee ID, the row will auto populate with First Name, Last Name, Email, Manager Name and Manager Email from a lookup and fill in action that I put in 'OnBlur'. The information is coming from another grid called Employee Baseline Records (also a sql table which is my main grid in the web project that will house the total hours of eligible training that each person took).
2. I can do an import (I already created the import button) where I can import a file with many names and then click a button on the row that contains the lookup and fill in action so that the First Name, Last Name, Email, Manager Name and Manager Email will automatically populate for me.
The problem is when I import a lot of records. Right now I can't figure out how I can get the grid to auto populate the First Name, Last Name, Email, Manager Name and Manager Email for all the rows that I just imported. Today I imported a file with 500 records and I really don't want to have to click the action button on each row for 500 people. Any ideas on what I can do?
Please go easy on me and keep in mind that I am a beginner in alpha five and do not have much programming experience other than what I've learned while using alpha five (not much). I appreciate any help!! Thank you!!
I have an employee training detail grid based on a sql table. I have a few options in adding employee training records to this employee training detail grid. My primary keys are both the employee id and the course id fields. My options right now are:
1. I can type in individual training records into the employee training detail grid for each person. When I type in the person's employee ID, the row will auto populate with First Name, Last Name, Email, Manager Name and Manager Email from a lookup and fill in action that I put in 'OnBlur'. The information is coming from another grid called Employee Baseline Records (also a sql table which is my main grid in the web project that will house the total hours of eligible training that each person took).
2. I can do an import (I already created the import button) where I can import a file with many names and then click a button on the row that contains the lookup and fill in action so that the First Name, Last Name, Email, Manager Name and Manager Email will automatically populate for me.
The problem is when I import a lot of records. Right now I can't figure out how I can get the grid to auto populate the First Name, Last Name, Email, Manager Name and Manager Email for all the rows that I just imported. Today I imported a file with 500 records and I really don't want to have to click the action button on each row for 500 people. Any ideas on what I can do?
Please go easy on me and keep in mind that I am a beginner in alpha five and do not have much programming experience other than what I've learned while using alpha five (not much). I appreciate any help!! Thank you!!
Comment