javascript to use Start-Date and End-Date in a Calculation
I am using a calculation field to create titles for items in an app. I know how to insert the date when it's a single date: All of Client Name + " " + Frequency + " " + Type + " " + moment(Time Period).format("YYYY-MM-DD"); but this will only show the start date.
How do I edit the js so that it pulls in the Start Date and End Date (i.e. 01-01-2014 to 31-12-2014)
Thanks, Ann
-
Official comment
Just updated this topic from "Calculations" to "Feature Request" so we can better track it as a requested feature enhancement. Thanks for adding your votes!
Comment actions -
It would work if there were two date fields, and I could do that -- I really just needed the end date anyway, but as the app came with it already this way I'd thought I'd use it.
There must be a way to instruct moments.js to use the Start or End Date. Are there separate field names for these in the database? ie TimePeriod.Start or something like that?
-
Hi Ann and Sara,
Good suggestion for a feature request: being able to get the end date of a date field. Most times a separate second field for the end date is not handy and unnecessary taking space. Why not giving js the ability using the existing end date? Would be very efficient.
Regards,
Ron -
Hi Sara, is there already an idea when we will be able to reference the end date inside of the calculations?
For now I'm always creating a separate "end date" date field, but this is not an elegant solution.
Sorry that we are asking for something so small. I guess this is what you get when you give us with so much Podio Awesomeness ... Long story short: you've spoiled us too much ;).
-
Just to add a little bit of priority to that issue: you can't at the same time do JS on start and end dates, which requires two date fields, and see start and end date as one field extending over time in calendar view, which is only possible if start and end date are set in one and the same date field.
-
I second this. While separate fields are great for calculations and relationships they do not show any duration in the calendar. If I had project that was one year long it would show the Start on the 1st Jan and then the End on 31 Dec in the calendar but nothing in between. This then causes problems for resource management as the person assigned to that project does not have their calendar blocked out for 365 days of work assignment and only gets scheduled for 2! The seemingly only (very ugly solution) is to have many dates fields - Start/End, Start, End. Not very elegant at all sadly. I wouldn't even mind if I was able to create a calculation fields for it i.e Start/End, Calc Start (@Min of Start/End), Calc End (@Max of Start/End). The end date is in Podio we know that for sure but how to get at it seems to be puzzle?
The Podio dev team can get at it and display it for us, why can't we?
Please sign in to leave a comment.
Comments
18 comments