drebbin

Thanks for the quick response. The result though, is just one record still. It's starting at the top of the List All Products layout, working its way down the list, but overwriting each time with the last record (bottom of list) as the final result. If I run the script again it ends up with two of the last record, and so on. Freeze Window Go to Record/Request/Page [First] Loop Set Field [Products::RSS code; Products::RSS code & ¶ & " Go to Record/Request/Page/ [Next; Exit after last] End Loop

Hi all This is bound to be helpful for a lot of people... when it works. I have a product database and would like to generate the RSS code for each automatically and put into on field, but can't work out the repeating part. The following is on a List All Products page layout. Not sure if this is best, maybe a portal would be better. Maybe it's all possible within a calculation field not a script. I have a calculation field that does the top and bottom part of the RSS code... "<?xml version='1.0' ?>¶¶¶Title here¶Description here.¶http://www.domain.co.uk¶¶http://www.domain.co.uk/images/logo.gif¶Title here¶http://www.domain.co.uk¶¶" // BEGIN REPEAT PRODUCTS & RSS Code // END REPEAT PRODUCTS & "¶" A script via a button that does the looping and puts the result into a text field (RSS Code)... but it only puts one product in the field. Freeze Window Go to Record/Request/Page [First] Loop Set Field [Products::RSS code; " Go to Record/Request/Page/ [Next; Exit after last] End Loop How can I get it to repeat the code and record values for each record and list them in the text field? [color:red]*This is the calculation for the products, within the script. This part needs to loop/repeat for each product/record... "" </p><p> </p><p> & Products::Brand & ": " & Products::Product Name & "" & Products:<img src='https://fmforums.com/uploads/default_wink.png' alt=';)'> Product URL & "¶Product Code: " & Products::Product Code & "</p><p> In Stock: " & Products::Stock & "</p><p> Price: �" & Products::LIVE Price & "</p><p> </p><ul>" <br> <br> // Change special characters into HTML code for the 'Product Features'<br> & Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( Products::Product Features; "&" ; "&" ) ; "®" ; "�" ) ; "°" ; "�" ) ; "º" ; "�" ) ; "£" ; "�" ) ; "• " ; "<br><li>" ) ; "¶" ; "" ) ; "" ; "<br> </li></ul><p></p><p> </p><ul>" ) <br> <br> & "<br></ul><p>" & "</p><p> " </p><p> </p><p> // Image code</p><p> & "<img src='http://www.domain.co.uk/images/uploads/'>" & "¶" Thanks in advance D