Renumber a field in portal records

[adyf]

I have created a script to renumber a field across a set of portal records from within the portal itself. It works ok (attached) but I just wondered if there was an easier way. I want the first portal record to be given the value of 1100 and every subsequent record plus 10 i.e. 1100, 1110, 1120 etc.

I also noticed that when I ran my script with a looped exit after last record it added a record at the end because the relationship between the two tables is set to allow the creation of records in that table. I don't want it to do this and got round it by using an 'if' function. Would someone be kind enough to see if my script would be similar to the way that you would do it?

Edit: Oops......I screen grabbed this image before I added my 'if' function to exit script if a field was empty. This prevents the additional record being added via the portal as described above. Hope you still get the idea.

[Lee Smith]

Add your file to a reply

Lee