Table Action to Form View

[Rod]

Is it possible to use the action: “add a new row to this table using the values from this row”, then open that new row in a form view? Using an action sequence?

[Marc_Dillon]

Yes. The main issue is finding the key value of the new row to use in the second action’s LINKTOROW expression. You can do that a couple of ways, probably the easiest is with MAXROW(… , “_rownumber”). a Less computationally-intensive way is to add a column to the table you’re coming from that would temporarily hold a UNIQUEID() value, which you would use to populate the key value of the new record, AND easily link to it.

The only reason to do this instead of just LINKTOFORM() is to force the creation of a record, in case the user would just hit cancel from the form. Is this what you’re wanting?

[Rod]

Yes! I was wondering how to find the ID on a new row, are there examples? Thanks Marc!

[Rod]

Actually I found an app example, thanks again!