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. [login to view URL] 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

Projekt-ID: 40274128