Assuming string is required, the following 147 results were found.
-
2, 3"]} // What Creator understands: FAILS {"My_MultiPicklist":["["Option1","Options 2, 3"]"]} With workaround .toString() // What Creator understands: FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]} How? So the way to push this value over to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // set endpoint to retrieve 5 products v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?limit=5"; // // curl (zoho invoke) request r_GetProduct = invokeurl [ url :v_Endpoint type :GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will simply reset...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Data" The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save" click on "Done" Now click on "Edit Function" under...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) Purpose: Queries DHL for tracking information about a shipment and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales order/package...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to preview what records it will delete. I also recommend doing a data backup beforehand. Adapt the below as needed: string standalone.fn_Products_RemoveDuplicates() { /* *******************************************************************************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
be associated with an email address. If not, then see the 2nd snippet of code. SELECT concat('REF-', left_pad(to_integer(substring(r2."ID", 8)), 6, '0')) AS "Attempt ID", s."Title" AS "Survey", r2."End Date" AS "Response Date", CASE p."Title" WHEN...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
} } Pushing the product beyond it's design Note that before anyone says I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
- CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ) // yields // 00:00:02.1543570 -- problems with adding a string to it? CStr will not work, use .ToString ="Time Taken: " & ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and type the following c:\windows\system32\cmd.exe /c "ECHO > c:\temp.txt | FC /N /LB 1000 %L c:\temp.txt >...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 9, 2))=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF