Hi All - I think there is a better way to achieve this, but can't quite work it out. We have a field which we want it to have a date/and text and if it's a date then that date will be used to create a task. If it's "text = Open then nothing to do.
What we need is Task Reminder to tell us to check if the event registration is open, if its not "Open" then we want to enter a date in the future for our next Task Reminder. How can I get Sugar to look at this field and if it's a date then create the task and remind the user at the correct time.