How do I ... copy row from one appsheet to another app

[Belinda]

I’ve looked at a few different options for doing this, and wondered if anyone had any other ideas (simplicity is appreciated!).

I would like to create an action. When the button is pressed, I’d like for the record I’m looking at (e.g., a row in a table in “app 1”), to be copied to a row in a table in “app 2”.

Is there a way to do this other than Workflow/API ?

Thank you much!

[Mike_A]

@Belinda - I have not done a lot in this area, but from what I can tell, you either have to leverage a webhook/workflow (see below), or if your backend is google sheets, could consider using Zapier. I am betting @Aleksi has some advice here…

help.appsheet.com

Example: Copying Newly Added Records

Using a Webhook and the API to copy newly added records.

[Aleksi]

@Belinda Do you need to copy it without saving? If manual saving is allowed, you could copy the record with a deep link LINKTOFORM(“FormViewName”,“Store”,[Store],“Type”,[Type],“MyAppName-123456”)

[Belinda]

yes, I can copy without saving, but it’s being saved to a different app, not within the same one.

[FaCe]

I can copy the record to clipboard too using LINKTOFORM ?
I can use LINKTOFORM using an Action and insert a little icon near a long_text field i want to copy in the clipboard ?

[Aleksi]

If you have your app details in the end of the deep link as in the sample above, it will copy the data into another app.

[Mike_A]

@Aleksi - I just have to ask… when you say “Do you need to copy it without saving?”, do you mean not saving the copied record in the second app (eg: App2)? The LINKTOFORM opens a form view of the form that resides in App2, but does not save that new record. The user has to press Save correct?

[Aleksi]

Correct. If you need this to be done automatically, then you would need to use for example Webhook/API calls as you proposed.