Thursday, January 4, 2018
Saturday, December 23, 2017
HowTo Using SharePoint Calculated Columns to Display Current Month List Items
HowTo Using SharePoint Calculated Columns to Display Current Month List Items
Today I was asked by a co-worker to see if I could modify their SharePoint view to only show tasks created in the current month. I knew this option was not previously available as a standard choice but I have not done any SharePoint development in years so I was hoping SharePoint Services 3.0 would have added this feature.
After spending a couple minutes in Edit List it was apparent that it was not available. A quick Google search did not produce any "easy" solutions so I thought Id blog my solution.
My solutions involved creating two computed columns (both calculated columns return Date Only values):
- Created First Day Of Month
=DATE(YEAR([Created]),MONTH([Created]),1) - Created Last Day Of Month
=DATE(YEAR([Created]),MONTH([Created])+1,1)-1
I then added the below filters to view:
Thats it. Basically I create a computed column for the first and last day of the month when the task was created and then filter by todays date being between the two. I found this to be an easy and quick method. Please comment and let me know if there is an easier method.
Monday, December 18, 2017
iLogic Dynamic MultiValue Parameter Lists Filtered By Current Selected Value
iLogic Dynamic MultiValue Parameter Lists Filtered By Current Selected Value
Issue:
You want to "filter" a list (List B) based on the selection from another list (List A), but the lists are long and writing the If/Then or Select Case statements are repetitive, and difficult to maintain. Is there a better way?
Solution:
You can use ArrayLists and For Each Statements to do this, as shown in this example.
Here an illogic form is used, and when a value is selected from List A, then List B and C are reset to include only values less than or equal to the current selected List A value.
Example file:
Dynamic MultiValue Lists iLogic 2015.ipt ?68 KB
Example code:
reset List B list to default
MultiValue.SetList("List_B", 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)
reset List C list to default
MultiValue.SetList("List_C", 2,4,6,8,10,12,14,16)
Dim B_List As New ArrayList
B_List = MultiValue.List("List_B")
Dim C_List As New ArrayList
C_List = MultiValue.List("List_C")
Dim Temp_List As New ArrayList
Temp_List.Clear
For Each oItem in B_List
If List_A >= oItem Then
Temp_List.Add(oItem)
End If
Next
MultiValue.List("List_B") = Temp_List
Temp_List.Clear
For Each oItem in C_List
If List_A >= oItem Then
Temp_List.Add(oItem)
End If
Next
MultiValue.List("List_C") = Temp_List