APPSHEET knowledge required - Small AppSheet changes - in google sheet and in the app

i am trying a new app in appsheet, which we are trying to use, there are some minor changes which i am not able to do it. someone with appsheet knowledge can do it easily as the logic is very simple. It is basically a form with conditional logic, once the form is fully filled, the data should get hide. Also every data is assigned to a specific user, so it should show in bracket the number of pending entries. And red & green marketing for status And in google sheet need number of totals.