See attached Add extra field screen shot.
1. update text date & time to Date & Time of Inspection
2. Add in extra field "Tenant Notified On:" same data type as Date and Time of Inspection field. that is date and time.
3. Add two extra buttons "Notify Tenant (Email)" Notify Tenant (SMS)
4. 2nd button does nothing
5. 1st button when clicked should:
A. same as Add inspection button however it will update and set tenant notified on to the current date time.
B. also send an email to the tenant and cc the user.
If you are not familar with the database you can put in a simple SQL statement in the PHP and I will update the SQL. as I am familar with the DB structure and SQL i bad at PHP.
53 pekerja bebas membida secara purata $154 untuk pekerjaan ini
Hello, I am a PHP developer. Please let me help you to do this update and i am sure that you will be satisfied with my work. Thanks and best regards, Terry