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

Should be an easy calculation...I hope!

drjay
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hi guys,

Newbie here with what should be a quick one. I'm trying to keep track of customer credit between two databases. Database1 is the general customer info with a field I created for adding in any credits due. Database2 is the invoicing bit where we add up their totals. I've managed to create the necessary fields so that Database2 looks to Database1 for the credit amount, but I need it to then subtract that amount from Database1 otherwise they will always have a credit. All of my solutions so far have been met with FM freaking over a circular sumbit.

Keep thinking it's going to be a simple if/then/else solution but I'm not very savvy with FM.

Thanks for any direction.

Create an account or sign in to comment

https://fmforums.com/topic/42671-should-be-an-easy-calculationi-hope/
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.