I have successfully created an email template and a workflow so that when someone gets assigned a task, an email gets sent to them that identifies the name of the task and the associated opportunity. Is it possible for either of these pieces of information wtihin email to be a hypertext link to the task or opportunity so that the user doesn’t have to do a search to find them when in SuiteCRM?
More generally, I would love to know if there is a RESTful URL that can be used to point to a particular opportunity.
You can find similar things in the meeting notification emails, and in the Call notification emails. They have links to the Accept/Reject the call, and to view the meeting. The same goes for record-assignment emails.
Remember that sending a link implies that the user can click it without being logged on, so SuiteCRM can’t always show it.
But if you take a look at that you can probably see what you need to do…
In the Event Invite Template, I see $fp_events_link and $fp_events_link_declined. My goal is to see what other variables might be available to me to create such links, but I couldn’t find a list. When I grep through the source code, I see these referenced in htdocs/install/suite_install/AdvancedOpenEvents.php, but I don’t see them in any other files.
So, I thought maybe they are references to columns in MySQL tables, but I can’t find the SuiteCRM schema. I see a SugarCRM list of tables at http://apidocs.sugarcrm.com/schema/6.5.16/ce/, but no events table.
Can you tell me how to find what the available $link variables are?
No, there isn’t a schema with multiple events for you to choose from. The Events module is an “Advanced Open” module, that means it’s developed by SalesAgility, it was not present in SugarCRM.
This is the standard format for URL’s in SuiteCRM, when you navigate the app you can see how these look like as you move from module to module and between different views. I think you will have better luck trying to construct an URL in this format, it should work for all modules (but only when the user is logged in).
I figured it out. The magic variable name, which I found by digging through source code (again, it would be so nice if there was a list somewhere…) turned out to be $task_id. Including the following in my email template generated a working link in the generated emails to the appropriate SuiteCRM task screen:
For anyone who tries this, if it doesn’t work and you want to go back and edit it, once you get to the template edit screen, pick Source from the Tools menu and edit the actual HTML. There will be a lot of CSS cluttering things up, but you’ll have more control over what’s going on.
Create a URL field inside the task module “task link” or similar
Use workflows + calculated fields to concatenate the URL + ID of a task: https://www.youtube.com/watch?v=kAIX-PzsYdE
and store the result inside a task (on update / on create)
In your profile towards the bottom, switch the editor to TinyMCE for good measure
Embed the name + link via HTML / variables inside your templates
The same is possible for related records - just the calculated fields would retrieve the values from related entities.