How to create an action to add data to the related list of a form

AppSheet AppSheet Q&A
,
1

I have an app for users to order products. I have an action on the product view that opens the order form. The order form have a related list of ordered items.

I would like the productid of the product that I click on to appear in the related list when the form opens.

2

I think you need three separate actions:

  1. Action to save a record in the related table.
  2. Action to open the form.
  3. A Group action where the two actions above can be itemized.

The group action will be the one that associated with your product view.

3

HI Red Vox,

In another app I used linktoform with the following target and it worked find:- LINKTOFORM(“Sales”,“ProductID”,[_THISROW])

I want to do something similar but insert the productID in a column of the related list of the form. Is there a way to refer to columns in related list in the linktoform function

You can see the app at the following url to get a better idea of what I am asking
https://www.appsheet.com/start/364221c8-090b-467f-adad-198b22912dac?fbclid=IwAR0C6fsf4fk4Sg-vrOjmTnXHsYhSCSPO6LMhISDYXuWaoDlV3UtDUBIEW_s#appName=EmmelinnesShopfront-1001778236&group=%5B%5D&sort=%5B%7B%22Column%22%3A%22Product%22%2C%22Order%22%3A%22Ascending%22%7D%5D&table=Products&view=Products+2

4

Hello @Emmeline ,

Check out this playlist https://youtube.com/playlist?list=PLo4qc7daF3rczyFE7kviX_U_9lH4Z-pY9

You might get some good ideas on what to do next.

1 Like