Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Category Archives: Uncategorized
Find workflows by name
Ever tried to look through all the folders with workflows searching the one that fails? Know only the name? Use this sql to show you folder names and workflows mathing the name search. select pppf.folder_name as [Folder], ppf.folder_name as [Folder], … Continue reading
Find screens by name
Ever struggled to find the screen called “something” in a tree of folders? This script will give you full location of the screen with all the folders. Just change the name in the where-clause and run this against the HRNET … Continue reading
Find workflows triggered on particular fields
This blog is not dead! It’s been a while since my last post here, but I’m back with some fresh ideas and scripts. Thanks to my new assignment with HR.Net. If you would like to find all the workflow triggers … Continue reading
Find start and end of week and day in SQL Server
Yet another attempt to build up a library of SQL Server functions. As I found out, not all my previous functions did work properly in all environments. — finds start of current week for the provided date CREATE FUNCTION [dbo].[fnStartOfWeek] … Continue reading
Disable Form Validation When Saving Workflow as a Draft
Again, thanks Dan Huston for a great question which was this: Is it possible to distinguish between when a workflow form is being submitted and when the user is saving it to their drafts folder? We have times when the … Continue reading
Posted in Uncategorized
Tagged code, custom script, javascript, Screen, snippet, validation, workflow, Workflows
3 Comments
Validate repeating section
Thanks to Dan Huston for this script. I have not tried it myself, but I trust Dan on this matter. This script is going through all the fields in repeating sections and checks if value is provided. In repeating section … Continue reading
Find screens that edit particular field in a table
As a follow-up from yesterday post about finding workflows that change field in a table, today I needed to find all the screens that contain particular field from a table. Here is the SQL query: select pppf.folder_name as [Folder], ppf.folder_name … Continue reading
Find workflows that change particular table field
Today my task was to find out what workflows are changing particular field within particular table. I could go through all the workflows and all the data-writers and check. But I have hundreds to choose from, I’ll spend all day … Continue reading
Intersting questions and answers
Recently I had a lot of people emailing me and saying “thanks” for the blog, as it helped them out in one way or another. You are welcome! Glad it helps somebody else, not just me. I’ll try to post … Continue reading
Posted in Uncategorized
4 Comments
Determine if record is saved
Sometimes we need to determine in JavaScript if record is already saved or not. You can use this function for this: /** * Check if we are creating a new record, */ function areCreatingNewRecord(){ var record_id = document.getElementById(“hdRecordID”).value; if (record_id … Continue reading