Excel exporter generic kolom data type

Suppose I want to export all questions with the corresponding anwser from this model to excel: Sample of the desired output in excel : Every answer should be exported with its correct data type : text as text, date as date.... Is this possible with the Excel Exporter module from the appstore? How should I configure this? When not possible, what is the best solution?
2 answers

Only possible if you use a microflow that processes it to a generic type. Otherwise 3 sheets within one microflow that export the 3 different types is what I would advice.


I agree with Mitchel. If you can add an attribute to the Parent entity called answer (of type string) , and set the Answer attribute either during the export or after a user is done filling out the questionnaire. Then you can make a template in the excel exporter module to export your desired result.