How to capture the START and END date into a calculation field?

Comments

12 comments

  • Rainer Grabowski

    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.  

    0
    Comment actions Permalink
  • Anup Kumar Dhal

    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

    0
    Comment actions Permalink
  • Rainer Grabowski

    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

    0
    Comment actions Permalink
  • Anup Kumar Dhal

    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

    0
    Comment actions Permalink
  • Anup Kumar Dhal

    And the date format can be(MM/DD/YYYY). Thanks!

    0
    Comment actions Permalink
  • Rainer Grabowski

    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. 

    0
    Comment actions Permalink
  • Anup Kumar Dhal

    Hi Rainer,

    How are you doing?

    Did you get any solution for my last message?

     

    Thanks & Regards,

    Anup Kumar Dhal

    0
    Comment actions Permalink
  • Rainer Grabowski

    I've already posted a reply :)

    0
    Comment actions Permalink
  • Anup Kumar Dhal

    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.

    0
    Comment actions Permalink
  • Sergio Pérez Jaramillo

    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

     

    0
    Comment actions Permalink
  • Rainer Grabowski

    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

    0
    Comment actions Permalink
  • Elias Fernandes

    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.

    10
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk