Action on Form Save: Data: set the values of some columns in this row.. Is this supposed to work?

[SmartsheetGuru]

Hi,
I’ve tried several times to have an action fire when saving a form to set the values of some columns in this row based on the values entered into the form. It seems to me that this type of action doesn’t work when saving a form and creating a new row in a table. Is this the intended action and I’m misunderstanding how this type of action works? Other actions like navigate to another view upon saving a form work just fine.

Using this same action on an existing row always works for me, but not when saving a form to create a new row.

This is a general question and not specific to any apps, I’ve seen this behavior multiple times and just figured it’s not doable. I use a different solution instead, but I want to understand why it doesn’t work.

[1minManager]

Navgate to the form and choose the Event Action you want

[SmartsheetGuru]

Yes, that’s what I do, but if I have an action that is “Data: set the values of some columns in his row”, it doesn’t do anything. It’s like the action is just ignored… I’ve had the situation where the action I choose upon form save is a “Grouped” action. Other actions in the group will work as intended, but the set some values of columns doesn’t seem to do anything.

[1minManager]

Ok. I think the issue maybe that it won’t let you just run an action on the row your saving. Try changing it over to an “Execute an action on a set of row” Action which then uses a rule to just run on the latest row and then calls the action you’ve already created. Something like:

MAX(Select(Tablename[KeyColumn],TRUE))

If it says it should return a number of rows then try

LIST(MAX(Select(Tablename[KeyColumn],TRUE)))

Simon@1minManager.com

[SmartsheetGuru]

Ahh ok. I already use an action that executes on a set of rows to save data to another table when saving a form, so I was really puzzled why I couldn’t execute an action on the row that I’m actually saving. I’ll try this out next time I need to change data in a new row when saving a form.

Thanks for the suggestion!