Hi All-

I have a form ("Equipment Form") that contains multiple pieces of equipment of multiple equipment types from multiple locations.  One field in this current form is a "Runtime Meter".  I would like to provide a user the ability to select a location and equipment type (lookups), fetch and display the applicable current "Runtime Meter" and allow for that field and a "Meter Reading Date" field to be updated with a new meter reading.

Essentially, the user will dynamically select, view current state and update multiple records.

What is the best approach for doing this?  Clone of current form?  Stateless form?  An "Update Form" and record that logs updates and pushes data to the "Runtime Meter" of the "Equipment Form".

With the proper approach selected, are there any specific scripts or settings that I need to be aware of to make it function properly? Any tips for handling validation of the entry? A.K.A. no more than 24 hours of runtime daily, must be > than current reading, etc.

I am new to Zoho Creator and scripting in general so I appreciate the help from this community.

Best,

Rob