Create New Record in Related Table From Current Portal Row.

[Baylah]

This has probably been asked and answered so I apologizze if this is redundant.

How can I script to copy the information from a current portal row in to a related database? Essentially I want to crate a new recoird in the related database from the information in the current portal row I am working on.

It's the portal that is throwing me off...I can do this easily when the portal equation is not in the mix.

Thank you,

Steve

[Fitch]

If you click a button in a portal row, the script will act on information from that row, unless you have a script step that takes you out of the portal. Set the related field values into variables before you leave the portal row (by e.g. committing the record or changing layouts).

[Baylah]

Are you saying to use the "Set Variable" scipt step insted of "Set field" ? If so I have never used that script step to move information between two locations. How do you specify the target and calculated result for the target? Or am I just misunderstanding you altogether?

My Button is inside the portal row. I have tried several different things to makes it work using Set Field and commit record. I'm striking out.

thanks,m

Steve

[Baylah]

Does anyone else have any suggestions?

I'm Stumped.

Sorry,

Steve

[Baylah]

:blush2:

I figured it out using set variable.

It looks like this:

Set Variable [$$movepfk; value:GetAsText(ProductPortal::pfk)]

Go to Layout ["products" (ProductPortal)]

New Record Request

Insert Calculated result [select;PRD Product Portal::Style:$$movepfk]

Steve :blush2:

[mr_vodka]

The variable does not have to be a global variable. You cant just use a local variable since it is being used in the same script.

Set Variable [$movepfk; value:ProductPortal::pfk]

Go to Layout ["products" (ProductPortal)]

New Record Request []

Set Field [PRD Product Portal::Style; $movepfk]

[Baylah]

Hi John,

Thanks for the tip...I had tried it with just one "$" but it did not work. I must have entered something else incorrectly and then just gone for the global.

I will double check my work and try it your way.

Steve