What?
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 ...
What?
An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone.
...
... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...
Applies to
Transact-SQL (T-SQL)
What?
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Why?
I have a table that ...
... of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set.
Something like:
The DataSet
This should ...
... based on its identifying number (allows other attachments to remain intact)
Generate the file
The code here is a cut down version just to demonstrate generating a text file and storing this into ...
... == c_Order.Order_Date,c_Order.Order_Date.toStartOfWeek().subDay(1),c_Order.Order_Date.toStartOfWeek()).toString("w");
Additional:
I'm just adding a little extra based on the further feedback, if ...
What?
If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...
... Only generate invoice if payment received
- Distinguish whether composite based on ebay item specific
- Add stock in order to authorize payment creation
Date Modified: 2023-02-02 (Joel Lipman)
- ...
... or that has been added to the system based on the business hours set at the organization level in ZohoCRM.
How?
Using an invokeURL, the key here is you'll find them in the settings; so check that ...
... and then I'll include the code to query the shipment status based on a tracking number.
Becoming a DHL Developer
Browse to https://developer.dhl.com/user/register to Signup
Complete the form with ...
...
Previous Models/Versions
Based on the documentation: In the above code, you would change the model value to one of the following
code-davinci-002 (optimized for code-completion tasks)
text-davinci-002
text-davinci-003
gpt-3.5-turbo ...
... browsing to https://platform.openai.com/account/billing/overview. At time of print, the paid plan is a pay as you go or pay as you use.
Previous Models/Versions
Based on the documentation: In ...
... records
The below snippet is what I used to bring all the past records into the custom module. The client would be able to determine what jobs have started/expired based on their Candidate reference ...
... client script which will manage a subform.
The module we are applying this client script to is a custom module called "Deployments". The field which triggers it is called "Which_rate_card_is_this_based_off". ...
... to generate meaningful reports.
The first dataset should be just the profit per item based on what was purchased. I'm including the Purchase Order ID so that I can refer to it later for shipping ...
... deals against a deal owner and needed to repeat this for all the invoices against a sales person.
It adds to the effect on loading the page that a widget has clearly defined values based on the filters ...
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 ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
...
At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen.
You could try adding a subform to Creator ...
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.