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.

Text format in field A conditional on field B

Philip Jenks
in Calculation Engine (Define Fields)

Featured Replies

I want to make the text in a field red if another field has a '1' in it. The second field would indicate that a product is out of stock, and when that is the case, I'd like the name of the product in the first field to be displayed in red (or possibly 'strike through' so that I can immediately see that the product is redundant.

Anyone know how I can do this. Apologies if it's a really basic question, but I'm pretty much a beginner.

Thanks.

Create a calculation field of Case( field2 = 1, name ). Stack this field on top of your normal name field, format the text to be red, and format the background to be transparent.

  • Author

Queue

Thanks for your help. Worked a treat! Very grateful.

Philip

Create an account or sign in to comment

https://fmforums.com/topic/25558-text-format-in-field-a-conditional-on-field-b/
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.