I have two SP lists: Partner and Request.
Partner just has a Partner Name column, plus the ID column.
In Request, I have a lookup column pointing to the Partner list. There is also a Title column and a Request Date column. When I set up the lookup I set it to get info
from the Partner list’s Partner Name column, not the ID column.
I made an InfoPath form to make a new Request, with the Partner being selected from a Drop-Down List Box. When this form is submitted, I would like to change the Title
field to be a string concatenation of Partner Name, a comma, and the Request Date. I made a rule to do this. Example of what I want: “Partner A, 8/27/2010”.
However, the result is that the Partner ID is used instead of the Partner Name and what I get is “1, 8/27/2010”.
(More: In production I would use the Form Submit rule to do this. For development I used a rule that runs when the field changes. If I change the Drop-Down List Box
properties Value property (on the data tab) from d:ID to d:Title the string is formatted as desired, but the form won’t submit and shows a tooltip that only positive integers are allowed.)
How can I make the rule use the Partner Name column in the formula for the rule, instead of the ID?
View Complete Post