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
  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.

Autofill from previous related record

lsmall
in Value Lists

Featured Replies

I am trying to auto-populate a field in a new record using the value of that field from the previous related record. This field uses a value list from a related table. I also require that I can change the value in the new record without changing the value in related records. The "Value from last visited record" option will not work because, often, the last visited record is not a related record and the field auto-populates with the wrong value.

Let me know if I need to clarify or elaborate.

Thanks for the help.

.. Well this is the first method that comes to my mind but it has a few drawbacks.

1) You cannot use portal based sorting - all sorting has to be done via relationship

2) The field will only fill if left empty

... For the second one, I've tried to add a sort of work around script.

It's not great, but might give someone else an idea when helping you.

Create an account or sign in to comment

https://fmforums.com/topic/55123-autofill-from-previous-related-record/
Go to topic listing

Important Information

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

I accept

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.