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

[Nishan Perera]

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"

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

I tried this but no luck. Please advice.

[esforim]

Update: Check Maximus solution.


You would need to use a if formula I believe;

https://docs.espocrm.com/administration/formula/#ifthen

ifThen(CONDITION, CONSEQUENT)

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

ifThen(chequeReady= "True", chequeReadyDate="")

[Maximus]

Hy there,
Use this:

ifThen(
    chequeReady == false,
    chequeReadyDate = null
);

[Nishan Perera]

Hy there,
Use this:

ifThen(
chequeReady == false,
chequeReadyDate = null
);

Hey max this works perfectly