Create an Asset Mangment Website hosted on Google Sites
$10-30 AUD
Paid on delivery
This site is required for the management of 1000 PDA devices. Website needs to run reports to show where the device currently is located and the status of the devices.
Users can only change device that are the same as the state and carrier
Main Table.
Table has the following fields.
[ID No.] Unique Number
[Device ID] Text ( Can be editor on by administrators )
[IMEI No.] Number ( Can only be edited by adminstrators )
[Serial No.] Number ( Can only be edited by administrators )
[Carrier] Text ( This can only be editied by administrators )
[Location] Text ( Dropdown box with the following values NSW,VIC,QLD,NT,SA,WA,TAS,NORWEST,MOTOROLA,IN-TRANSIT )
[Status] Text ( Dropdown box with the following values FAULTY, IN-FIELD,LOST / STOLEN )
[Fault Description] ( This comment box should only appear if the status field has been changed to FAULTY and once it has been changed to faulty can not be changed back until an administrator changes the status after it comes back from being repaired. )
[LastModified] this field will update after a user modifies each record.
UserTable
[ID] Unique ID Number
[username] Text (username)
[password] Password (Password FIeld)
[Carrier] Dropdown List populated from settings page
[State] Dropdown populated from settings page
will add a $20 bonus if delivered before monday so in total $50 is my max budget
Project ID: #6006953