Hello,

Could anyone help please, how I could automate data import from excel or csv (which is more reliable) to Creator?

I have a sales form with a subform of sales details ( and there is a main form behind the subform). Currently sales invoices are entered to Creator manually, and it is working fine.

 

I've been looking for tutorials but none of them really helped to solve the issue. All I know is that two sheets are needed in the excel: one for the form data, the other one is for the subform data, but this is not clear, how it has to be done properly.

I was trying to export data from Creator to excel first, and import it back. But when I export the data to excel, only one excel sheet is created. Obviously if I try to import it back to creator there is only one row in the subform, and data import to the main form of the subform is not executed.

I'm looking for a video which explains step by step how it is to be done. 

Thanks a lot!