BEGIN:VCALENDAR
PRODID:-//vBulletin 6//EN
VERSION:2.0
CALSCALE:GREGORIAN
BEGIN:VEVENT
UID:313fb599-e71d-4a33-ad48-ef14330887a4
DTSTAMP:20260417T225925Z
SUMMARY:Calculated / Formula field / Virtual column in report. (advanced pa
 ck)
DESCRIPTION:I have a text field\n\nPossible contents are A \, B and AB\n\nI
  want to count all records that have A\, and all that have B\, so I would 
 like to add\n- a virtual field A\, that is 1 if the string contains an A\n
 - a virtual field B\, that is 1 if the string contains an B\n​\n\n\n\n\n
 ```\n$A = ifThenElse(\nstring\\contains('$field'\, 'A') // will return tru
 e\n1\, // return this value\n0 // otherwise\, this\n)\n\n$B = ifThenElse(\
 nstring\\contains('$field'\, 'B') // will return true\n1\, // return this 
 value\n0 // otherwise\, this\n)\n```\n​\nIn this way I can use those in 
 a report (and export)\n\nWhat workarounds do we have?
URL:https://forum.espocrm.com/node/101832
DTSTART;VALUE=DATE:20240122
END:VEVENT
END:VCALENDAR