Mark Williams

1. Community
2. SchemeServe Answers
3. How can I change a field to Upper/Lower Case in my rating matrix?

Brian,   Try this: [QuestionName_Value].ToUpper().Replace(' ', '') This will convert lower case alphanumeric characters to upper case and remove spaces. Just remove the .Replace(' ', '') if you jus...

• View comment
• Mark Williams
• Created 02 April 2012 16:49
• 0 votes

1. Community
2. SchemeServe Answers
3. How can I change a field to Upper/Lower Case in my rating matrix?

I'll save em up Brian :)

• View comment
• Mark Williams
• Created 04 April 2012 14:54
• 0 votes

1. Community
2. SchemeServe Answers
3. How do I use "Inception Date" and "Expiry Date" in a report formula

Thanks Colin, should I raise this as a feature request or is it being looked at already? Cheers. Mark

• View comment
• Mark Williams
• Created 24 February 2012 17:29
• 0 votes

1. Community
2. SchemeServe Answers
3. Has anybody manged to extract the component parts of the ClientName & ClientAddress Fields?

Hi Brian, not sure on the Client Name but Client address works as follows (CorrespondenceAddress is the question name): [CorrespondenceAddress_AddressLine1_Value] [CorrespondenceAddress_AddressLine...

• View comment
• Mark Williams
• Created 12 February 2012 22:50
• 0 votes

1. Community
2. SchemeServe Answers
3. Has anybody manged to extract the component parts of the ClientName & ClientAddress Fields?

I would try Firstname, Lastname and Title i.e. if your field name was ClientName then access these by using: ClientName_FirstName_Value ClientName_LastName_Value ClientName_Title_Value Let me know ...

• View comment
• Mark Williams
• Created 16 February 2012 10:29
• 0 votes

1. Community
2. SchemeServe Answers
3. Has anybody manged to extract the component parts of the ClientName & ClientAddress Fields?

We also use postcode lookup and Client.Address fields and it works for us. Let me know how it goes.

• View comment
• Mark Williams
• Created 16 February 2012 00:43
• 0 votes

1. Community
2. SchemeServe Answers
3. What are the criteria for the 'At a glance' reports?

I would like some info on this too. The amounts shown on the "At a Glance" graphical reports do not tie up exactly with our reports. It could be that cancellations/MTA's are not included but may be...

• View comment
• Mark Williams
• Created 22 February 2012 00:03
• 0 votes

1. Community
2. SchemeServe Answers
3. Using _Cover within IF statements on Adjustment documents

Thanks for that Pete but it does not entirely answer the question. I need to be able to ascertain the total SI within an IF statement (The original plus any adjustments) as shows when used outside ...

• View comment
• Mark Williams
• Created 03 February 2012 13:00
• 0 votes

1. Community
2. SchemeServe Answers
3. Using _Cover within IF statements on Adjustment documents

Thanks Pete. Shall I raise this as a feature request or ticket? Are there any plans to make this work? Cheers. Mark

• View comment
• Mark Williams
• Created 03 February 2012 13:56
• 0 votes

1. Community
2. SchemeServe Answers
3. SchemeServe API

On the subject of the API, it would be extremely useful if there were a guide I could look at. The feature is of great interest but I don't know where to start. Cheers. Mark

• View comment
• Mark Williams
• Created 31 January 2012 17:59
• 0 votes