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.

Colored Fields

Featured Replies

  • Newbies

You want a calc field that returns a container, and a series of global container fields. In each global container field, insert a bitmap graphic that is a solid color. The calc field will return the contents of one of the global fields, depending on the entry field (I suggest using "Case").

Put the calc field behind the entry field, and make the entry field transparent.

I'm not quite sure what you mean by the "field changes color" would this be the color of the text in the field or the color of the field background? I'll assume text in the field.

What you need to create is two calculated fields to put on top of your existing field. The top field needs to be formatted with the fill color as transparent. The new fields are:

GreenResult (calculation, text) = Case(EntryField = "x", EntryField, "")

RedResult (calculation, text) = Case(EntryField <> "x", EntryField, "")

The fill of the top (say GreenResult) field is transparent

The fill on the middle field (say RedResult) is white.

Both are set to not allow entry (I know you can't enter into a calculation field) but this forces you to EntryField on the bottom when you click on the stacked fields.

-bd

  • 7 months later...

Check out the sample file (Handy Bits) I posted in the samples section of this Forum. It contains examples of both colouring options you are looking for - and also combining them - under its "Colour" Tab.

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.