Assuming update is required, the following 126 results were found.
-
Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and programmatically....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
a function 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
completes and signs the form via ZohoSign ZohoSign on completion triggers worklow from within ZohoCRM ZohoCRM webhook updates the tracking record (ZohoSign Document) and attaches the signed document to the contact record Button Code: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero > Accounting > Accounting Settings >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
)); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id = $db->insertid(); UPDATE using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
// com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true);...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE `#_content` SET `checked_out`=NULL, `checked_out_time`=NULL; Viewing Users in the Administrator panel: UPDATE `#_users`...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
@NumberLeft INT DECLARE @random INT DECLARE @CurrentID INT DECLARE @ScrambledID INT DECLARE @Data VARCHAR(MAX) DECLARE @UpdateData VARCHAR(MAX) DECLARE @Chosen BIT DECLARE @ChosenID INT DECLARE @SqlStatement NVARCHAR(MAX) DECLARE @UpdateSqlStatement...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' =...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" and would get the following response when attempting: { "response": { "message":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
// create link r_Link = zoho.crm.createRecord("Tests_X_Contacts", m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID != 0) { m_Link = Map(); m_Link.put("Deal", v_DealID);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
URL Syntax #5 [image]: Update 2023 Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
r_Users = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_UserUpdates = List(); for each m_User in r_Users.get("users") { v_CurrentSignature = ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and export it to PDF. They can then send the PDF to the supplier. Technical Information Automations in the background, on update of ticket or attachment webhook, will push some of the details of the ticket and all/any attachments to a Zoho Creator form....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *