What?
This is a very quick article with a code snippet on how I added to a multi-lookup field.
Why?
Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...
What?
This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge.
Why?
Sometimes you might need this when data mapping fields from one module ...
What?
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...
What?
A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...
... Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script.
The Download
Should contain the following:
create_countriesipranges_table.sql: SQL to create ...
... the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup.
The document form is a subform derived from an existing form (called "Document"). Mainly, because ...
... data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double.
You can search for a maximum of 10 criteria (with same ...
... void the invoice, delete the package and shipment.
- Added chart of accounts lookup to set purchase account for an item: now ticks purchase information and track inventory.
- Issue on create ...
... CustomModule6:
Candidate: Lookup to the Candidates module
Job Opening: Lookup to the Job Opening module (called "Vacancies" in client's system)
Candidate Ref: A single line text field
Vacancy Ref: ...
... for this lookup field. - Parent Id: Ensure that CRM Record ID exists and that you are uploading the associated module CSV at the same time as the attachments (eg. if Parent Id is a CRM contact record, ...
... v_RateCard = ZDK.Page.getField('Which_rate_card_is_this_based_off').getValue();
// get opportunity lookup (related deal) of this record
let r_DealLookup = ZDK.Page.getField('Opportunity_Name').getValue();
...
What?
An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field.
Why?
I could do a normal automation/workflow ...
... (single-line)
DST In Effect (boolean)
With the addition of 2 lookup fields to our booking form: one called "Customer's TimeZone" and the other called "Agent TimeZone", then our code needs to ...
... up a SQL query, or more specifically, a COQL - CRM Object Query Language
Try using distinct on a single-line text field
Adapt the query for unique values in a lookup field
I won't demonstrate ...
What?
A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record.
Why?
A client had added a custom lookup field to the users settings called "Division" ...
...
"proxy": false
}
List of Free APIs with GeoLocation services:
Just append the IP address to the end of these to test.
https://extreme-ip-lookup.com/json/
http://ip-api.com/json/
http://ipinfo.io/js ...
...
Under "Export format", specify any code lookups (eg. for CAP_STAC, we want the code and the lookup value/name and then something to display if the lookup fails: &G[STA.SRS:·|·]&ABLANK="*InvalidCode*|*InvalidCode*", ...
... code and the lookup value in our XML to our Staging environment.
Why?
Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter ...
The Situation
I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet.
The ...
... ...the one users recorded time gets stored in...
Resources
...the one with the codes and resource names...
Users
...the one with users names...
Teams
...another lookup ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.