-
Okay, that helps... when you see the exact formula, usually that means you didn't enter the formula in the formula editor window. You need to click the fx button and put the formula there...
-
I do understand what you want. I don't understand why the formula you are using doesn't work, or how it doesn't work. Can you please tell me what results you get from that formula?
For example, if I use that fomula in an expression box on a form, I get the result:
daily status report - 2008-12-04
Now, I don't know off hand if ...
-
What is your formula? What is the result it is generating?
-
Does your formula generate any results? That is, are you getting a file name, just not the one you expected? Can you try using a static value for testing in the file name and verify that the form submits correctly? Does the name have any characters that SharePoint doesn't accept?
Sometimes I put an expression box on the form with the same ...
-
You bet. On your reason_field, you can set data validation. The conditions could be check = false and reason_field = blank. This would highlight the reason_field control with red and provide error warnings of your choice.....
-
I believe the sample in the blog post is in jscript -- it looks as if you are using VB.NET. You may want to change the programming language in your form to JScript, then try the sample.
To change the programming language, you'll need to go to Tools/Form Options. Select Programming and click the Remove Code button. Then change the language to ...
-
Well, translate() is a character for character type of thing, so that won't work.... Can you add another field to your data source? If so, you could use a rule on the text field to set the value of your 'helper' field to the appropriate number, then use your 'helper' field for your filter.... so your rule would have conditions, ...
-
You are missing the concat:
concat(substring-after(now(), "T"), " ", userName(), DAY_TEXT_1.0)
-
Actually, I think Anuma meant that if the field in your database is smaller than the amount of characters typed into the field on the form, the form information will be truncated on submission to the database. I don't know of any character length restrictions, unless you set one on a control, via its properties or data validation....
-
You could change your initial textbox (with the value of FL, GA or PR) to a drop down list. Your 'Display' text could be FL, GA or PR, and your 'Value' could be the corresponding number that is correct for that field...Then when the user selects 'FL' the actual field value would be 1 and you'd be able to filter with ...