Vendor Purchase Order Management App Glideapp

Vendor Updates App via Glideaapps
I would like to create a Glideapps where a vendor can login and see a list of purchase orders with lines using Glideapps

I want to create an app with a login that only a user with admin rights can create usernames and passwords to enable them to get logged in to this app. It should have the ability for the vendor to update their account information once they are logged in.

When the vendor is logged into the app they should see a list of outstanding purchase orders that match the vendor number in the purchase order table.

These are listed with all the information required in the Google Sheet linked.

https://docs.google.com/spreadsheets/d/19e4xWHRFZA4XhacFQO9S22dbf5nnpHk3EWqUyjyfxsI/edit?gid=0#gid=0
PDF Copy attached for reference

Tables

Users table (Only Admins can change)
Name
Vendor name
Vendor number
Vendor email
Vendor phone
User type
Admin
Vendor
Password

Purchase Order table ( linked to google sheet that is updated hourly)

Link

Drop down status table (Only Admins can change)
Shipped
Discontinued
Out of stock
No Purchase order
Cancelled



The vendor should see all the columns on the Purchase Order table, plus 4 additional columns

The 3 additional columns are as follows;
1st column called Status
Drop down linked to Drop down status table
Shipped
Discontinued
Out of stock
No Purchase order
Cancelled

2nd column called Date Due to Ship
Date (Not mandatory but can only be date)

3rd column called Notes
Notes up to 100 characters

4th column Called Date and time
This will date and time stamp when the change is saved to the google sheet from the App


When sheet has been updated by the vendor, we need a button to save. This button will automatically email a copy CSV and update a google sheet with the new information.

We need the ability for the vendor to edit the sheet again. Maybe an edit button for the final 4 columns. If these are updated then they must be saved as a new line in the google sheet. Sending a CSV with edited line is required also

The app should reflect our branding colour and logo which will be provided

When the app is completed is will become sole property of our company