This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Not sure if this is a bug, but I have a table for which I use the built-in “Copy this row and edit the copy” action, as I need to be able to duplicate a row multiple times but with the ability to edit each row (if necessary) before saving it.
However, as there is a single column in each row that I do not need to copy over, I hoped it would work by marking that column as “Reset on edit?” since this erases the content of the column when the row is edited, but apparently this reset is not triggered by the “Copy this row and edit the copy” action. In other words, when I select the action on a row, and I get into the form to edit the new row, the content of the column that was marked “Reset on edit?” is still there.
I was wondering if this was a bug or intentional and what I can do instead to make sure the column is reset on each copy?
I believe your observation is correct. I am unaware about if this is intended behavior.
However , as a workaround, you may wish to use the LINKTOFORM() type action instead.
However in this case , one needs to build the target form, one by one value from the record being copied. You can apply blank to the column that you wish to follow the reset on edit behavior after copying.
An example below. For “name 1” column , the value to be copied is blank. Whereas for “Color1” column, the value from existing record is copied.
LinkedIn
Twitter
