How to insert data into correct column/row instead of creating a new row with App Sheet?

[sduart003]

Hey all, 

I'm new to App Sheet and trying to make something work but I'm not having luck searching the community. What I want is for a user to open the app, fill out the form data, and have that data input to a specific row in my Google Sheet. 

When a user opens the Google App they see an option to enter the date, amount (decimal), a note (text), the category (enum), and select a button (enum) and click submit:

Right now, this app sheet "form" is linked to my Google Sheet and I would like it to populate the response data to this row:

However, once the user submits, it is creating a new row at the bottom of the table like this: 

How can I configure the app to insert the data properly starting on column E row 22, ideally keeping the correct format (ensuring it is selecting the enum value from the drop downs properly)?

Thank you!

Steve

[Mariano_Sanz_Gi]

Hi
Your approach is incorrect. The target spreadsheet for the data must have the fields in row 1, start in column A, and be as compact as possible, without formulas at the end. AppSheet will fill the rows downward from the last filled row. This compact table filled by AppSheet should be analyzed and utilized in a different sheet to avoid interfering with the data collection application.

[sduart003]

Ah I feared that might be the case. Thank you for the info Mariano.

[lynchk21]

In your google sheet, you can use =QUERY() to pull the data enter from Appsheet into another tab, and then do your calculations there. I would recommend having the total at the top of the sheet to avoid interfering with the query results as they expand