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
-
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..
Content aside
- 5 yrs agoLast active
- 1Replies
- 1296Views