0

Appointments

Some questions on appointment field:

1. Can the field be set just to show the date not the time?

 

2. if an appointment is set over a number of days, is there a way (in a separate field) to calculate the number of days within that range?

 

3. I have a trip table, within this table I have subtable called accommodation costings.  On The main trip table, I have the dates for a trip (setup as an appointment so can be viewed as multiple days in a calendar). Can I make the dates for any given accommodation during that trip be limited to the dates of the trip?

 

Thanks in advance

1 reply

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    Assume you have a field called "Appointment" .. 

    1.  Show the date .. not the time.   
          if you use a different formula field.. date(start(Appointment))   + " " + date(end(Appointment))

    2. Number of days... 

          days(date(start(Appointment)) , date(endof(Appointment)));

    3... I am a little confused.. when you say "subtable".. are you talking about a "composite" table?    I would think  that the accommodation table would have a "cost per day" .. (and potentially an effective date range).. so you would want to pull the effective rate .. Or .. perhaps the "subtable" really is a composite table .. as a "trip" may have multiple accommodations.. 

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1292Views