Hi Folks:
I'm trying to create a data load screen that will allow me to post animal numbers or upload a .csv file and when the data is saved to the database also included other fields on the page. Here is a screen pic to show what I mean:
On the right is a list of example animal numbers that would be pasted into the data box on the form. I need to be able to save each animal number AND the other fields tacked on as a record to form a single record int he database. So for example:
:Animal_Number, Collection_Date, Process_Date, Location, Species (etc.) would be inserted as one record.
Do I need to create some kind of custom collection (which I've never done)? There are often 200-300 records to insert so copying and pasting one animal number at a time and saving would be too time consuming.
I couldn't think of how to do this without a data loader. If I use a data loader though I'm not sure how to included other fields in the initial form. Thank you in advance for any ideas.
If you need me to explain anything please let me know...
Matthew
P.S. Not sure if it makes a difference but we are currently running Apex 19.2 We are hoping to upgrade to 22 but we are severely understaffed at the moment.