ifElse-Formular

Hi Nina Ziemann

Once try with the below formuls:

ifElse(equal($field-name,"Yes"),date(concat(subStr(toString(today()),12,4),"-01-01")),
ifElse(equal($field-name,"No"),date(""),date("")))

Note: Make sure Date entering format match your date, am currently assumes that the date is given in the format like yyyy-mm-dd.

Hope this Helps..!!

Best Regards

S Ramana Raju

Thank you very much for your help! Unfortunally it did not work. With this formulas the date is set to today and if I say "no" die date-field is still not fillable. My Date entering format is dd.mm.yyyy so I set it to "01.01.", right? Maybe its something other I have to change because I use the german Sugar?

Hi

Check with this if your date format is dd.mm.yyy:

ifElse(equal($field-name,"Yes"),date(concat("01.01.",subStr(toString(today()),12,4))),
ifElse(equal($field-name,"No"),date(""),date("")))

Hope this Helps..!!

Best Regards

S Ramana Raju

If it is much easier it also would help if the Date is automatically set to "01.01.2016" and on the 1.1.2017 i will chance 2016 to 2017, that would also be no problem for me... but i still dont understand why i cant change the date if i say "no" :/

I tested in my local, formula is working for me.

Once cross check field Standard-Vertragslaufzeit dropdown both Iteam Name and Display Name same as "Nein" and "Ja"

ifElse(equal($field-name,"Yes"),date(concat("01.01.",subStr(toString(today()),12,4))),
ifElse(equal($field-name,"No"),date(""),date("")))

Here in the above formula Yes / No are the Iteam Name from the Dropdown List. So manke sure you are giving Iteam Name only. Also value will be updated only after you click on Save button.

Coming to "Why you cant change the date if you say NO" - coz for calculated field, we can no longer set the value manually in the Edit View. This field will be in disabled.

Let me know for further help.

Best Regards

S Ramana Raju

I tested in my local, formula is working for me.

Once cross check field Standard-Vertragslaufzeit dropdown both Iteam Name and Display Name same as "Nein" and "Ja"

ifElse(equal($field-name,"Yes"),date(concat("01.01.",subStr(toString(today()),12,4))),
ifElse(equal($field-name,"No"),date(""),date("")))

Here in the above formula Yes / No are the Iteam Name from the Dropdown List. So manke sure you are giving Iteam Name only. Also value will be updated only after you click on Save button.

Coming to "Why you cant change the date if you say NO" - coz for calculated field, we can no longer set the value manually in the Edit View. This field will be in disabled.

Let me know for further help.

Best Regards

S Ramana Raju

ok thank you. If I cant change the field if i say no it doesn't make sense for us to make a formula at all.

Thank you very much for your help!

after saving it is the 1.1.2016 so it was my mistake, i apologise. Its working well.

Hi Nina

Glad that it helped you.

Best Regards

S Ramana Raju

This only works for locally hosted system right? Is there a way to do this on a cloud hosted system?

Hi Matthias Zeumann,

The solution uses the Formula Builder and Dropdown Editors available in Studio in the user interface of the application, so I do not see a reason this solution would be incompatible with a hosted instance of Sugar.

I see thank you! 

I posted another thread with my question about a dependable relationship.

I know this has been a few months, but how would I flip this code? If the date field is populated, I would want the other field to show a "Yes" and if the date field is not populated, then the other field would show a "No"