-
Try this one. Save locally, right click and select design to preview - First Name won't get set because of the user name differences, but you can at least see the results of the user name function and the substring-after function. I also added some row highlighting - do any rows highlight in preview? Publish, open in the browser. Do any rows ...
-
This is a small portion of the data on the list. It was all i could fit on the screen.
-
Drag the list data fields onto your form. Don't filter it. Publish your form. Open your form in the browser. Can you send a screenshot of that data?
-
yes to the first question, yes to them both being lower case. yes to the calculated value question, if i put the list data field on my form and then filter it i do not see anything. The etipton that shows on the screen shot is from me not from filtering. It is just from putting in substring-after(userName(), "i:0#.w|bhate\") as the ...
-
I don't believe what you are trying to do is possible. It would require code, which you can't use in list forms. Multi-selects are special - the field is repeating (if you put your Fields task pane in advanced view, you'll see what I mean).
-
So the substring-after formula results in "etipton". The list has "etipton". Both are all lower case? In the browser, if you put a calculated value on your form with the substring after formula, you get "etipton"? If you put the list data fields on your form, you see "etipton"? Can you post a screenshot?
-
I did the data field and here is step by step what i have been doing. I create a rule condition firstname is blank. Run action. Set Field Value is Firstname. Value= i open my data connection which is employee data in the value field. I select Full Name because that's the column name. I filter the data.
username which is a column name. ...
-
I'm sorry I'm having so much trouble understanding the issue you are having. Perhaps this will help you - put the data fields from your list on the form. Add a formatting rule for what you think should select the right row (i.e. - username = substring-after, etc). Add another for the preview version. Then you can make sure the right row is ...
-
Hi Hilary,
Any updates please , i realy need your help
-
I added the substring-after several times to the formula. When i published it, it still showed nothing when I tried to do a new document in sharepoint. I thought it might be because of the list. So I created another SP list and tried it that way. Once published it would not show up the name even with the substring-after. The filter I have ...