Task reminders with formula

[Emmker]

I am trying to create a task, with reminder 'on time' with entity formula.

I have :

$TaskName = string\concatenate(name, ' - ', client.name);
$TaskDueDate = string\concatenate(nextRenewal, ' 11:30:00');
record\create('Task',
'name', $TaskName,
'dateEnd', $TaskDueDate,
'assignedUserId', assignedUserId
    )​ 

But I have no way to set a 'on time' reminder.

any ideas?

*no advanced pack

[dimyy]

In order to understand how to form certain entities in the system, take a look at the Chrome inspector. I think the above screenshot will help. A positive value means time "before" the event

[Emmker]

I did just that, but I cannot find a way to translate it in formula script.

[lazovic]

Hi Emmker,

Try to use the following formula script:

$taskName = string\concatenate(name, ' - ', client.name);
$taskDueDate = string\concatenate(nextRenewal, ' 11:30:00');

$taskId = record\create(
  'Task',
  'name', $taskName,
  'dateEnd', $taskDueDate,
  'assignedUserId', assignedUserId
)​;

$reminderId = record\create(
    'Reminder',
    'entityId', $taskId,
    'entityType', 'Task',
    'type', 'Popup',
    'userId', assignedUserId,
    'seconds', 0
);​

[Emmker]

Hi Emmker,

Try to use the following formula script:

$taskName = string\concatenate(name, ' - ', client.name);
$taskDueDate = string\concatenate(nextRenewal, ' 11:30:00');

$taskId = record\create(
'Task',
'name', $taskName,
'dateEnd', $taskDueDate,
'assignedUserId', assignedUserId
)​;

$reminderId = record\create(
'Reminder',
'entityId', $taskId,
'entityType', 'Task',
'type', 'Popup',
'userId', assignedUserId,
'seconds', 0
);​

That worked like a charm.

I just realised that reminder is its own entity.

Thank you very much