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.

Search a string within a string

kokorota
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hi

I created a field called "days of the week" where I can choose thru check boxes the days a course is taking place. These days belong to a valuelist with monday, tuesdays, wednesday,etc..

 

I'm trying to make a schedule based on such field but when I try to see if for example "Monday" is part of the text of "days of the week" it doesn't return anything

 

I've tried patterncount, Filtervalues, valuecount and nothing seems to work...

 

How can I evaluate if Monday is within such field, let's say the fields "days of the week" has monday, tuesday and saturday. How can I find Monday in such text field???

 

Thanks in advance

checkboxes.PNG

Your topic should actually read: “Confirming a value's presence within a list”, since a list it what a checkbox-formatted field will hold.

Try

not IsEmpty ( FilterValues ( "Lunes" ; diasDeLaSemana ) )

Edited by eos

    • Like 1
    • Author
    • Newbies

    thank you, I found the answer:

    Not IsEmpty ( FilterValues ( Dias de la semana ; "Lunes" ) )

    Create an account or sign in to comment

    https://fmforums.com/topic/95681-search-a-string-within-a-string/
    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.