First Aid Tracker

First Aid Tracker

Good day, all, I hope you're doing well.

 

Would like your assistance with creating a Zoho Application on Zoho Creator.

 

We are creating a First Aid tracker which will ask the user to check 12 different first aid kits given three conditions.

  1. What is the first aid kit serviceability? Serviceable or unserviceable.
  2. What is the tag number on the first aid?
  3. What is the expiry date for the first aid?
Example:
Fire 1 First Aid kit: serviceability, tag number and expiry date.
Annexe Room First Aid kit: serviceability, tag number and expiry date.
Etc. for 12 different First Aid kit.

I also have five different equipment that need to be checked however these don't have a tag number (only require serviceability and expiry date).

What I would like the application to do is to automatically pull the previous tag number and expiry date from the previous inspection. If the tag number or expiry date has changed since, the application must allow the user to input the new information.

Example:

1st inspection:

Fire 1 First Aid Kit: Serviceable

Fire 1 tag number: 54789

Fire 1 expiry date: 28/12/2023

 

2nd inspection:

Fire 1 First Aid Kit: Serviceable

Fire 1 tag number: 123456 (tag number changed and user inputted updated info)

Fire 1 expiry date: 28/12/2023 (auto pulls date from the previous inspection)

 

3rd inspection:

Fire 1 First Aid Kit: Serviceable

Fire 1 tag number: 123456 (auto pulls number from the previous inspection)

Fire 1 expiry date: 31/01/2024 (expiry date changed and user imputed updated info)

 

Any guidance would be much appreciated.