App sheet need data from a form view to populate a specific row in the database and execute a macro

[SJDylan]

I am working on building an active inventory management solution for the company I work for. I had built our existing sheets spreadsheet to automatically add a new row with data from row 3, and sort all rows below row 3 when a macro button is pressed. I would like to integrate this. Any ideas on what I can use?