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.

Modified by User Field

Joseph31
in Calculation Engine (Define Fields)

Featured Replies

Looks like a simple question at first -- but read on.

I have a main page which has about 5 different related pages that connect to it. I wanted to start an auto calc field that show the person who modified the page last and date --- this works well for the main page but ever time someone modifies one of the other related pages the modified date and user does not change --- QUESTION: Is there a way to make it all link together per main page w/ all related pages. So if someone changes something on any related page to the main page it updated the modified date on the main page.

Thank you,

Joseph

Using a Max() funciton on the auto-entered, modification timestamp of all related tables would give you the last modified timestamp. It could also be used in creating the parent table key field to the last modified child record. This would allow the username and any other data to be brought to the parent table.

The parent table must be refreshed to trigger the updated value.

  • Author

Great thank you very helpful.

Joseph

  • Author

Ok I tried what you said can you show me how I can use this to modify the parent record?

Thank you,

Joseph

  • 1 month later...
  • Author

Thank you again --- Really helpful

Joseph

Create an account or sign in to comment

https://fmforums.com/topic/54400-modified-by-user-field/
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.