...
What I have
Me,Myself,I\na,b,c
What I want
Me,Myself,I
a,b,c
How?
So in this article I just want to list some various methods of inserting a new line character.
Works on most ...
Situation:
I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...
What?
A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this).
Why? ...
... Transfer Protocol on a Port number of your choosing:
Set for new imports to append, replace, or check if exists then insert/replace:
Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly:
...
... is that datetime fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time Settings); so as soon as you try to insert a date time and perhaps accompany that value with a timezone, ...
... ... code to create new record
r_NewRecord = insert into
[
=
=
=
];
}
Done:
Additional
Remember that an integration field on the interface is returned as a string ...
... a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one ...
What?
A super quick article to remind me how to generate and send a CSV as an attachment to an email.
Why?
Because I often get casually asked "oh and can you archive the data and email it to me ...
What?
This is an article to show you how to use triggers but also how to stop them. We only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord ...
... ];
// add record as zoho.loginuser so that only record owners can access this record in report or form
r_HoldInCreator = insert into Download_File
[
Added_User=zoho.loginuser
...
... = "Sorry! Leave has been rejected due to too many employees booking the same dates off.";
c_Response = Collection();
c_Response.insert("EmployeeID":v_OutputMessage);
c_Error = Collection();
...
... found COLLECTION expression
How?
Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong.
Contrary to what the documentation that says "This task ...
... line items to insert the "sales_order_item_id" field
v_InvoiceID = invoice.get("invoice_id");
v_BooksOrgID = organization.get("organization_id");
//
// a sales order has been created, get its ID ...
... be applied
Solution: I have to convert the node into a map:
info m_Response.get("item").toMap().get("item_id");
// yields: 123456789012345678
Problem: Inserting a date time string into a date ...
...
-------------- -------------
MyProduct1 TEST01
Myproduct2 TEST02
myproduct3 TEST03
I'm trying to insert a record for a new product if it doesn't exist in the table but if it does ...
... "$2", trim($v_Output, "_"));
// returns a string
return $v_Output;
}
and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias:
DROP ...
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.