Tracking form responses
We have a situation where we need to collect information from our customers to complete certain tasks for their projects. We would like to enter data in a column or two (i.e. sales order number, product sold), and then have the form send out to the customer to gather the information we need to configure it prior to shipping (i.e. network configuration information so it will work on their network when they plug it in). We would like this to function similarly to how an update request works, allowing people to add their data to an existing row in a sheet, however we need the logic capabilities available in forms to dynamically ask the right questions to gather the information we need.
Does anyone have any suggestions in how to accomplish this?