Skip 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
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Portal Creation Control

Featured Replies

How can I direct my creation script to portal's most recently created record?

In my database I have chosen to not allow user to create a portal record via click in next empty row. I have a separate "creation table" that is not on the user interface.

So I have a script that does the creation for user. Currently the script will create record > then go to last portal row. The problem is, on most of my portals I have an alphabetical sort for ease of reading. So (go to last portal) will not necessary be the newly created record.

I can make this work if I sort portal by modification timestamp, but then I lose my alphabetical sort which is a bad thing.

NOTE: Some portals may not be sorted alphabetical, some by price, rating, etc.

So I'm thinking the solution is to point the creation script to latest modified portal record, but I do not know hot to do this.

Any help on this of course is greatly appreciated.

Thank you so much for your time!

Interesting problem. A couple of ways come to mind:

1. After creating the new record, set a variable to its serial ID. Back in the parent record, loop through the portal rows until the variable equals Child::ChildID.

2. Start the script by GTRR [show related only]*. Create the new record, sort the records alphabetically, and set a variable to Get (RecordNumber) - this will be the row number to go to back in the parent record.

3. Sort the relationship alphabetically, instead of (or in addition to) just the portal. After creating the new record, set a variable to its serial ID. Back in the parent record, look for the position of the ID in List ( Child::ChildID ) and calculate the portal row to go to.

---

(*) Actually, it needs to start by checking for the existence of related records. If none has been created yet, go and create one - then go to the first portal row.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.