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?
Thanks in advance
Solved! Go to Solution.
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.
LINKTOFORM(โTable1_Formโ, โName1โ, โโ , โColor1โ, [Color1])
A sample app link is below. It copies from one table record to another. But one can copy and edit the form within the same table as well.
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.
LINKTOFORM(โTable1_Formโ, โName1โ, โโ , โColor1โ, [Color1])
A sample app link is below. It copies from one table record to another. But one can copy and edit the form within the same table as well.
Thank you for the suggestion, Iโll look into that!
Though it would make sense if the โReset on editโ columns were indeed triggered by the action.
Reset on edit? is applied only for edits after the initial row creation. I suspect that when using the copy-and-edit action, the edit of the copy is treated as an initial row creation.
@Suvrutt_Gurjarโs suggestion is a good one.
That would indeed be a logical explanation! Thanks for the clarification
Is this and old post, but I had the same problem few days ago and @Steve logical explanation made me found a good solution.
If reset on edit is applied only for edits after the initial row creation we need the follow steps:
When you execute this action first will add a new row and then this row will be opened so, Reset on Edit most be triggered.
I hope this could be useful.
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |