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?




"$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.