Ive got my form working ok however once the form is filled in and the user presses the button to write that data to the spreadsheet. Id like to make it so that they are able to edit the data without having to type in the spreadsheet. (ive found that the users random spellings wreak havoc with my formulas!).
Ideally id have it so that the user could select a line from the spreadsheet and hit an "edit record" button that would then open that line of data in the form that created it.
If the edit button could open a form similar to the form found in the Data/Form menu but with drop down menus for them to select corrections from rather than have them type them themselves.
Are either of these options even possible?