Can I set the value of field for a custom list based on which custom form a user chooses?

New developer. Be gentle, please.

Constraints: I am using SharePoint Designer and SharePoint 2010 behind a firewall so I can’t upload pretty much anything without going to my helpdesk and getting a tech person to do it for me.

Situation: We track “Activities”. There are many points of origin for an Activity request. Different clients give us different information and are going to need custom forms (custom new item forms created through SPD). However, all these forms will create new items for the same custom list, “Activity Management”, and I have workflows already in place to create a new Activity Number each time one is created based on a batch of other stuff that is probably not super relevant. All these workflows were designed for only 1 custom form, though.

I need to create a second form and have it not trigger some of my workflows at this time. My idea is to have my new custom New form auto-fill/pre-populate on load/etc a field that identifies which form it is. Then I just have to make a condition at the top of my workflow to not activate for that form. Then we can do it later by changing that field to a value of my choice, now triggering the desired workflow.

I just can’t figure out how to simply set the value of a field within the html of the form – not hiding anything, not making the field a cascading anything, nothing fancy. I have a default inside the SharePoint List Settings that is “No Form” for when I do things manually. Once I figure this out for this form, I’ll imitate it for each custom Change or Activity request. And we can have as many entry points as my bosses need…

Potential Paths to a Solution: Can I do this within table row itself?

               <tr>                     <td width="190px" valign="top" class="ms-formlabel">                         <H3 class="ms-standardheader">                             <nobr>Form Used</nobr>                         </H3>                     </td>                     <td width="400px" valign="top" class="ms-formbody">                         <SharePoint:FormField runat="server" id="ff95{$  Pos}" ControlMode="New" FieldName="Form_x0020_Used"  __designer:bind="{ddwrt:DataBind('i',concat('ff95',$  Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Form_x0020_Used')}"/>                         <SharePoint:FieldDescription runat="server" id="ff95description{$  Pos}" FieldName="Form_x0020_Used" ControlMode="New"/>                     </td>                 </tr> 

Or, maybe there is a really nifty javascript thing that could be used…

<script type="text/javascript" language="javascript">     function setff95() {         Something     } </script> 

SharePoint 2013 – Set column color based on list header

I’ve a unique requirement for one of my lists. In order to make it easier to read I’ve used this css code to alternate the color of the columns.

table.ms-listviewtable td:nth-child(even) { background: #D0E4F5;} 

Now this is great for most of the columns . However I’ve some special columns that need to be different colors (like yellow or green). And due to the views and some other javascript I cannot use something like

table.ms-listviewtable td:nth-last-child(2){ background: lightyellow;} 

Would anyone be able to write some javascript that looks at the column header and then sets the background-color of the column?

So if header contains ‘Total’ color the entire column red.

Thanks

Build 10+ USA Based EDU. GOV Authority Backlinks for Boost Your Google Ranking for $3

Get High Authority USA Based EDU. GOV Backlinks An “Edu and Gov backlink” is simply a link from a public institution (University, High-School, etc) that points back to your page. These websites have a huge authority in real life but also in the search engines. Since authority is transferred in the same manner as Page rank the more quality .edu’s, the better. The process is 100% manual and after hundreds of test orders, it resulted that it’s also 100% safe to be used on any type of website (not like other blog network posts, or mass comments). Your URL will be inserted in the account/profile details, I’m registering a new account on 10 different domains, therefore they would be 100% unique with (other external links) close to none. Some are allowing anchors, others only plain URL, all are dofollow – my intention is not to create a pattern. ©© WHY HIRE ME? ©© ☑Help to Increase website Visibility ☑Help to Increase your site Ranking ☑Friendly with All Search Engine ☑Google Panda4.0 & Penguin 3.0 algorithm ☑Manual work ☑To look as more natural ☑Unique IP Blocks ☑Hummingbird safe ☑Manually created backlinks (no software) ★★★ 24 HOURS EXPRESS DELIVERY ★★★ ©© WHAT I WILL NEED TO GET STARTED? ©© URL Keywords Short Description ★★★OFFER (Limited Time)★★★ Buy 3 Get 1 Free

by: seobroker24X7
Created: —
Category: Link Building
Viewed: 187


Update REST query based to get items from List in SP 2013

I have a query in REST API which is :

var i = _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists/GetByTitle('Pages')/GetItems(query=@v1)?@v1={"ViewXml":"<View Scope='RecursiveAll'><Query><Where><And><BeginsWith><Fieldref Name='ContentTypeId' /><Value Type='ContentTypeId'>Content type value here</Value></BeginsWith><And><Eq><FieldRef Name='FieldNameHere' /><Value Type='Boolean'>0</Value></Eq><Eq><FieldRef Name='SomeFieldName' /><Value Type='Boolean'>0</Value><Eq></And></And></Where><OrderBy><FieldRef Name='SomeField' Ascending='False' /></OrderBy></Query></View>"}"  

As you can see this is a POST call and not a GET call. I need to change this to a GET call since POST is giving me permission related issues, in that the above query will only work for people with Contribute and above level permissions. It won’t work for People with Read Access.

One option I thought would be to use the “items” API query but I’m not sure how I can pass the above Caml Query to it

var i = _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists/GetByTitle('Pages')/items?CamlQueryConditionhere?$  select=Fields.." 

Any Help would be appreciated

SQL Query- field calculation based on date

I’m writing a query for sales targets per week, however I’m getting a little stuck on this. Targets are per month, per year, so for example, Brand A has a monthly target (changes each month)

The snippet from the report is as follows: SELECT BrandName ,SUM((TargetMonThur *4) +TargetFriday) WHERE [MONTH] IN (DATEPART(MM,@DAY1),DATEPART(MM,@DAY2),DATEPART(MM,@DAY3),DATEPART(MM,@DAY4),DATEPART(MM,@DAY5)) AND [YEAR] IN (DATEPART(YY,@DAY1),DATEPART(YY,@DAY2),DATEPART(YY,@DAY3),DATEPART(YY,@DAY4),DATEPART(YY,@DAY5)) However the issue appears when the start of the week/ end of the week is a different month to the other days. at this point, it calculates both month’s targets * 4.

I think I’m being a complete noob on this, but any help would be great.

Thanks in advance

Can I filter a list view web part based on the ID of an Asset Library properties item?

SP OnPrem 2016:

In other applications I have successfully connected list forms and list view web parts to filter the results by ID. The concept is pretty simple.

Now I need to do the same but using an Asset Library properties item as the Source of the ID. From the list view when I try: Connections - Get Filter Values From - My Assets Library, the "Configure Connections" box pops up but it’s empty and I can’t do anything. There are no options to choose.

I tried the same thing in reverse, starting from the Asset Library form and setting up the connection. I get the same results.

Same results in Chrome and IE11.

If I set up a QueryString filter the connection process works, but it doesn’t solve my specific situation.

So I’m thinking there’s some kind of restriction on connecting list view web parts to Asset Libraries, or perhaps with any kind of Document Library.

Can anybody confirm this?

Any ideas?

Thank you

How do I modify weights based on a cost function

I have currently the structure for the simplest neural network. It takes a boolean input and outputs whether it is true or false after training it to know how to tell them apart. I have implemented the structure and have two weights that link to the outputs nodes.

After randomising the initial weights. Inputting true into the network currently returns a 0.7 confidence that it is true and 0.3 for it being false. Giving this a cost value of 0.18 ((1 - 0.7)**2 + (0 - 0.3)**2). How do I then go from the cost function to modifying the weights to give the expected outputs? I am aware of multivariable calculus but I am not sure how it works in this example and how I would program it into the system to modify the dependant weights?