tag:blogger.com,1999:blog-2449128028642934343.post6751741005341786181..comments2023-08-24T12:59:57.206+01:00Comments on How I did it - Sharepoint: Filtering lookup columnsAnonymoushttp://www.blogger.com/profile/12644018449589566949noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-2449128028642934343.post-78176737354331943262013-04-25T19:46:16.442+01:002013-04-25T19:46:16.442+01:00Hi Pedro,
Do you have any inputs on how to filter...Hi Pedro,<br /><br />Do you have any inputs on how to filter a list column using Javascript? My client wants to filter a report (that is pulled from a list), based on one of the columns of a list !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-54467705819579564312013-04-23T17:15:32.768+01:002013-04-23T17:15:32.768+01:00Hi Pedro,
Is it possible to use a list box control...Hi Pedro,<br />Is it possible to use a list box control, instead of a drop down list, and set it up to allow multiple values? The Heglershttps://www.blogger.com/profile/11799527039942142144noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-3859081919307822602013-04-18T21:48:16.981+01:002013-04-18T21:48:16.981+01:00I've almost got it working. I was also trying ...I've almost got it working. I was also trying to "allow multiple values" and couldn't figure out how to do it. <br /><br />I have a list for issues where I want to have one or more related tasks from another list. I only want the choices to show tasks that have not been completed. It is possible to have multiple tasks related to one issue. So I want it to look like the Predecessors field on the standard task list. <br /><br />Thanks for any help you can give. Cheers.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-29572525209773727572013-04-17T09:31:03.128+01:002013-04-17T09:31:03.128+01:00If you don't have any way to access the data f...If you don't have any way to access the data fields you could achieve the same using javascript and webservices.<br /><br />I've been using javascript to filter the dropdown list options, also. Yet it turns to have some problems in clientes machines where the internet security is set to very high.<br /><br />I'll try to post today a new article showing how to do the same filtering using javascript.<br /><br />Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-91297043712955401162013-04-17T09:27:39.713+01:002013-04-17T09:27:39.713+01:00Hi, by the way you describe the issue. It might be...Hi, by the way you describe the issue. It might be something in the databinding in the New Form. Could you please send me screenshot of it?Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-15031966496333417642013-04-12T03:38:47.664+01:002013-04-12T03:38:47.664+01:00Looks promising but when I go to add the SharePoin...Looks promising but when I go to add the SharePoint control (drop down list) I can't. The HTML and ASP.Net controls work fine, but not the SharePoint one, any ideas?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-25601206821098260912013-04-11T21:24:11.377+01:002013-04-11T21:24:11.377+01:00So I said this worked perfect, but that was for th...So I said this worked perfect, but that was for the New Item form. When i do this to the edit form, it doesn't retain what was selected when I created the item. It's blank... any ideas?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-42808433667106143622013-04-10T19:02:57.660+01:002013-04-10T19:02:57.660+01:00This worked perfect! I played with jquery all day...This worked perfect! I played with jquery all day long... this took 2 minutes!!<br /><br />Thank you soooo much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-26899105853552579732013-03-28T14:07:17.507+00:002013-03-28T14:07:17.507+00:00Thank you for this!!! I've almost got it worki...Thank you for this!!! I've almost got it working the way I need...but I can't figure out how to allow for multiple selections on the newly-added dropdown list. Is this possible or is there a different control I should be using to mimic the standard selection list boxes? <br /><br />By the way, I'm using 2007 and you were right that the steps you listed translate from 2010 - though everything is in a different place or under a different menu obviously :-)<br /><br />Once again, thanks!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-92010663083294736192013-03-12T17:12:51.550+00:002013-03-12T17:12:51.550+00:00Hi, I opened a sharepoint online (365) site on SPD...Hi, I opened a sharepoint online (365) site on SPD and when I select the dropdown the right arrow and the option Data Fields are not showing. Maybe because I'm using SP Online?<br />There is another way to configure the data field?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-61111016017367539322013-03-07T21:41:31.006+00:002013-03-07T21:41:31.006+00:00Excellent! thanks! works great!Excellent! thanks! works great!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-31232195073659349012013-03-07T18:14:41.584+00:002013-03-07T18:14:41.584+00:00Hi, that's true I've managed to solve it i...Hi, that's true I've managed to solve it in this post: http://howididit-sharepoint.blogspot.pt/2012/08/removing-html-tags-drop-down.htmlAnonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-27974087981556955372013-03-07T15:19:26.069+00:002013-03-07T15:19:26.069+00:00Hi,
I gave this a try and for the most part it wo...Hi, <br />I gave this a try and for the most part it works great. My only issue is when I go back and edit a record that has a value that was active and now is not.<br />Using your example, I have a record that has List1/Item1<br />Now List1/Item1 is inactive. When I edit the record I thought the dropdown would only have the active values but instead it has the <a onclick="OpenPopUpPage('http://Mysharepoint/page/_layouts/listform.aspx?PageType=4&ListId ..... as the first choice then the correct choices. Could I be doing something wrong? thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-22271296879157182352013-02-13T09:29:34.617+00:002013-02-13T09:29:34.617+00:00Hi Joshua, nice to see you here.Hi Joshua, nice to see you here.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-29154451194902391962013-02-12T22:03:17.443+00:002013-02-12T22:03:17.443+00:00My solution was in the previous post. My solution was in the previous post. Anonymoushttps://www.blogger.com/profile/01903009077661838998noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-14544193884579288272013-02-12T21:48:37.088+00:002013-02-12T21:48:37.088+00:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/01903009077661838998noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-31195995476742880452013-02-12T13:18:42.626+00:002013-02-12T13:18:42.626+00:00Hi Mani, take a lookup at this article http://howi...Hi Mani, take a lookup at this article http://howididit-sharepoint.blogspot.pt/2012/08/removing-html-tags-drop-down.html.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-72808617789386607712013-02-12T12:08:16.521+00:002013-02-12T12:08:16.521+00:00when you edit current inserted record how to set l...when you edit current inserted record how to set lookup field,Because i set these fields but getting hyperlink on it… if you have any solution about that problem post the comment…Anonymoushttps://www.blogger.com/profile/10652619284465907310noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-45373053242155077552013-01-30T19:34:43.967+00:002013-01-30T19:34:43.967+00:00Welcome Patur, glad you stopped by.Welcome Patur, glad you stopped by.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-23374061772725708682013-01-29T09:34:12.326+00:002013-01-29T09:34:12.326+00:00Hi Pedro
Thanks for posting this - works great!
I...Hi Pedro<br /><br />Thanks for posting this - works great!<br />I'm looking forward to dig into the rest of your posts ;)<br /><br />Best regards,<br />PaturAnonymoushttps://www.blogger.com/profile/05142277027914603601noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-2817500838876269982012-12-13T11:22:23.657+00:002012-12-13T11:22:23.657+00:00Great, this is exactly what I was after. Worked pe...Great, this is exactly what I was after. Worked perfectly for me (using SPF 2010) thank you very much indeed for posting!! Anonymoushttps://www.blogger.com/profile/05414786554090237349noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-17329669005968218352012-08-23T11:45:50.835+01:002012-08-23T11:45:50.835+01:00Ok, I've tried this in Edit Form and it worked...Ok, I've tried this in Edit Form and it worked like a charm, can you give me more details about your case.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-40100239373159863472012-08-20T09:19:37.689+01:002012-08-20T09:19:37.689+01:00Hmm ... let me take a look at it. I'll return ...Hmm ... let me take a look at it. I'll return soon.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-37487309262132144812012-08-11T05:16:24.820+01:002012-08-11T05:16:24.820+01:00This works excellent, however when I use this on t...This works excellent, however when I use this on the Edit form I get an error: "An unexpected Error has occured.<br />Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator."Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2449128028642934343.post-7158631993428444062012-05-02T18:04:13.418+01:002012-05-02T18:04:13.418+01:00Hi Michael, thanks for stoping by.
Saddly can'...Hi Michael, thanks for stoping by.<br /><br />Saddly can't try if it works on Sharepoint 2007, but it should. The function Copy and modify a data source should also be available in Sharepoint Designer 2007.Anonymoushttps://www.blogger.com/profile/12644018449589566949noreply@blogger.com