Assuming populate is required, the following 27 results were found.
-
my code should be something like the following: // // get 100 most recent appointments where this field hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
{ my_col1_val: 'item1c', my_col2_val: 'item2c,c' } ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
INSERT using JDatabaseDriver Here's an alternative method to add a record to a table in Joomla: // Create and populate an object. $user_record = new stdClass(); $user_record->name = 'Joel'; $user_record->username = 'jlipman'; // Insert the object into...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
drag markers for precision - Map: horizontal sensor level - Map: display gallery of screenshots (+offline mode) - Map: populate nearest cities for lat/lng to more accurate city names - Map: use map touch listeners - Map: timeout requests on idle - News:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
field and a multi-line field onto the form called "Title" and "Content" respectively. If you use this method to populate your notifications, you can send the ID of the record to show On the Creator page, retrieve the title and content of the modal...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
r_Create = zoho.crm.createRecord("Tests", m_Create); // now take the ID that was created and use the following code to populate the multi-lookup field if(!isnull(r_Create.get("id"))) { m_Link = Map(); // using record IDs cos there's nothing better...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= r_ContactDetails.get("Zip"); v_AddressCountry = r_ContactDetails.get("Country"); } // // get line items from source and populate this subform l_QuotedItems = r_QuoteDetails.get("Product_Details"); c_LineItems = Collection(); for each m_LineItem in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
method is fine for 1 or 2 fields and if your workflows only trigger when the form first loads (especially on Edit as this populates each field and triggers their workflows) but cumbersome when there are a lot of fields. if(zoho.currenttime >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
input.Wednesdays.clear(); input.Thursdays.clear(); input.Fridays.clear(); input.Saturdays.clear(); // // populate the other subforms with our collections input.Tuesdays.insert(c_Tuesday); input.Wednesdays.insert(c_Wednesday);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= v_NoteAttachments; Here's the code at the end of the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide Attachments.Downloaded; Here's the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
their own reference for the JobOpening called "Vacancy Ref". The below outlines the custom module we created and how we populated with associated candidates: The CustomModule6: Candidate: Lookup to the Candidates module Job Opening: Lookup to the Job...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
Additional For every chat message, the OpenAI ChatGPT forgets what the context of the conversation was about: Well we can populate the list of messages so that there is a conversation trail for the OpenAI ChatGPT to build on: // // initialize m_Response...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
"Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { m_InvoiceLineItem = Map(); m_InvoiceLineItem.put("item_id",...
- 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: *