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.

Math Formulas in a Field

Featured Replies

  • Newbies

Hi, I would like to say that I only have 2 days playing around with FM, and this is my situation.

I want to know if there is a way that i can type in a field a formula like this =(8*2)+2+2.5+10 and get the result either in the same field or another field to be used in a "Qty total field" for a Square Feet count.

Te reason for this is that we walk the site with a notebook taking notes of how many SqFt the workers did on a week to generate their payroll, I have this table setup in Excel with VLOOKUP for Price per Unit and everything, thanks to this forum i already have tat part of my payroll working (using an invoice based solution), but the part that I want to avoid is taking the notebook doing all the math in a calculator and then type it in File Maker, i would prefer to type directly in file maker and get a result, I know file maker is not a Spreadsheet solution but any guidance would be helpful.

Thanks in advance for any tips or suggestions

Check out the Evaluate() function.

  • Author
  • Newbies

Thanks a lot, thta's what i was looking for

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.