Re-open Partially Completed Form


Hi all,

We have a sheet that collects information about our accounts. Our contracts team enters some of the data via a form when they hand it off to our accountants. However, they don't always have all the information at the same time, and some would prefer to enter it piecemeal rather than needing to dig it all back out at the very end of the process. Is there a way to fill out the form once, and then at a later date a) display the already-entered data and b) update the remaining fields to "update" the existing row (rather than create a duplicate row)? I explored some query string articles but I didn't see anything that exactly matched this. Would it be easier to set up an automation on my sheet to send an update request for partially-completed rows that our contracts staff could keep until they were ready to update?