LinkedIn
Twitter
Hello again; this is my third question regarding the same project, the moving form. Now making my first foray into Actions, and again am finding it all less intuitive than I had hoped for.
As I mentioned in my earlier posts, this project entails a Form view in which the form user may select a Customer Name - Date combination from a drop-down menu, and have information loaded from the source sheet into appropriate fields. So, referring to the screen snap below, if the User selects "23/04/15 Sat โ Julie McDougal", data from Row 5 appears in the corresponding fields in the form (see cell E5).
This is all working fine, but I'm having trouble with the form submission actions.
There are a few things that are supposed to happen when the form is submitted; I'll keep the scope of this post limited to the simple parts. The data the user submits needs to be written to the appropriate fields of the SAME row the initial values were drawn from, not added as a new row at the bottom, as you can see has happened twice in this particular screen snap.
This needs to happen without overwriting data in columns that are not represented on the form.
I thought "App:Edit this row" would be the answer, but this did not affect the way the app behaved at all.
Then I thought I would put that aside and try the next thing the form submission is supposed to do: change the value of the "Status" field to "completed." I tried changing "App:Edit this row" to "App:Set the values of some columns in this row"; see screen snap below. This had absolutely no effect, either; the new data continued to come in to a new last row AND the Status column remained blank.
So how does one actually do this?
Thank you for your help!
