I'm using a row equation to create a kind of smart field (e.g. 'ApptInNiceFormat') by reformatting parts of the Appointments date from my calendar and am showing this field as a grid column.
I would like to improve on this by preventing ApptInNiceFormat's value from being changed / updated by the row equation when the calendar event for an item is set to recur weekly because I want those to be undated (for a weekly recurring event, the value should be something like '24/10 Do, 15:30', but for weekly events it should be just 'Do, 15:30' without the date). So in prose, I want this:
If item is associated with weekly recurring event, don't update ApptInNiceFormat (I want to be able to set it manually). If it isn't, set ApptInNiceFormat to the result of the reformatting equation.
So I guess what I really want is an if condition that checks for weekly recurrence. Is that possible?
If it isn't, I guess I could combine two fields through a smart field so that I can set values for the items recurring weekly manually and the smart field can then combine them with the values produced by the row equation for the non-recurring items...
Any help would be much appreciated.
Comments