Tag Info

New answers tagged

0

This sounds more like a timer job should be made - that way the job can be managed via Central Admin. A workflow might work, but a timer job is more likely the correct way to update a field on a schedule.


4

If you only use this for display purposes, why not use a different approach which does not require you to do updates on the list item at all.... Create the site column in a sandboxed solution. Your column stores the Due date. Create a javascript file to deploy somewhere to your site, e.g. /Documents/duedate.js Configure the JSLink property in the site ...


1

I don't have enough Rep to comment on the other answer but Calculated fields are updated at SAVE time. Your Javascript idea could work if users viewing the list have permissions to update the items, otherwise it might update, or might not update. Since you don't have SPD you don't have many other options but you can try designing a reusable workflow in ...


1

Interesting friday evening challenge.. I took a completely weird approach process every row (when displayed) store the High, Low , Total and Average value on the body tag for every row done (they proces async) calculate the 3 segments (low,medium,high) between the Low Values calculate Average, match with low,medium,high color and color the Table (4 ...


0

I created a column - "Creator" - Person/Group In the sharepoint designer, I made a "When new item is created" workflow to update the "Creator" as "Created By".


1

Caluclated Columns will be calculated each time they are displayed. You don't have to update items. :-) The problem is your formula. Why do you try to convert it to INT? SharePoint has very nice Calculated Field Formulas, see http://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx A working example would be: ...


0

Instead of creating a calculated column with the same data in text format, you can use Client Side Rendering and JSLink to create javascript Date objects for each Modified column value and format the date to your preference such as var modified = $(selector).text(); var date = (new Date(modified)).format("MMMM dd, yyyy");


1

You're using TEXT, which makes it un-sortable. You'd have to be using =DATE(MONTH(Modified),DAY(Modified),YEAR(Modified)) or similar. I doubt you can get the behavior you're looking for with the 'long month' without setting all your dates to this format (regional settings).


0

You can still sort by the Modified field, which is indexed and very well suitable for sorting.


1

Similarly, I was asked to set a field as the "Second Thursday of Next Month." Using this post as well as some other tricks I already know, I was able to come up with a formula (shared if other users get the similar request): =DATE(YEAR(Today),MONTH(Today)+1,(5-MOD(WEEKDAY(DATE(YEAR(Today),MONTH(Today)+1,1)),7)+8)) Because you aren't adding the values to ...


2

In english version of SharePoint it can be done with this: =MID("Hello(ABC)", 7, 3) There is a nice article: http://yalla.itgroove.net/2012/09/sharepoint-calculated-column-formulas/ A dynamic version would be =MID("Hello(ABC)", SEARCH("(","Hello(ABC)")+1, SEARCH(")","Hello(ABC)")-SEARCH("(","Hello(ABC)")-1)



Top 50 recent answers are included