Copy Row and Edit the Copy But change the Qty to negative

[Ameteet]

Hi, 

Do you know how to add a new entry with the same set of values from the selected row but the [Qty] is editable and will be changed to a negative value?

Sample:

Existing Row: Apple 2 

Copy and edit New Row: Apple - 1

[Srikanth_S]

There are multiple ways to achieve it, depends on what you want to achieve.

Please read Appsheet help on 

LinkToRow()

LinkToForm()

Action to copy this row and edit.

Regards

[nostobunaev]

As I understand you correctly,

Go to "Behavior" and create a New Action.

Select the required table.

Then select "Do This" : Data: Add a new row to another table using values from this row.

Then choose the required table, where do you want to add another row(It could be the same table).

Then go to "Set these columns" and assign each column values.

For [Qty] just assign [Qty] *-1

For example: If I have 3 columns [A], [B], [C], in the table and I want to add a new row to this table I type in:

[A]=[A]

[B]=[B]

[C]=[C]

[Qty] = [Qty]*-1.

The last thing is to assign this Action to your Form.

P.S. There is an action called "App: copy this row and edit the copy", but by choosing this action, it will redirect you to another form, where you can edit as much as you want. after submitting the form where this action is assigned

P.P.S. Of course, there are probably more ways to do what you want, but I don't know.