Re: Default Value Formula Help

fcsech — Thu, 15 Jul 2010 17:14:56 GMT

Works great Jimmy! Appreciate the help

Re: Default Value Formula Help

Jimmy — Thu, 15 Jul 2010 17:04:51 GMT

You're not indicating the field in your substring statements, and they need to be nested in order to do what you want:

substring-before(substring-after(field, '('), ')')

Default Value Formula Help

fcsech — Thu, 15 Jul 2010 15:58:09 GMT

Hi guys, hope you can help. I'm working on a form and I am having trouble coming up with a formula for a default value for one of my fields. What I want the formula to do is only capture a few values/characters based on their position. For example, I want the formula to only capture "4.0" in the following text "EDAM Residents - 8 hours (4.0 cr)", and only "2.0" in "PALS - whole day (2.0 cr"). I've tried the substring function but I need it to start counting from the end becuase every selection is formatted(same # of spaces) at the end and not every instance is the same # of characters. I tried this concat(substring-after("("), substring-before(")") but got:

Expected value type: ,

Actual value: end-of-string
concat(substring-after("("), substring-before(")")<--

-Frank

Controls

Re: Default Value Formula Help

Re: Default Value Formula Help

Default Value Formula Help