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

Calculated but variable value

musicarteca
in Calculation Engine (Define Fields)

Featured Replies

Hi all,

I have to create a field with a default reference calculated value, but this value has to be subjected to modification. The field is a due date of a task based on a starting date of a project in a related table.

I tried with auto-enter calculated value, but it doesn't work, since some of the fields used in the calculations might be empty at the moment that the record is created.

I tried a self-relationship in the task table to try to lookup the calculated value of the due date to be looked up in a date field so it can be modified later, but it doesn't work either.

Any suggestions?

Seems like you need to work a "set field" into some scripted process for this to work. See if you can put it into a record or layout navigation script...

  • Author

I really don't want a scrip solution. I opted for the "one field on top of the other" solution.

Create an account or sign in to comment

https://fmforums.com/topic/39870-calculated-but-variable-value/
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.