Using forms to update a record
I've perused the Smartsheet community posts for the answer to this question and get varying results.
Objective: Use a Smartsheet Form to update a row (a record) of data.
Background: We are currently using an Excel file with a VBScript form to update records of data. The VBScript form allows us to select the record to update, reads the row, presents selected data to the user and allows for data manipulation by the user. Each record has a unique identifier (number). The process works just fine - however, looking to elevate the workflow to a centralized platform versus managing at the end-user machine.
There have been all sorts of workflows presented to the Smartsheet community - however, I couldn't find this most basic request.
Note: The original record of data would be imported and the form would allow for data manipulation, i.e., drop-down selection boxes.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!