- Add a Validation rule.
- Under Condition choose The expression from the drop down.
- Paste in the following expression (replace 60 with the number of words you want to limit it to):
string-length(.) – string-length(translate(., ” “,””)) > 60
string-length(.) – string-length(translate(., ” “,””)) > 60
In InfoPath, under Fields, Right Click on the single line of text field and choose Field Properties.
Under the Default Value section click the “fx” button beside the blank field.
To extract the day number of a date, use
number(substring(field1, 9, 2))
To extract the month number of a date, use
number(substring(field1, 6, 2))
To extract the year number of a date, use
number(substring(field1, 1, 4))
where field1 represents a date picker control or the function of today() to pull any of those from today’s date.
Under Fields, Right Click on the field and choose Field Properties.
Under the Default Value section click the “fx” button beside the blank field.
To force the field to be upper case put in this formula:
translate(., “abcdefghijklmnopqrstuvwxyz”, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”)
To force the field to be lower case put in this formula:
translate(., “ABCDEFGHIJKLMNOPQRSTUVWXYZ”, “abcdefghijklmnopqrstuvwxyz”)
In InfoPath add a hyperlink (under the INSERT tab)
Under link to click Data Source.
Click the data source icon
– Click Show advanced view at the bottom
– Click the “+” next to dataFields
– Click the “+” next to my:SharePointListItem_RW
– Click the “+” next to Attachments
– Click on :attachmentURL
Click OK
Beside Display choose whatever text you would like it to display.
Click OK