Custom forms in BCM

[Guest]

I'm sorry if I am posting this in the wrong place -

I have added custom fields to my contact form and would like to link them to
my calendar and have them calculate some other things. I don't know anything
about programming, but I need to learn in order to make this work. What do I
need to learn and where is the best place to look. Meaning, I know NOTHING
about programming, and frankly I don't even understand what the difference
between VB, VB.net etc are - I just really need to customize Outlook and BCM
to work for me and I have not been successful in finding anyone who I can pay
to do this - so, I figure I should just learn it myself.

Thanks

Carole

 

[Lon Orenstein]

Carole:

Could you be more specific? What do you want to do with the new fields?

You can use the custom fields by right clicking on the Calendar view, choose
Customize Current View, click on Fields button, and in the Select Available
Fields From dropdown you would choose User Defined Fields in Folder. You
can also use those fields in the Automatic Formatting section to create
conditions -- this might be what you're attempting.

HTH,
Lon

_________________________________________________
Lon Orenstein
pinpointtools
(e-mail address removed)
www.pinpointtools.com

 

[Guest]

Hi Lon

I have added some fields that include:
Checkin date, checkout date
Number of adults
Number of children
Airport pickup required
Airline
Flight number
Arrival time
Departure time

From the checkin and checkout dates I would like to calculate the number of
nights the guests are interested in. (I did figure out the DateDiff command)
I would also like to add the dates to a calendar - with the option of
changing it from tentative when it is an inquiry, to "busy" when it is
actually a confirmed booking. (this could be done on either 5 different
calendars or one calendar, using different colors for each property)

From the adults and children fields I would like to calculate the total
number of guests. I'll have a field that is populated with this number, and
from the result I would have a nightly rate calculated - with an option of
manually changing this result.

Finally, from the checkin/checkout dates and the airport transfer/arrival
information I would like to be abe to create a report which shows
checkins/checkouts / apartment, airport transfer info so I can give this info
to our housekeeper and driver.

Thanks for any suggestions you have ---

Carole

Carole:

Could you be more specific? What do you want to do with the new fields?

You can use the custom fields by right clicking on the Calendar view, choose
Customize Current View, click on Fields button, and in the Select Available
Fields From dropdown you would choose User Defined Fields in Folder. You
can also use those fields in the Automatic Formatting section to create
conditions -- this might be what you're attempting.

HTH,
Lon

_________________________________________________
Lon Orenstein
pinpointtools
(e-mail address removed)
www.pinpointtools.com

 

[Lon Orenstein]

Well, this is definitely above your expertise level and probably can't just
be done as a report -- you want some automation to happen which means code
written to make that happen. BCM's report writer isn't powerful enough to
customize what you want but MS Access's is and that isn't too hard to learn
how to connect. Maybe some developers or programmers are lurking out there
and would be interested in this project...

HTH,
Lon

--
_________________________________________________
Lon Orenstein
pinpointtools
(e-mail address removed)
www.pinpointtools.com

Hi Lon

I have added some fields that include:
Checkin date, checkout date
Number of adults
Number of children
Airport pickup required
Airline
Flight number
Arrival time
Departure time

From the checkin and checkout dates I would like to calculate the number
of
nights the guests are interested in. (I did figure out the DateDiff
command)
I would also like to add the dates to a calendar - with the option of
changing it from tentative when it is an inquiry, to "busy" when it is
actually a confirmed booking. (this could be done on either 5 different
calendars or one calendar, using different colors for each property)

From the adults and children fields I would like to calculate the total
number of guests. I'll have a field that is populated with this number,
and
from the result I would have a nightly rate calculated - with an option of
manually changing this result.

Finally, from the checkin/checkout dates and the airport transfer/arrival
information I would like to be abe to create a report which shows
checkins/checkouts / apartment, airport transfer info so I can give this
info
to our housekeeper and driver.

Thanks for any suggestions you have ---

Carole

 

[Guest]

So is it just the report feature that is difficult in BCM? Is there any part
of what I want to achieve, like linking the custom fields to the calendar
that can be achieved? And calculating the number of nights (I am able to make
this work in an Outlook form, but I get errors when I try in a BCM form).

Would I have better luck if I just forgot about BCM and did this all in
Outlook, of course letting go of the connection between BCM and MOA07?

Carole