Post

5 followers Follow
0
Avatar

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?

Anup Kumar Dhal

Please sign in to leave a comment.

12 comments

0
Avatar

It's not possible to get that end date in a calculation field. You need a workaround with Globiflow. Add another date field (start date only; can be always hidden) and a flow which copies the end date from the main date field into that hidden date field.  

Rainer Grabowski 0 votes
0
Avatar

Hi Rainer,

Can you please describe more how can we capture both the Date separately in the different calc field.

 

Thanks Regards,

Anup Kumar Dhal

Anup Kumar Dhal 0 votes
0
Avatar

Hi Anup,

sorry, but I don't understand your question. Maybe you can describe what you want to achieve and which format the captured date should have (displayed as text like 21/11/2018 or Wed 11/21/2018 or should it look like the "normal" date field)?

Rainer

Rainer Grabowski 0 votes
0
Avatar

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

Anup Kumar Dhal 0 votes
0
Avatar

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. 

Rainer Grabowski 0 votes
0
Avatar

Hi Rainer,

How are you doing?

Did you get any solution for my last message?

 

Thanks & Regards,

Anup Kumar Dhal

Anup Kumar Dhal 0 votes
0
Avatar

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.

Anup Kumar Dhal 0 votes
0
Avatar

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

 

Sergio Pérez Jaramillo 0 votes
0
Avatar

Hi Anup,

  1. In Podio: Add a date field to your app and label it "End date" (the field can be always hidden).
  2. Go to your Globiflow, Account  and click "Refresh from Podio" at the bottom of the page
  3. 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.
  4. 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
  5. In Podio in your calculation field "Start Date":
    var start = @Active Live Dates;
    start != null ? moment().format("MM/DD/YYYY") : "Empty or Not Set"
  6. 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

Rainer Grabowski 0 votes
1
Avatar

I can not believe that a simple feature like that it is not yet implemented on platform. People are asking for this feature since 2015 and Podio Team simply ignores it. Unbelievable.

Elias Fernandes 1 vote