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?
   

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:

1^st inspection:

Fire 1 First Aid Kit: Serviceable

Fire 1 tag number: 54789

Fire 1 expiry date: 28/12/2023

2^nd 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)

3^rd 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.