HiI have a Order table and in that I have a Portal to Order_Detail. When I type in the material ( this is a product we have in stock) in Order, I get the right material and the right width in to my portal via some script I made! All that are working fine...
Now I try in the same Order table wright the roll width ( this is another product we have in stock) and make that also jump in to the same Portal in a new row.
So far I made this script, tried to translate it from Swedish.
Set variable ($Rollwidth ; Order::Rollwidth)
Set variable ($HowManyRolls ; Order::HowManyRolls)
Error capturing ON
Go to Layout ("Product" (Product) )
Commit find (reset)
Set variable ($Product_ID ; Product::__ProductIDpk)
Go to Layout (Back to where I started)
Go to Object ( Objectname ; "Portal" )
Go to Potal row ( Highlight ; Last )
Set field ( Order_Detail::_ProductIDfk ; $Product_ID )
Set field ( Order_Detail::Rollwidth ; $Rollwidth )
Set field ( Order_Detail::HowManyRolls ; $HowManyRolls )
Go to Object ( Objectname: "Ordertab" )
In the Commit find (reset) I made the find: Product::Rollwidth (= $Rollwidth]
I get an error on the find, it not finding any thing. It put in the name $Rollwidth in find field instead of the number from Order::Rollwidth.
Wat is wrong in my script?
Why not a number instead of $Rollwidth?
You might try breaking the single Find step into explicit steps:
Enter find mode // make sure Restore is OFF/unchecked
Set field[ Product::Rollwidth ; $Rollwidth ]
Perform Find // make sure Restore is OFF/unchecked