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.

Calculation and Sum for all Records

Nikos Gewrgioy
in Calculation Engine (Define Fields)

Featured Replies

Hello,

 

I would like to make a relationship for sold items and for stock items to know how many items I have in stock.

I have two fields one for Quantity Potentiometer and one for Type of Potentiometer.

I make a calculation field with with name Sold 250k Pot with function: If (Pot type = "CTS 250k Audio Pot";  Quantity Pot) and then I have another one calculation which removes the Bought 250k Pot and I know how many Pots are in stock (Bought 250k Pot - Sold 250k Pot) and work perfectly but if I go to a new record the Bought, Sold and Stock fields didn't show me the remaining stock items or the bought parts or the sold parts from the previous projects.

 

Could you help me to solve this problem?

 

I have uploaded the database to show you the problem.

 

 

Thank you in advance

Projects.fmp12.zip

Please attach your file here.

 

If you are having trouble doing this, let me know.

  • Author

Hello Lee,

 

I have attached the file in my first post.

The potentiometer details and records should be in a separate table rather than  in the projects table

  • Author

Efen, how can I do that?

I can't explain how you can do this better than Todd Geist does in his video and example file here Invoices

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.