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 ...
... Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and not ...
... is. So we have a workaround, by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which joins the sales orders and ...
... do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code ...
...
TRIGGER=TIME (hh:mm): 24-hour time format at which the system must trigger the reminder. Example: 23:45
Triggers can be given based on due date. For instance, if you want the reminder to be triggered ...
What?
There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks.
Why?
This use-case is ...
... = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection");
//
// build the hash based on the payload body
v_Data = ifnull(m_Payload.get("body"),"");
v_VerifyHash ...
... but the revised instructions here should also help. Then lastly, I'll post the snippet of code using in the widget to connect to Zoho based on a parameter passed in the URL that a Zoho Creator Page can ...
... 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 ...
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.