AnsweredAssumed Answered

Copy content of portal without line items

Question asked by hanstrager on Oct 17, 2015
Latest reply on Oct 20, 2015 by hanstrager

I have a small homemade database that gathers different information about specific garments.

I've made a new table called factory pricing which is joined with my main table called 'Technical sheet'

On my technical sheet layout I have a portal where I can add pricing from different factories (factory pricing table).

But when i copy my 'Technical sheet record' nothing is carried over into the duplicated portal.

I've tried to modify an earlier script I've been using to great success. Though In those previous instances had line Items tables. Though i don't see why I should use lines in this particular scenario.

What do i do wrong?



Freeze Window
Set Variable
[ $RecordNumber; Value:Get ( RecordNumber ) ]

#The 'set variable' for go to dublicated record

Commit Records/Requests

Set Variable [ $NewRecordNumber; Value:Get(RecordNumber) ]

Set Variable [ $TECHSHEETID; Value:TECHNICAL SHEET 2::xTechnical sheet_ID ]

Go to Record/Request/Page [ $RecordNumber ] [ No dialog ]

If [ not IsEmpty(Factory pricing::XfactorypriceID) ]
Go to Related Record [ From table: “Factory pricing”; Using layout: “Factory pricing” (Factory pricing) ] [ Show only related records ]

Go to Record/Request/Page [ First ]


Duplicate Record/Request

Set Field [ Factory pricing::XfactorypriceFK; $TECHSHEETID ]

Omit Record

Go to Record/Request/Page [ First ]

Omit Record

Exit Loop If [ Get ( FoundCount )=0 ] End Loop

Go to Layout [ original layout ]
Go to Record/Request/Page [ $NewRecordNumber ] [ No dialog ]

End If



Screen Shot 2015-10-17 at 14.42.06.png