11 reputation
2
bio website
location
age
visits member for 1 year, 10 months
seen Nov 23 '12 at 22:32

Feb
10
awarded  Popular Question
Nov
23
asked Can a workflow on one list update fields in a linked (joined) list?
Nov
7
comment Joining two lists in a single view or edit form
BTW I did some testing and the Title field does work in the connection (which helped me a lot to understand the problem, so thanks for that!) but as I suspected, a duplicate title causes multiple matches to turn up in the second list. See above for the solution, it needs to be a numeric ID connection, but NOT stored in a lookup column!
Nov
7
answered Joining two lists in a single view or edit form
Nov
6
comment Joining two lists in a single view or edit form
BTW I did consider using one list (and I may have to go back to that idea). Issues I forsaw were- 1) Column level permissions. Only Reviewers shoudl be able to edit Review fields. 2) Maybe i'm wrong but my understanding of content types is that each list row can only "be" one content type. So, if I create a row as a Request, I can't subsequently mutate it into a Review and work on the columns that would only exist in a Review. Have I misunderstood that?
Nov
6
comment Joining two lists in a single view or edit form
In theory there is no guarantee that Request titles will be unique, that's why I went for database-style ID lookups, they seemed safest (maybe I was naiive about SP oddities). The "additional fields" feature in SP2010 is pretty strange BTW, because it only offers you a small subset of the fields from the "other" (joined) list. If you could pull across all the fields from the Request as columns in Reviews I wouldn't need to try this procedure of joining lists on the page.
Nov
6
comment Joining two lists in a single view or edit form
BTW on the second point, as I understand it SP doesn't do column-level permissions, so this is effectively a way to work around that.
Nov
6
comment Joining two lists in a single view or edit form
Sounds interesting, but- 1) Seems weird that SP lists can't consume filter values from other SP lists? 2) "Actions" are new to me. Do I need to trigger a workflow to use them? If i'm looking at a single page in edit mode, I assume an action won't be triggered until the page is saved? 3) The required value (3 in this case) is only the 4th character if the Request ID is 1 character wide. In general list IDs can grow indefinitely, so I would need to use something like a regular expression to extract "All the digits up to but not including the first non-digit". Not sure if Sp can do this?
Nov
6
comment Joining two lists in a single view or edit form
I had a couple of reasons for using two lists- 1) Simplicity. When entering a Request the users see a simpler form, without any of the Review fields they don't need to see. 2) Permissions. Although I haven't got that far, the idea is that only Reviewers will be able to edit the Reviews list fields. (Note there's a question in my mind about the permissions of the workflow that creates the Reviews entry when a Request is created, but I haven't got that far yet).
Nov
6
answered Can i filter folders to show on different views
Nov
6
awarded  Student
Nov
5
asked Joining two lists in a single view or edit form