HI team,
I have a requirement for my quiz application. I Don't have any idea about how to implement.I need some suggestions from u guys.
My requirements are,
how to implement this......
Discussion posts and replies are publicly visible
balamanchari murugadas said:totally 2 data type one is for main where I am uploading my excel another one is for store the excel data fields
What do you mean by this?
It's not suggested to use 'excel to database' smart service because the file you uploaded is not yet saved in appian, you need to do a submit to access the uploaded file.
for wat you are using the two data types?
Basically 1 Record Type: Quiz with 3 columns (id, name, total questions, excelDocumentId)
Then you could have another Record Type where you would store the values contained in the Excel file.
Quiz_Detail (id, quizId, excelColumn1, excelColumn2 etc.)
I want to know how the excelDocumentId mapped with Quiz_Detail fields excel column1 and column2
Use the readexcelsheetpaging function in the Excel Tools plugin: community.appian.com/.../excel-tools