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

Posted in Uncategorized | Tagged , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , | Leave a comment

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

Posted in Uncategorized | Tagged | Leave a comment

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 , , , , , , , | 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

Posted in Uncategorized | Tagged , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , , , | 1 Comment

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

Posted in Uncategorized | Tagged , , | 4 Comments