Announcement

Collapse
No announcement yet.

Customize the event description

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • msheward
    started a topic Customize the event description

    Customize the event description

    Hello,

    I have added a field in my calendar form which is referring to another table : contact (Structure : ID, NAME).
    This allows me to make a link between my calendar and a contact.

    I would like to be able to see the name of my contact when I am on the main page of the calendar like : "09:00 My event, My contact Name". If you take a look at this attachments, the event is like : "09:00 My event".

    Thank you
    Attached Files

  • andy
    replied
    Re: Customize the event description

    You'll have to experiment, but if your view's primary key is that of your main table (e.g. calendar) it should be able to perform CRUD operations on that table. You can use events (afterupdate, afterinsert, afterdelete) to perform the appropriate CRUD events on the contact table.
    i.e. the view serves to extract and present the data and update one of the two tables, the other table is updated via events.

    Give it a try

    Leave a comment:


  • msheward
    replied
    Re: Customize the event description


    I can create a view but where should I tell to script case to use the view that I've just created to display all the events in the calendar ?

    Leave a comment:


  • andy
    replied
    Re: Customize the event description

    Can you create a view combining the two tables and base your ScriptCase application SQL on the view?

    Leave a comment:

Working...
X