Action - Data: add a new row to another table using values from this row AND call up a form

[Joe_Seiler]

Hello,

Is there a way to use the action:

"Data: add a new row to another table using values from this row"

To bring in select rows copied from the source table, while also calling a form?

Basically, I need to make a Job Notes table that will bring in specific info from a Jobs table, but also call up a form for the actual job note.

Perhaps I can achieve this with a two step action?

[TeeSee1]

You can try to create an action of App: go to another view of this app with an expression like

LINKTOROW(
 MAXROW("Job Notes","_ROWNUMBER"),
 "Job Notes_Form"
)

and fire it after the action you already have using a composite action.

[Joe_Seiler · Accepted solution]

Thanks!

So I ended up using a combination of a few things.

"Data: add a new row to another table using values from this row"

Adding the columns I needed

AND

"App: go to another view within this app"

Using your expression as the target:

LINKTOROW(
 MAXROW("Job Notes","_ROWNUMBER"),
 "Job Notes_Form"
)

Then finally 

Using a third action

"Grouped: execute a sequence of actions"

with both of the above actions listed.

Works perfect, thanks for your assistance!