New answers tagged

0

I am checked using JsonObject.has("KeyName") it return boolean. its give true if object contain that keyvalue. so using this method you can make your logic. Thank you very much for reply.


0

The Lookup columns (or any complex datatype like user, multiple select) are not available to Calculated Columns. But (most of) the data is available in the JavaScript ctx.ListData object when the Page is built (I am not 100% sure SP2010 had the full functionality) Type ctx.ListData in the F12 Dev console to explore what is there You can use it in a ...


0

It seems ChildCategory and SubCategory are not required column. So at the time of parsing your JSON, you need a condition. if(ChildCategory.Title && ChildCategory.ID){ } Another option can be $filter. Just $filter null values for ID and Title so that they do not appear in the result. &$filter=ChildCategory/Title ne null and ChildCategory/ID ...


0

Option 1: I am not sure I fully understand the scenario. It almost sounds like you need to build a content type for each department. The content type for each could have a unique choice field with appropriate choices. Option 2: $().SPServices.SPCascadeDropdowns Option 3: https://sputility.codeplex.com/ Hide/Show field on list form based on value ...


0

You can expand the lookup column. https://***/sites/_vti_bin/ListData.svc/List?$select=Title,LookupColumn/OtherColumn&$expand=LookupColumn In this example my list has a column called LookupColumn that looks up a value in another list. This other list has a column called OtherColumn. By expanding LookupColumn in your query you can access the value of ...


0

You have already linked the tasks with sprint ID in Task List, Now you are looking for a way to display each sprint, and underneath each sprint, every task that was completed. So in the Sprint ID lookup field, you have options to select the fields related to sprint > try to select the fields that you need to show with its related tasks like Spring Name, ...


0

The workflow is looking for a Date and Time field, but lookups return text. You need to return the field as Lookup text. Set Variable: lookupStart to Current Item:Lookup: Sprint Start Date, Return fields as Lookup Value (as Text)


0

Lookup column has limitations and it support only below types Single Line text Number Date Date and time Calculated single line text External Data For more information - http://techtrainingnotes.blogspot.com/2012/01/sharepoint-not-all-column-types-can-be.html?m=1


-1

I ended up using metadata navigation and filtering to achieve this.


0

Using PowerShell you can update the lookup list Id $webURL = "http://server/sites/XY" $listName = "MyList" $columnName = "MyColumn" $lookupListName = "Category" $lookupWebURL = "http://server/sites/X" RepairListLookupColumns -webURL $webURL -listName $listName -columnName $columnName -lookupListName $lookupListName -lookupWeb $lookupWebURL Function ...


1

Another workaround is to take the complete site backup. Then restore it in Production as a different site. Then use Content And Structure to move the libraries to proper place.


0

It doesn't look like this is possible. I just tried creating a site column as a lookup field in the site collection root, then I added it to a list in a child site. The field names are correct in the list, i.e., there's no weird appended root site name or ID in the column name for the REST query, but I still get: <m:error xmlns:m="http://schemas....


0

Ok after a bit of work I managed to create a suitable workaround for my problem but any better solutions would be welcome. Cons to this approach - 1.limited number of dates can be pulled through depending on how many spare columns you wish to create 2. only works if you know exactly how long each sub string will be (so is probably only suitable for ...


1

Instead of empty space use blank. Lookup will not display blank values IF(Date>TODAY(), Course, "")


0

Crisis adverted -- apparently it's a bug in SharePoint designer. For anyone else who stumbles across this post, you need to edit the column in your browser and select the additional fields you want to add. Although the additional fields were checked in SharePoint designer and it DOES create read-only columns, apparently Designer doesn't actually link them to ...


0

SharePoint is not a relational database, so this is a bit of a mission, but it can be done. Mark Rackley has a great video tutorial for such a scenario for 2013 and the page contains a link to tutorials for earlier versions. http://www.sharepointhillbilly.com/Lists/Posts/Post.aspx?ID=26 Quoting: So, for those who care more about the “what” than the “...


0

SharePoint treats all "items" as single entities. The only place where you can specify a different behavior for Parent-Child relationships is via the BCS. So you have two options. Write a bit of JavaScript in a Display Template that, when the "Sassy" result is returned it fetches (pun intended) the linked items from the other list. This is pretty trivial ...


0

You can implement this in many ways. Below approach is unnormalized which makes it easy to create views Create a list and name it Team. This list require only the Title field Create a TeamMembers list. This list will have a User field and a lookup field to Team list Create a View and Group by Team - This will show each team and its respective members ...


0

Go to List Settings -> click on your Lookup Field -> check if this setting is set to Title:


2

At the point in your code where you want to get the choices, ctx.CurrentFieldSchema.Choices is an array of lookup choice objects, which each have two properties, LookupId and LookupValue. Here is a screenshot illustrating what I mean: In order to find out what is available to you, I highly recommend setting a breakpoint in your script, and just ...


1

SPFieldLookup_Edit( ctx ); produces the default HTML for an SP Lookup field, you could take that HTML and work it. If you want the individual options you have to dig into the Fieldschema (in your formCtx) SPFieldLookup_Edit is from clientforms.js: function SPFieldLookup_Edit(b) { if (b == null ) return ""; var a = SPClientTemplates....



Top 50 recent answers are included