I am building an app to keep track of submittals. I would like to create a form which allows for updating existing records of submittals as information changes. As the submittal is sent from location to location getting approval, I would like to keep track of the dates we sent/received them. Also, I would like to be able to update the status (using a drop box).
Basically, I need to create a form (nearly identical fields as the one used to input the information) which allows me to update existing records. Not sure how to do this.
I believe the mechanics involved would be:
1. Select the desired record based on a search using two criterion (using access this would be simple but it seems much more difficult with zoho)
2. Have the records information display in the field boxes
3. Be able to input/change information which would update the actual record
Also, from what I've learned in the few days I've been using zoho, I'll need a stateless form and an html page. I tried messing around with those two but I have no html experience, and I'm not sure how to link the fields from the stateless form to the actual records.