Can a form update a specific row, rather than just adding rows to the bottom of a smartsheet?
I have a form and I'd like the form to recognise an already existing row on its linked smartsheet where the submitted form contents update a given row. I think it might be the case that forms just add rows to the bottom of a smartsheet (and then they manually need to be edited in such case).
Can anyone shed any light whether this can be done, or something similar?
In our case, our smartsheet is profiling public parks with tennis courts and their condition. The parks and the tennis court condition are all pre-entered on the smartsheet and need to be updated based on officers visiting the parks and assessing the court conditions. After their visit, we want them to simply complete a smartsheet form that when entering the given park name on the form (the first column text name), this will identify the correct row on smartsheet and update it based on their form entries.
It feels like a wasted feature if forms can only add rows to the bottom of the page, but equally I can't see any row association or tagging features in forms.