Copy the row and give a link to view the original row

[Gunasuriya_Ravi]

I am having action button ,i need to copy the row and edit and save ,but i need to show the original row to the user for references
Suggest any idea ?
i tried add a new row in another table and pull the value

[LeventK]

When you choose to copy the row and edit, won’t be the users seeing the original data anyway??

[Gunasuriya_Ravi]

they will click the button Copy and edit action button ,user need to see the original data for the later references

[Gunasuriya_Ravi]

they will click the button Copy and edit action button ,user need to see the original data for the later references

[LeventK]

I believe I have understood nothing from your statement or what you’re trying to achieve.

[Steve]

Gunasuriya_Ravi:

for the later references

Later when? While editing the copy? Or after the copy has been edited and saved?

[Gunasuriya_Ravi]

After the copy is saved.

[Steve]

Instead of using an action of type Data: copy this row and edit the copy, use Data: add new row to another table or *App: go to another view in this app (with a target that uses LINKTOFORM()). You’ll need a column in the table that gets the new row to contain the Ref to the original row, then pass that reference as part of adding the new row. For instance, you might add a column named Original, then use App: go to another view in this app with a target like LINKTOFORM("form-view", "Original", [_THISROW], ...).

[Gunasuriya_Ravi]

Steve,its working perfectly,i am seeing the parent record in the newly copied row
Its possible to show the child record in the parent record? ?

[Steve]

Once you’ve established a child-parent relationship, AppSheet automatically adds a a virtual column to the parent that identifies all of its children. You can display that column if you’d like.

[Gunasuriya_Ravi]

Steve ,I have done the steps you told above,its working fine,
I need to change the status of the parent record as archive ,when i change the status in child record has approved
suggest me any idea.

[Steve]

You’ll need to perform an action from the child (Data: execute an action on a set of rows) when the child status is changed. That action should then tell the parent row to perform an action (Data: set the values of some columns in this row) to update itself with the new child status.

[Gunasuriya_Ravi]

To Execute the ( Data: execute an action on a set of rows ),the column should be list,but parent record is Ref ,how can update the parent record???

[Steve · Accepted solution]

Wrap the parent reference column with LIST():

LIST([parent])

See also:

help.appsheet.com

LIST()

New list

[Gunasuriya_Ravi]

Tqsm steve ,its working perfectly