Announcement

Collapse
No announcement yet.

Customize the event description

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

  • 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

  • #2
    Re: Customize the event description

    Can you create a view combining the two tables and base your ScriptCase application SQL on the view?
    RAD tools for rich UI http://www.koolphptools.com

    Comment


    • #3
      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 ?

      Comment


      • #4
        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
        RAD tools for rich UI http://www.koolphptools.com

        Comment

        Working...
        X