How to capture the START and END date into a calculation field?
I am trying to pull the data from a date field to the calculation field, Which is having both the Start and End Date. How can I capture both the date from date field to a calculation field?
-
Hi Rainer,
Let me clear again the question.
I have attached 2 images
1. The above image shows both the date after selecting the date field.
2. The above image shows the same after clicking on the date field. (I have attached the 2nd image so you can understand how it looks when its open, where both the date is there Start Date - End Date).
Now my requirement is I want to capture the Start Date and End Date from the "Activity Live Dates" field. I want to show Start Date in the different "Calc" field and End Date in another "Calc" field. I want to show it separately so I can use Start Date only or End Date only when I want to. Is this helpful? Please let me know your concern.
Thanks,
Anup Dhal
-
Hey Anup,
I've to tell you the same as in my first comment. You need a workaround and an additional date field to which you can copy the end date from your field Active Live Dates by a flow. Otherwise you don't have access to the Active Live Dates' end date in a calculation.
Do you have access to the extension Globiflow? To get access you need a Podio Premium Licence ($24 month/user) cause Globiflow is included in the Premium Licence and can't be booked separately. -
Hi Rainer,
Yes, I am having access to globiflow. Can you please tell me how can I separate those dates into 2different fields. So far I am able to collect the start and end date as(25 Nov 2018 - 2 Dec 2018) but there is some situation like.
Situation1: There might be empty(both dates) some time.
Situation2: There won't be always End date selected.
So in the above situation how we will able to select the dates.
If the End date is not selected it should show "Empty or Not Set" in the End Date calc field. Only the Start date should visible in Start Date calc field.
Please let me know your concern.
-
If what you are looking for is to know the number of days that elapsed between the initial date and the final date, what you need is a subtraction between both dates.
The first thing is to have two separate fields, for start date and end date.
Then the calculation field to perform the subtraction:Math.floor((@Final Date - @Initial Date)/86400000) + 1
Unit: Days
-
Hi Anup,
- In Podio: Add a date field to your app and label it "End date" (the field can be always hidden).
- Go to your Globiflow, Account and click "Refresh from Podio" at the bottom of the page
- Create a flow "When item created"
Add a Custom Filter: [Active Live Dates (end date)] != null
Action:
Update this item
Field End Date = Value [Active Live Dates (end date)]
Save the flow. - Create a second flow "When item is updated"
Filter:
If [Active Live Dates] changes
Actions:
IF (Sanity Check) [Active Live Dates (end date)] == null
Update this item
Field End Date = Unset
End if
IF (Sanity Check) [Active Live Dates (end date)] != null
Update this item
Field End Date = Value [Active Live Dates (end date)]
End if
Save the flow - In Podio in your calculation field "Start Date":
var start = @Active Live Dates;
start != null ? moment().format("MM/DD/YYYY") : "Empty or Not Set" - In Podio in your calculation field "End Date":
var end = @End Date;
end != null ? moment(end).format("MM/DD/YYYY") : "Empty or Not Set"
That's it. FYI: [Active Live Dates (end date)] and [Active Live Dates] stand for the field tokens you've to select from the field list in Globiflow. When you have selected them the are added to the brick and turn blue (like the variable tokens in Podio).
Rainer
Please sign in to leave a comment.
Comments
12 comments