When my users submit a form, I use a custom action to add additional details through “Set Column Values.” It works perfectly during testing, but after a few minutes, the data from the custom action disappears.
Interestingly, I have nearly identical actions working fine elsewhere in my app - it’s just this one that’s causing problems.
What kind of values are you setting? I usually don’t recommend using On Submit for something like that. You are usually better off adding the appropriate Value components to the form.
It’s better to set values when the row is added instead of of after it’s added.
If you are using the submit form, the row have yet to be created. I will be created upon submission clicked. But I think this conflicts with the immediate set column values as it happens simultaneously, the value may not be captured into the newly created row when the action completes
Hi Jeff, thanks for your response. I use set column values to set values like the step, project admin, date/time, and project type—things I don’t think can be set directly from the form. What would you recommend as an alternative?
Hi Trustin, I use the set column action upon form submission, so my expectation was that the row would be added with the form details first, and then the set column values would be applied afterward. If you’re correct, I now understand why it’s not working for me. Thanks for the clarification!
A lot of that stuff can be set from the form. Click the button to add a component to the form and you will see a lot more value components beyond the standard components you are used to. Take date for example, there is a Date special value component.
You can add components that pass values from the user profile, some special values, and any value from the parent row of the screen where the form was opened.
You can also use components to set a default value to them, and if you don’t want them to be edited, hide them with a condition that will never be true. Those values would be passed to the destination row even though the component is hidden.