Announcement

Collapse
No announcement yet.

Help Formula - If checkbox is true date should be none/blank

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help Formula - If checkbox is true date should be none/blank

    If have a below 2 new fields

    payment ready - type boolean
    payment ready date - date time


    for a example user update the "payment ready = true" and "ready date = 03/07/2020"

    I want to change the "payment ready date" to none if the "payment ready is = false"


    Code:
    string\substring(chequeReady) = 'True',
    chequeReadyDate = 'None';

    I tried this but no luck. Please advice.
    Cheers!
    Nishan.

  • #2
    Update: Check Maximus solution.


    You would need to use a if formula I believe;



    ifThen(CONDITION, CONSEQUENT)

    So something like this might work (have not test):

    Code:
    ifThen(chequeReady= "True", chequeReadyDate="")
    Last edited by espcrm; 07-06-2020, 07:51 AM.

    Comment


    • #3
      Hy there,
      Use this:
      Code:
      ifThen(
          chequeReady == false,
          chequeReadyDate = null
      );

      Comment


      • #4
        Originally posted by Maximus View Post
        Hy there,
        Use this:
        Code:
        ifThen(
        chequeReady == false,
        chequeReadyDate = null
        );
        Hey max this works perfectly
        Cheers!
        Nishan.

        Comment

        Working...
        X