Form in Appsheet - create a new line by field in a Google sheet

[raphaellng]

Hi Everyone, 

I have a project in mind for my work and I have a technical question, before going further in it.

Basically, I want a user to input some KPI scores in each field of a form, and then datas go to a Google Sheet.

When looking in generic tools (Google Form, Smartsheet Form, ect) each field of the form will create a column, and one answer corresponds to one line in Google sheet, with as many columns as fields in the form. 

So then I need to transpose each columns so I get one column with the KPI Id, and one column with scores, so I can create some dashboard.. It is really time consuming ! 

KPI 1 KPI 2 KPI 3 ...

80%  90%   100%

transpose 

KPI 1 80%

KPI 2 90%

KPI 3 100% 

Do you know if it would be possible in Appsheet to create a new line in GoogleS for each field of a form when it is submitted, to create directly this kind of table in GoogleS: 

KPI 1 score

KPI 2 score 

KPI 3 score 

Thank you for your help 

Raphaël