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.

Script for new record but in the same table

Featured Replies

I've gone through many pages of the forum and also did some searches but I haven't found what I was looking for.

My current database which is a Prospect management currently employ a table occurence of itself to show subsidiaries (child companies of the prospect). I would like to know how to create a script that will let me add a second new record while I'm already in the process of adding new one.

Prospect.zip

Edited by Guest
Forgot to post the file

  • Author

I should maybe give an example,

I'm entering a new record (parent company) and now I want to enter the names of the subsidiaries (child companies) as well.

So that it shows up in the portal of the subsidiaries.

I should mention that the fields are written in french but the design is in english, hopefully you guys will understand it.

Your basic script works. Except that you need to return to the original record when the new record is created.

Also why do you ask for the parent ID in a dialog? You're doing nothing with the value that one enters? And you don't need it because you're passing the parent ID as a scriptparameter.

A non-scripted way of doing this is to set the relationship to allow for creation of related records. Then you can just type the name in the empty bottom row of the portal...

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.