Hello All,
My client is in need of the following workflow:
1. A form is submitted outlining a new product idea
2. An email is sent to a preset list of emails saying something like, "A new idea was submitted you have x amount of time to respond to the idea with your thoughts, respond using this form (link to a response form).
3. The response forms simply edit the same table as the original request form - basically there is a column in the request table for each binary yes/no response from every notified party.
4. At a specified time after the original request, all parties who have not submitted a response form get notified again.
5. When all the responses are submitted an admin gets an email.
My worry is mainly 2 - sending a linked form to a set group of people, 3 - the response forms editing the same table, and 4 - keeping track of who has or hasn't submitted the forms. Is Zoho under equipped to do this type of application? It seems to me it is more for a less rigorous system. Would you recommend trying this in Zoho Creator, and if so, how would I go about some of these steps - I'm a full stack web developer and understand code, I'm just new to Zoho and need to be pointed in the right direction. If not, it seems that some type of php, mysql system is better - let me know your thoughts.