Assuming staff is required, the following 46 results were found.
-
the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
for each r_Service in l_Services { if(!isnull(r_Service.get("id"))) { v_ServiceName = r_Service.get("name"); } } Get the staff: // // get staff r_StaffResults = zoho.bookings.getRelatedRecords("Staffs","Services",v_ServiceID,"joels_connector"); l_Staff...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl [ url:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// delete any tasks that were transferred from the lead record relating to reminding staff to convert the lead. // l_RelatedTasks = zoho.crm.getRelatedRecords("Tasks", "Contacts", p_ContactID); for each m_RelatedTask in l_RelatedTasks {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
is a fair bit of coding, you may want to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use the example of a credit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff we have elevated privileges but not absolute rights to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ',...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
"00" ; Background image to change to during the running of this program DesktopBackgroundImage1:="\\bournemouth.ac.uk\data\Staff\Home\jlipman\My Pictures\byeBU\byeBU_byPChristopher.bmp" ; Background image to revert to once program ends...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
it does the same damage, regardless of your reasons for breaking it, and you will be punished all the same. Amendment 2 - Staff abuse will not be tolerated. As a staff member, your job is to help the people, not harm them. You may only use your powers...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
custom app. Why? My use-case scenario here is that we have a Zoho Creator app which comprises of a custom quote builder that staff use to store details about a product, and then to push that product out to their Shopify store with a pre-built...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system but important to some staff... How? In an earlier article, I've shown how to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
third was using Mozilla Firefox. We told them to go back to the template providers and report the same problem to them...??? Staff member requiring access to a secure application "So that's all installed for you. I just need you to restart your computer...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
the list with the selected item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave Requests, Qualifications and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
interface as per an agreed template. Back-end administration interface for managing the website (GUI based for non-technical staff. Web-based for remote working.) JoelLipman.Com will create 2 development sites ("play" sites) which the project manager...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *