Assuming given is required, the following 76 results were found.
-
if(m_OrgDetails.get("business_days") != null) { // // let's format a little as the business days are given in the correct order m_ShiftRow = Map(); m_ShiftRow.put("open","00:00"); m_ShiftRow.put("close","00:00"); m_ShiftBuildUp = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the subform: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a color picker. Pre-amble: Create a Zoho Creator form Create a form, I'm calling mine "Color Picker" Add a note field, I've given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
eld":{"api_name":"name","json_path":"$.tags[0].name"},"api_name":"color_code","json_path":"$.tags[0].color_code"},"message":"Given tag present with different colour already.","status":"error"} -> Error was due to someone already giving tags with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-"); m_CrmContact.put("Last_Name",v_CrmContactLastName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-"); m_CrmContact.put("Last_Name",v_CrmContactLastName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the rest of the elements scroll about. Go to Extensions -> Template Manager> Edit the CSS for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: -- SAMPLE DATES ARE: -- -- 2012-04-27 10:00:00 -- is a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg....
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF