The need for Forms to update an existing row and not send a request

01/22/22
Answered - Pending Review

I see the constant request to have Forms update an existing row and yet it hasn't come to fruition yet? I'm facing the same issue with the need to have users, in this case mechanics, update a Form to reflect anything they may have worked on a regarding parts to a manufacturing/production line and have it done as close to Real-Time as possible. Naturally a Request Form or anything of the sort is a no-go.

Pulling the columns from an extensive working sheet into a report was what I intended and did, but I was advised that by the department manager in the engineering/mechanics area that if we were to consider the effort of having mechanics enter data on smartsheet rather than on paper forms, it would need to be in a Form format. I actually agree after having put together a very intuitive Form that would help capture the new Columns I added to the existing Production/Planning Schedule worksheet.

Well I did that so that it would be easy to then just pull up these Forms on their smartphones but after running a test, I noticed that the updates do not update the existing row but simply add a new row towards the top or bottom of the worksheet.

I can't imagine how this isn't feature when there are so many requests for it and it makes so much sense for being efficient. Would seem natural to want to work in this fashion for many I imagine.

Is there any update to this and if not, are there any videos for helping with a workaround.

Thanks

Answers

  • Hi @VinceA

    The way to update a row through a form is to use Update Requests (either manually sent per-row or through an automation). See: Automatically Request Updates on Tasks and Manually Send an Update Request.

    In regards to your specific scenario where the entries are happening via Smartphone, I would actually suggest that having the data set up in a Sheet for them to add in to would be the best way to proceed. (You could have filters set on the sheet to quickly filter by row-type if it's a large sheet).

    You can adjust the view on your phone so that each row looks like a form, in the Mobile View:

    Then you can have the rows show as "collapsed" so it just has the Primary Column detail showing, until your users find the row they're looking to update:

    Once they've found the row, if they click the dropdown arrow it will open up the details of that row in a form-like fashion for them to update:

    Here's more details on working within Mobile views:

    Smartsheet for iOS: View and Update Your Work from the Mobile App

    Smartsheet for Android: View and Update Your Work from the Mobile App


    If this wouldn't work for you, an alternative would be to have an Intake Sheet where you have a form set up to create new rows. Then you could use cross-sheet formulas to update a Master Sheet with the newest information, or use a Report to only pull the most recently submitted rows.

    I hope this helps!

    Genevieve

  • Thanks Genevieve for the reply.

    Update Requests won't work because they aren't requests being made of and to the mechanics. The Form needs to act as a simple reporting mechanism in real-time from a tablet or smartphone so that when a mechanic sees an issue and works on a fix, he logs the time spent on that fix for any one of the components that could break down on a production line. The many mechanical components are represented in numerous columns amongst other columns on the main worksheet for a host of scheduled product runs.

    The only solution here would be a simple Form that translates the data directly onto the existing row on the main worksheet and not as an added row.

    The other solution is using a Report to pull only the components representing the production line they are working on and access that report from a phone. This involves a few steps for mechanic to the retrieve a FORM format to work from, which isn't ideal due to possibility of accidentally editing other and different fields that need to be in their Report that help them recognize the current job running.

  • Thank you for the additional information @VinceA. It would be helpful if the Product team could hear your feedback as well to understand more about your use-case. Here is the form if you have a moment.

    Thanks,

    Genevieve

  • Thanks Genevieve .... I did provide that feedback yesterday and hope to see that the Coding/Tech Team make this a consideration.

    Thanks

    V_

Sign In or Register to comment.