Import subform data into one form and push to another form

Import subform data into one form and push to another form

Hi.

We have a user portal where:
  1. the client receives spreadsheet template download after submitting details
  2. client enters subform data into the spreadsheet, then imports the spreadsheet back into the same form's report.
We need the imported record and subform data to be transferred to another form where the data will be calculated and stored in CRM. (calculation and CRM integration script already completed)

We do it the is way because there is no way to filter the subform columns download that we don't want the client to see in the download of the main form's subforms.

We have a fetch and input script that works on manual user input in the "on success" part of the workflow, but not on import.

  2. fet = Preferred_Partner_Sales_Form[ID == input.Preferred_Partner_Sales_Form_Link];
  3. x = Preferred_Partner_Sales_Form.Cruise_Lines();
  4. col = Collection();
  5. for each  rec in input.Cruise_Lines
  6. {
  7. x = Preferred_Supplier_Upload_Form.Cruise_Lines();
  8. x.Cruise_Line_upload=input.Cruise_Lines.Cruise_Line_upload;
  9. col.insert(x);
  10. }
  11. fet.Cruise_Lines.insert(col);
Please advise.

Thanks,

Jason