This will show you how to change the text label inside a div on the page based on another string on the page. First it’s getting all Div elements and then looking into the innerHTML for the word “open”. If its found change the background to red – this is used to help figure out […]
Validation Scripts – RegExr
Here are a selection of RegExr validation scripts to use with error messages. Correct Email format Checks to see if a email address has been formatted correctly if(!IsEmail(f(CurrentForm()))) { RaiseError(); SetQuestionErrorMessage(9,”Please provide a valid email address.”); } Correct Telephone format Checks a open question has 11 digits without spaces, i.e Phone number […]
Merge string and respid
Merging a string with the respid of the respondent to create a unquie ID which is targetable by a survey, email or reportal report. Create a new DP rule and select the survey and add in a filter, the field we are populating will be “userid” so make sure this field is empty using the […]
Dynamically Change Pivot Table Source Data
Dynamically Change Pivot Table Source Data This is a handy bit of code which will save you having to update the source range of a pivot table each time new data is added to the table. In this example I have a data sheet called “Data”. Each month new row’s are added to the table. […]
Question Validation Codes
Date picker, has to be X days in the future from today Exact date is a picker for the user, change anything in bold to fit your needs var a = f(“exact_date“).toDate(); var today : DateTime = DateTime.Now; var todayPlus7 : DateTime = today.AddDays(7); if(a < todayPlus7) { RaiseError(); […]
Button to save sheet as PDF
Save Sheet as PDF Create a new Button on sheet “Save as PDF” for example and attach the following code to it. Open the Developer tab – Click here to see how to, we use this tab allot. – The starting point Change – Sheets(Array(“SheetName“)).Select – To be the name of your sheet – Sheet1 – Export […]
Confirmit
Confirmit Horizons Manage the Complete Market Research and Voice of the Customer Lifecycle The Confirmit Horizons platform provides you with everything you need for end-to-end management of Voice of the Customer programs, Voice of the Employee programs, and Market Research projects. Confirmit powers Global 5000 companies and Market Research agencies worldwide with a wide range […]