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.

If Negative number then move to another field?

stann
in Calculation Engine (Define Fields)

Featured Replies

Hi

I have a spreadsheet where presently if the customer owes something it becomes a negative number in the field "service". I would like to have a calculation or a script that sends that number to another field called "owed" only when there is a negative number in the "service" field.

So if the service field says -$220 then the negative sign somehow signals that the number should be placed in the "owed" field for $220 . that is what I am trying to do but I just don't know how to do it.

Thanks

Stan

make a calcs field:

c_SignalField= Case(SericeField < 0,"OWED")

and place it next to the service field on your layout to 'display'

the same goes for validation of field Serive to 'warn'

and if u want all this 'automatic'

then make a script that is run on "submition" or finsihed entry in service field:

IF SericeField < 0

SetField[owed_field,service_field]

SetField[service_field,""]

EndIF

Take care!

Create an account or sign in to comment

https://fmforums.com/topic/24675-if-negative-number-then-move-to-another-field/
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.