Dual Purpose Form/Spreadsheet
In need of some assistance and ideas.
Current State: I have a form that is populating the responses submitted by a client into a single worksheet. However, some of the required information is not able to be submitted at the time of entry. So, we give the client access and they update the fields when they receive the information.
Ideal Future State: I am wondering if there is a way at all to build a secondary form with the three fields we need, and when submitted it then id's and populates the correct cell based on a unique ID, like "Store Name"
Or similar solution
Help Article Resources
Check out the Formula Handbook template!