Add a new row to another table AND open form to edit?

[Nicolas_Feldman]

HI everyone, I was wondering if it´s possible to use an action to “add a new to row to another table using values from this row”, and somehow opening a form to edit that “new row” in the child table, all in one action.

[Steve]

You’d need three actions:

1. Create the row.

2. Navigate to that new row.

3. A grouped action to perform (1) and (2).

[timbanks103]

I’ve been struggling to find a way to do this for a couple of days and would also really appreciate a detailed answer. It seems like a scenario that will crop up frequently.

[jovish_jose]

Kindly provide with an expressions example so as to perform the 3 steps mentioned above

[Koichi_Tsuji · Accepted solution]

Action to copy some data from table A to table B and edit the new row in table B Questions

If i understand your requirement correctly, this could be a workaround for you. First, you create the action to add new row using this row value to another table. This is simple and basic, I assume you have this action in place. Then create another action as Aleksi said, jump to another view within app. For the deep expression for this action, you place function something like LINKTOROW(maxrow(“yourtargettablename”,"_RowNumber"), “formviewnameofthetargettable”) Then create another action t…

In principal same trick will solve.

[BigBadWol]

Action to copy some data from table A to table B and edit the new row in table B

you

In my case “LINKTOROW(maxrow(“yourtargettablename”,”_RowNumber"), “formviewnameofthetargettable”)" is openning a white screen

[Steve]

Please post a screenshot of Expression Assistant showing the complete expression.

[BigBadWol]

[BigBadWol]

[Steve]

The expression looks good.

Please post a screenshot of the configuration for the formvieworders view.

[khuslid]

You can also just create 1 action:
APP Go to another view in this app.
For a record of: “The original table”
LINKTOFORM(“Target form”,
“Original row1”, “Target row1”,
“Original row2”, “Target row2”,
“Original row3”, “Target row3”)

But this way you end up in i form with what ever new data you’d like, and would have to save it before changes take place.

[timbanks103]

Hey Kristofer, Yes! That’s the way to do it, many thanks.

Note to developers: maybe this link should be included as the “App link” in the Behaviour section of the
form description to give a hint. The current suggestion seems not as helpful.

Regards, Tim.

[JPAlpano]

Found this thread as I have the same requirement.
I agree that this would be easier to be an available action in the behavior page.
“Open a form to add a new row to another table”

Submited this as a feature request

ACTION: **Open a form to add a new row to another table**

ACTION: Open a form to add a new row to another table

Currently, the only actions available that are related to this are:

• Open a form to add new row to this table
• Add a new row to another table using values from this row

Limitations of the available actions :

• Open a form to add new row to this table* can only add to the current table
• Add a new row to another table using values from this row will not work if all the required columns of the other table is not assigned

Currently available solution:
Use Open another view within this app action and utilize the LINKTOROW() deep link expression. See sample below:

khuslid:

APP: Go to another view in this app

For a record of: “The original table”
LINKTOFORM(“Target form”,
“Original row1”, “Target row1”,
“Original row2”, “Target row2”,
“Original row3”, “Target row3”)

USE CASE:
Although this is possible using the given solution above, adding this as a readily available action will make it more intuitive for developers.

An example situation is that if the current table doesn’t have all the needed columns to supply to all the required columns of the other table.
By allowing to open a form first (instead of adding to row of the other table directly) will allow the app user to supply required information of the other table.