Discussions

Expand all | Collapse all

Calendar View With Date and Time

  • 1.  Calendar View With Date and Time

    Posted 12 days ago
    Hello,

    I currently have a table that holds all of our tasks that is in a table-to-table relationship with our main customer table. When we create a task we have the date, time, and time of date (AM/PM) in separate inputs as the time of day input is very sluggish and not user-friendly. Where our issue comes is that we would like to put the items on a calendar view report from the task table, but we have no way to include all of the information into one field in a report formula. When I attempt to make them into a time of day formula I cannot get the [Task Date] (Date Field Type) &" "&[Task Time](Text Field)&" "&[Time of Day](Text Field) to work. 

    We also need to add an end time which would be 30 minutes after the beginning time that we are attempting to create.

    Is there a way to accomplish this?

    ------------------------------
    Benjamin Brooks
    ------------------------------


  • 2.  RE: Calendar View With Date and Time

    Posted 11 days ago
    Are you simply saying that you want to have a separate input field for the date and the time of day and the formula field to create a formula date time field that you can use on the calendar?

    Here is the function for that date time formula field.


    https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=143&rl=bvm


    if you then want to have a field which is 30 minutes later you can do this.  [My start date time field] + minutes(30)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Calendar View With Date and Time

    Posted 11 days ago
    Yes this should work here is a screenshot of the input for reference


    and trying to fill in the highlighted



    ------------------------------
    Benjamin Brooks
    ------------------------------



  • 4.  RE: Calendar View With Date and Time

    Posted 11 days ago
    The start date time would be

    ToTimeStamp([Task Date]),ToTimeOfDay([Task Time))


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Calendar View With Date and Time

    Posted 11 days ago
    Mark appreciate this greatly thank you

    ------------------------------
    Benjamin Brooks
    ------------------------------