Forum Replies Created
-
Posts
-
Hi Alexander
The key that links them together is the Welder’s name. Would that work or should I specifically add something in ?
Iain
Hi Alexander
Thanks for getting back to me.
What I was looking for was the option of a person being able to allocate their time over the course of a day against tasks that they are working in – min 15 minute increments.
For example, I work on a project with 5 tasks.
On Monday I work on Task 1 for 8 hours.
On Tuesday, I work on Task 3 & 5. 2 hours on Task 3 and 5 hours on Task 5.
So I would need something like Mon – Sunday across the top with the ability t o add rows that I can pick the project, task and then enter the hours on the day.
Could this be done in DFFS ?
Iain
I came across this solution that works nicely:
Iain
Hi Alexander
Thanks for the feedback.
I was looking at workflow notification.
This is what I have so far, but it is not working.
What I am essentially trying to do after an items is added to SharePoint, is send a reminder to the author that they have 30 days left before the report is due.
Iain
Attachments:
Hi Alexander
Date Sent – Final
is equal to
<blank>Field name is Date_x0020_Sent_x0020__x002d__x00
Iain
Hi Alexander
Thanks
I am just using the static filter built into the list view – field is not equal to blank etc.
Iain
Hi Alexander
That is an awesome fix and good to use for all my views.
The issue with this is that it gives you the total items in the whole list, not by the sorted list I have in place – so I got 116 items, but there are only 335 in this current list as it is filtered to show those items without a certain date being completed – is there a way to do that ?
Iain
Hi Alexander
Just to keep it simple, what about having the Avg Days Late plus the total count, so I can get rid of the SharePoint default and keep everything on one line – see image
Iain
Attachments:
Thanks Alexander – I will think of something where I can have two or more that I need to show.
One last question – how can I make the Average Days number two decimal places ?
Iain
Hi Alexander
That was perfect – this worked just great.
Do you know if it is possible to have two or three measures like this side by side ?
Many thanks for turning around a working solution.
Speak to you soon.
Iain
Hi Alexander
Thanks for the reply.
Yes, I am using SharePoint 2013.
Found the error – it does not like the calculated column – see image.
Iain
Attachments:
Many thanks Alexander.
I have added – now nothing shows up.
I tired in both a Script Editor and Content Web Editor.
Not sure why it is not showing up now – any ideas ?
Iain
Hi ALexander
This is exactly what I was looking for – having an issues getting it to work. I am getting an error.
Here is the code
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js”></script><script type=”text/javascript”>
setTimeout(function(){
(function(){
jQuery.ajax({
“url”: _spPageContextInfo.webServerRelativeUrl+”/_api/web/lists/GetById(‘”+_spPageContextInfo.pageListId.split(/{|}/).join(“”)+”‘)/items?$filter=MOC_x0020_Number”,
“type”: “GET”,
“contentType”: “application/json;odata=verbose”,
“headers”:{
“Accept”: “application/json;odata=verbose”,
“X-RequestDigest” : jQuery(“#__REQUESTDIGEST”).val()
},
“success”: function(data){
var totItems = data.d.results.length, totDays = 0, avgDays = 0;
jQuery.each(data.d.results,function(i,item){
totDays += Number(item.Days_x0020_Taken);
});
avgDays = totDays / totItems;
jQuery(“table.ms-listviewtable”).before(“<div style=’color:green;font-size:22px;border:1px #cccccc solid;padding:3px;’>Average days: “+parseInt(avgDays,10)+”</div>”)
},
“error”:function(err){
console.log(err);
}
});
})();
},1000);
</script><br/><br/><br/>I get the Average Days above with NaN
Any ideas ?
Iain
Hi Alexander
Please see attached screenshot.
In the example I am working on, I have a number of packages which I can do a count on. I also created a day count between the date received and date uploaded – as that is a calculated field, I cannot add an Avg to it.
From there, what I want to be able to do is show the Average Days it takes to turn a package around.
If this is not clear, please let me know.
Appreciate the help
Iain
Attachments:
