Assuming fields is required, the following 114 results were found.
-
due on this Invoice v_AmountToPay = ifnull(invoice.get("balance"),0); // // Get custom Amount to Pay from Invoice l_CustomFields = invoice.get("custom_fields"); if(l_CustomFields.size() > 0) { for each m_CustomField in l_CustomFields {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
CRM, the pipeline is automatically pre-selected based on the user. How? So there's a bit of a pre-amble for setting up the fields, we'll then use a client script to automatically read the user's record, retrieve the department, and set the correct...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "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"; // // store the record in ZohoCreator // I have a custom form in ZC with the fields "Event_Type" (single-line) and "JSON_Payload" (multi-line) m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
is a concern around security. It is difficult to guess a customer's Zoho ID; some might say almost impossible. To use other fields that could be sent via the URL as a verification to be checked at the webhook endpoint would be good as well; but I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= Map(); m_UpsertCrmInvoice.put("Subject",m_ThisInvoice.get("InvoiceNumber")); // // some standard CRM invoice fields we can populate v_CrmInvoiceStatus = m_TranslateStatuses.get(m_ThisInvoice.get("Status")); if(m_ThisInvoice.get("Status") == "PAID") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_UpsertCrmQuote.put("Terms_and_Conditions",m_ThisQuote.get("Terms")); // // some standard CRM Quote fields we can populate v_CrmQuoteStatus = m_TranslateStatuses.get(m_ThisQuote.get("Status")); m_UpsertCrmQuote.put("Quote_Stage",v_CrmQuoteStatus);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ global $GAPIS, $CLIENT_ID, $CLIENT_SECRET, $REDIRECT_URI; $url = $GAPIS . 'oauth2/v4/token'; $post_fields = 'code=' . $access_code . '&client_id=' . urlencode($CLIENT_ID) . '&client_secret=' . urlencode($CLIENT_SECRET) . '&redirect_uri='....
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through all input fields without direct references using System.Text; using System.Threading; // for threading namespace JLDataFlowTransformations {...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
[student_ethnicity_code] FROM [sourcedb].[dbo].[events] Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " & First(Fields!PhotoURL.Value, "PhotoDetails") & IIF(Code.ImageExists(First(Fields!PhotoURL.Value, "PhotoDetails")), " exists!", " does NOT...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
The image can be an expression as well (I embed these and then refer to them in the expression by name). For example: =IIF(Fields!SummaryStatus.Value="Success", "status_ok", IIF(Fields!SummaryStatus.Value="Unknown", "status_unknown", "status_fail"))
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
I've selected a quote and applied a template to it: The Solution After removing all styling, taking away classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_Update = zoho.crm.updateRecord("Invoices",p_InvoiceID,m_Update); Additional Note(s): Just a list of fields to build up a Product Line Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and right-click on the attachment to see what the link should be: Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
(except for MySQL which doesn't need to and in my opinion is the best SQL). Additional Note(s): select can specify up to 50 fields. Defaults to 200 but can return up to 10000 records (NB: use endpoint https://www.zohoapis.com/crm/v7/coql). where can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the subform on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *