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.

Trying to get an exact text match

Jalz
in Calculation Engine (Define Fields)

Featured Replies

Hi Guys,

I have two fields, field 1 contains the data

New York

however field 2 contains the data

London

Milan

New York

New York2

Madrid

What formula can I use in a calculation to say if the content/value of Field 1 is in field 2, than display a True, Else display false.

The values in field two are seperated by a carriage return.

Many Thanks for your help

Jalz

Try:

not IsEmpty ( FilterValues ( item ; list ) )

Have you considered setting up a relationship?

field1 --> field2

You can then test with

field1 = relationship::field2

The relationship may also be handy for value lists etc.

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.