Assuming specified is required, the following 81 results were found.
-
cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can only use this in another dataset which won't use a sub-query more than 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
function cannot be applied: Possibly due to me trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
number and carrier to shipment record on either creation or modification. - Only creates shipment order if shipped time is specified. - Only marks shipment as delivered if DHL API checked and status returned is delivered Date Modified: 2023-03-22 (Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
URL - Cannot use window.location URL var queryParams = ZOHO.CREATOR.UTIL.getQueryParams(); // Check parameters were even specified if (queryParams.p_ShopifyEmail !== undefined) { v_ShopifyEmail = queryParams.p_ShopifyEmail; } if (queryParams.p_ShopifyID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
domain change. The use-case is that the customer wants the item/product rate taken from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= {1}; v_PerPage = 1; // // map to retrieve all records (to include approved and converted records, this needs to be specified as the query value) m_IgnoreRestrictions = Map(); m_IgnoreRestrictions.put("approved","both");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
field on the invoice) var o_InvoicedQuote = ZDK.Page.getField('Quote').getValue(); // go down this route if a quote is specified (they were on the quote and clicked on the plus next to 'invoice') if (o_InvoicedQuote != null) { // check on the quote...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // // init v_OutputMessage = "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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // // init v_OutputMessage = "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 >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
script has been adapted to change the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET @v25_admin_id=42; -- Set this to the ID number of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Press Esc while dragging a tab. Returns the tab to its orginal position. Ctrl+1 through Ctrl+8 Switches to the tab at the specified position number on the tab strip. Ctrl+9 Switches to the last tab. Ctrl+Tab or Ctrl+PgDown Switches to the next tab....
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified earlier. if( $api['jwt']['token']['minutes'] > 5){ $access_token =...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
would be: B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD;com.mydomain.myappname * In the above, if you have specified the correct bin folder in your PATH environment variable, then you can use the keytool from any folder, skipping the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *