Submitted by LeftEccoForIQ on 2019/11/03 17:12
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

Hi Left !
 
If you open your IQBase in Access, you'll see that the Event table has a text field recurrence (ICalendar format). The string RRULE:FREQ=WEEKLY is what you're looking for
 
Pierre_Admin
IQ Designer
 

LeftEccoForIQ

2019/11/04 18:06

In reply to by Pierre_Admin

Excellent, thanks, I'll try that string. When I have time I'll make sure to have a peep at my database in Access as well. Should be very interesting.