RyanAshton

Script step to go to a specific portal row

Discussion created by RyanAshton on May 11, 2016
Latest reply on May 14, 2016 by smith7180

Hi community,

 

I am finally getting my head around scripting, thank to the great community here and a video series I am watching on Lynda.com (http://www.lynda.com/FileMaker-Pro-tutorials/Assigning-script-steps-buttons/161168/172340-4.html

 

The one thing that really helped me from that course was when the course author said "try to think of script spots as a recipe" and that they "simply replace step that you would be able to do without a script".

 

That might be obvious to many here, but it was quite a revelation to me.

 

So, on to my question....

 

I have this "add" button to add a Product_Item to the Line_Item_Portal on the same layout.  When I press the button, I want to be taken to the Portal Row who's field "Product_ID" = the variable is have already set "$Product_ID".

 

How do I make FMP go to a portal row matching a criterion I set?

 

e.g.

 

"$Product_ID" = 7

 

I don't want FMP to go to row 7 of said portal.  I want FMP to the record in that portal who's field "Product_ID" matches "$Product_ID" (In this case, row 2 - but it might be row 4 next time around, etc)

 

 

 

Thanks in advance.

 

Regards,

 

 

 

Ryan

Outcomes