Calculation: IF with Contains

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Calculation: IF with Contains

Viewing 2 reply threads
  • Author
    Posts
  • August 21, 2017 at 6:34 AM #24112

    scneophyte
    Participant

    I checked the online manual and searched the forum topics and could not find the answer to my question:

    Is their syntax to support the following:
    IF(field CONTAINS “CD”, “yes”, “no”)

    I’ve tried CONTAINS, contains, Contains, LIKE, Like and like to no avail. If it does not exist then I will just string together multiple IF statements using “=”…but instead of needing just three stringed IF statements using “CONTAINS” I will now need nine using “=”.

    August 21, 2017 at 7:25 PM #24120

    Brendan
    Keymaster

    No, there’s no CONTAINS operator in the IF function.

    But in the beta I added a SUBSTR function which you could use. Check the beta functions list.

    August 22, 2017 at 6:38 AM #24128

    scneophyte
    Participant

    Yep, SUBSTR works for my use case. Thanks!

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.