... if successful then read the response
if(r_ResponseXML.contains("Success"))
{
//
// init
l_JSONItems = List();
//
// parse the data
v_MainNode = "ActiveList";
x_MainNode ...
... might want to consider that not all new lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different ...
... = r_AvailableSlots.get("response").get("returnvalue").get("data");
if(!l_AvailableSlots.toString().containsIgnoreCase("Slots Not Available"))
{
for each r_AvailableSlot in l_AvailableSlots
{
if(!r_AvailableSlot.contains("00:00") ...
... 1, 200, "Year_Month:equals:2021-06")
{
v_ThisEventTime = r_Event.get("Event_Time");
v_ThisEventNote = r_Event.get("Event_Details");
//
// now lets add double-quotes for Excel in case the event contains ...
... creating a record in a module that contains a lookup
m_Create = Map();
m_Create.put("Name","Joels Amazing Test");
r_Create = zoho.crm.createRecord("Tests", m_Create);
// now take the ID that was created ...
... to retrieve all the data in each record r_QuoteDetails = Partners_Quote[ID == r_Quote.ID];. In the example below, this is a merging process of each quote which only contains 1 line item and not a subform ...
... := SelectedDir "\*"
Loop, Files, %v_FilesPath%
{
; skip if file ext is not media
if A_LoopFileExt not contains wav,mp3,avi,flv,mkv,mov,mp4,mpeg,mpg,wmv
continue
...
... are sending are not in the right format.
: The attachment parameter is populated with the file content instead of the internal file name.
: The doc parameter contains special characters.
Improper ...
... yields:
// a,b,c,d,e
// a,c,e
// compared to:
for each v_FieldName in l_FieldApiNames
{
if(!l_ExcludeFields.contains(v_FieldName))
{
... do stuff here ...
}
}
// notes:
// no need ...
... extract value.
Hide the first column in the list view (contains "Profile 1", "Profile 2", ...)
Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc)
Create subroutine for ...
... from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:
...
l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];
...
Lastly, there ...
... = false;
// get attempt
v_Output = thisapp.generateRetrievalCode();
// see if can use contains but check for word
for each v_BadWord in l_BadWords
...
... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.
Sheet1 contains the following:
A B
--------------- ---------------
seize
spell
fence
total
thank
fight
noise
terms
thigh
tasty
light
swarm
shelf
allow
unity
press
board
wreck
shake
decay
Sheet2 ...
... It also contains the public key under the guise of a URL (x509 certificate) but we don't need it for this script. Note that the key should not be stored in a public folder that is accessible via the web ...
... + v_NextRenewalDate.toString("MMMM, yyyy");
info v_ContractDateFormatted;
// yields Tuesday, 6th of November, 2018
Method #5:
if a list contains:
v_NextRenewalDate = '2018-11-06';
v_EnglishOrdinal ...
... I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ).
Merging the lot
If B1 contains the coordinates and there is a space ...
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.