Group Action: Copy and LINKTOFORM()

[Sarah_Keown]

Hi,

I have two actions; one which is copying and editing the row and another which is going to another view in the app. I have grouped these two actions into one called ‘Copying Order’. This action is triggered when the user is clicking ‘Save’.

As it stands, the user completes the Order Form with an Order No e.g. 100-000, they click Save and this record is copied. The copy row appears in the same form but the Order No is an empty field- this is because the Order No is a key.

I thought that the second action in the group would work to auto fill the form with the same Order No but without the number proceeding the dash e.g. “-000”. I have read in the community about similar scenarios and wanted to know if there is a way of achieving what I want (copy the row created and the Order No split fills the new record field). Is this because I am using a key field or due to the save action instead of button actions?
I have included a snippet of the action I have to assign the Order No into the newly copied record field.

Help is always appreciated thanks

[LeventK · Accepted solution]

@Sarah_Keown
I believe there is no need for a grouped action here. You can set a LINKTOFORM action with prominency set to “no display” and assign this action to your main form’s Form Saved propery where you can set each parameter to be copied to the new form:

LINKTOFORM(
	"Create New Order",
	"Order No.", INDEX(SPLIT([Order No.],"-"),1)&"-",
	"ColumnA", [ColumnA],
	"ColumnB", [ColumnB],
	"ColumnC", [ColumnC]
)

[Sarah_Keown]

Thank you, this is good for copying the other columns but the assignment again is not happening with the Order No, is this because it is a key field?