Hi guys,
This is my first time using the Data Loading Wizard pages in Apex, so I am a bit lost when trying to customize its workflow
So I have a CHECKLIST_ITEM table which lists all checklist items of a checklist (identified by the ID_Checklist column):
| ID | ID_CHECKLIST | Checklist_Content |
|---|
| 1 | 121 | Clean my room |
| 2 | 121 | Brush my teeth |
I want to create a data loading wizard from a checklist page. So when I open the Data Loading Wizard, I already have the ID of the checklist (e.g. 121) and store it in an item (e.g. P1_ID_CHECKLIST).
Meanwhile, my spreadsheet data will not have the ID_CHECKLIST column, only the Checklist_Content column. It looks like this:
| Checklist_Content |
|---|
Eat healthy breakfast |
| Go to work |
So my question is, how to automatically insert the P1_ID_CHECKLIST value to the ID_CHECKLIST column for each row in the imported spreadsheet data?
Any help will be appreciated!
P.S. I am using Apex v5.1.