... image URL to/from ZohoWriter.
Loop through active users in ZohoCRM.
Merge the HTML email signature with the fields evaluated.
Function: fn_Workdrive_HostImage
I add this function to the CRM ...
... enter your own organization ID here for ZohoBooks and ZohoInventory
v_BooksOrgID = 12345678901;
//
// evaluate
v_currentDate = zoho.currentdate.toString("yyyy-MM-dd");
v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd");
v_Page ...
... evaluate (specify here your dates [time set to midnight])
v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
//
// ...
... wild guesses but thinking that making the change makes something in CRM re-evaluate the HTML in the box and saves it to the template... Previous to trying this, we had Zoho investigate this issue but ...
... can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate).
Method #1: First version
This was my ...
... Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string:
Another alternative to round brackets, square brackets!
Additional:
I have ...
... // bit of a copout I know
$string_formatted = preg_replace ( '/\'([^\']+)\'/', '$0', $string_formatted );
Surround string (apostrophes) with red styling and evaluate:
Convert: this='some string' ...
... kick up the backside to the commercial solutions and for them to perhaps invest/develop/improve on their services, or re-evaluate their fees, hint hint ).
By the way, it's hard for me to tell which ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.