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.

Text calculation not giving desired results.

Steve G
in Calculation Engine (Define Fields)

Featured Replies

I've got a table with a number of fields, among them "User", "Model", "Type", and "User with Model". (All fields are text fields.) The contents are pretty obvious; "User" is the username, "Model" is the manufacturer and model information for that hardware, and "Type" is the type of hardware (mouse, laptop, etc). The "User with Model" field auto-enters a calculated value thus:

If ( (Type = "Workstation") or (Type = "Server") or (Type = "Laptop") ; User & " (" & Manf Model & ")" ; "" )

This generally works fine. In records where the hardware is a Workstation, Server or Laptop, I get the appropriately generated field ("john_doe (Apple iMac)", etc). In records where the hardware is NOT a Workstation, Server or Laptop, the field is left blank.

The problem arises when the "Type" field is left blank in a record. When this happens I get "john_doe ()".

How to fix?

It should be working. Please post a copy of your file perhaps with only one record.

  • Author

I managed a workaround by adding a condition:

If ( (Type ≠ "") and ((Type = "Workstation") or (Type = "Server") or (Type = "Laptop")) ) ; User & " (" & Manf Model & ")" ; "" )

Edited by Guest

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.