I’m having a form which also includes the sub-form.
The main form data will be common for few rows and the sub-form data will differ. By reading the excel data, the main form data has to be entered once and the sub-form data has to be added as many rows. When there is null/empty row in the excel, it has to save the previously entered with same id and has to create preceding rows with next id. Is that possible and how can we achieve that?
I’ve attached a snapshot for reference.
For example, if first three row has same username and address as different. The process is to be like with same registration id 1 and the details.
If null occurs, the next rows has to be registration id as 2.
Thanks in advance.