I am trying to export data from excel which is in form of questionnaire to new file in Filemaker. I made similar layout in Filemaker with all questions. I wrote script
Import records(source: "export file")
Go to record/ request page[first]
. This script is importing data to the new filemaker file but its not in sequence. My excel sheet has 10 questions with their question no. defined. But in layout i wrote every questions. While importing, i am getting all data in only one row. that is 10 data from excel in 10 records in filemaker but in same single row. whereas I want to import data according to the questions no.
My question might seems confusing so I have attached files for the reference.