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.

Manual Update of Auto-Enter Calculation

Featured Replies

I have several fields that are auto-enter data via a calculation ("pull info from fields B, C, D, etc."). These are set up as auto-enter calculations because it populates the target field not just with the raw data but often additional verbiage as well as many other factors. The purpose is to take the details of a Quote Request to create a Quote Letter that could be sent to a client. They are auto-enter calculations so that the salesperson can alter the verbiage as needed for the Quote Letter - the initial data is populated as a starting point (and often remains as entered) but allows for necessary customization.

 

(I have inherited this database and the original designer did not make the Quote Letter a separate table, though I have been contemplating splitting it out to a separate table.)

 

The calculations are all set to replace existing data so that if anything changes in the referenced fields, the target field is supposed to update. However, I have found that there are instances this isn't happening properly and I could use a way to manually trigger an update. I know that I could copy the formula (sometimes VERY lengthy) and create a button that would replace the contents of the cell based on the same formula, but I am concerned about having the same formula in two places (always concerned that an update will be made in one place, but not the other, though I could put a comment at the beginning to note to change in the "other" place). Is there a way to tell the field to update based on the Auto-Enter Calculation formula?

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.