Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Renumber a field in portal records

March 6, 201213 yr

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.