AnsweredAssumed Answered

How to copy values from find results into different layout

Question asked by Jigzat on Apr 10, 2010
Latest reply on Apr 11, 2010 by Jigzat

Title

How to copy values from find results into different layout

Post

Hello everyone, this is what I am trying to do:

 

I have a layout where I search for records with an empty date in certain field

then I use the results to copy one text field into a new record text field in a different layout

I do this for every empty date found record

 

So far I have been using the Copy [] function which uses the clipboard, and it works but it is not the right way to do it.

I tried with variables and Insert text [], set field [] but it doesn't work, the field in the recently created record is empy

 

I used the debugger and the variable actualy holds the data but set field [] doesn't set the field.

 

Can someone help me out with this?

 

This is the code:

 

 

Perform FInd [restore]
Go to Record/Request/Page [first]
Loop
Set Variable [$$TENENCIA_FA; Value:Tenencias::Tenencia]
Go to Layout ["Saldos" (Saldos)]
New Record/Request
Insert Current Date [Select; Saldos::Fecha Facturacion]
Insert Text [Select; Saldos::Detalle; "CUOTA ADMINISTRACION"]
Set Field [Saldos::Tenencia;$$TENENCIA_FA]
Go To Layout [original layout]
Go To Record/Request/Page [Next; Exit after last]
End Loop
Copy [Select]

 

 

Outcomes