I need to add fields "registered" and "attended" to the available reporting fields in a sugar CRM. I think I found the code where similar check boxes are (see code snipet). I need to map these check boxes to the events_attended table for the attended and registered fields. I see the fields in the code but I am not exactly sure where the table referance is. I am not even sure this is the correct place where I need to change the page code. Am I on the right track?????
<script type="text/javascript">
<!-- // associated javascript data generated by ListView
var associated_javascript_data = {"even.assigned_user_id":{"ID":"even.assigned_user _id","name":"assigned_user_id","vname":"LBL_ASSIGN ED_TO","vname_module":"EventSessions","source":"ev en","type":"assigned_user_name","options":"","name _translated":"Assigned to","type_translated":"User Name"},"even.attendee_limit{"ID":"even.attendee_ov erflow","name":"attendee_overflow","vname":"LBL_AT TENDEE_OVERFLOW","vname_module":"EventSessions","s ource":"even","type":"int","options":"","name_tran slated":"Attendee Overflow","type_translated":"Integer"},"even.break fast":{"ID":"even.breakfast","name":"breakfast","v name":"LBL_BREAKFAST","vname_module":"EventSession s","source":"even","type":"varchar","options":""," name_translated":"Breakfast Served","type_translated":"Text"},"even.calendar_c olor":{"ID":"even.calendar_color","name":"calendar _color","vname":"LBL_CALENDAR_COLOR","vname_module ":"EventSessions","source":"even","type":"enum","o ptions":"event_color_dom","name_translated":"Calen dar Color","type_translated":"Drop-down Selection","options_keys":["","red","green","blue","magenta","cyan","brown"," violet","chocolate","crimson","firebrick","fuchsia ","indigo","orangered","yellowgreen"],"options_values":["","Red","Green","Blue","Magenta","Cyan","Brown"," Violet","Chocolate","Crimson","FireBrick","Fuchsia ","Indigo","OrangeRed","YellowGreen"]},"even.calendar_post":{"ID":"even.calendar_post", "name":"calendar_post","vname":"LBL_CALENDAR_POST" ,"vname_module":"EventSessions","source":"even","t ype":"bool","options":"","name_translated":"Calend ar Post","type_translated":"True or False"},"even.phone":{"ID":"even.phone","name":"ph one","vname":"LBL_PHONE","vname_module":"EventSess ions","source":"even","type":"varchar","options":" ","name_translated":"Conference Phone","type_translated":"Text"},"even.phone_passw ord":{"ID":"even.phone_password","name":"phone_pas sword","vname":"LBL_PHONE_PASSWORD","vname_module" :"EventSessions","source":"even","type":"varchar", "options":"","name_translated":"Conference Phone Password","type_translated":"Text"},"even.created_ by":{"ID":"even.created_by","name":"created_by","v name":"LBL_CREATED","vname_module":"EventSessions" ,"source":"even","type":"assigned_user_name","opti ons":"","name_translated":"Created by","type_translated":"User Name"},"even.date_entered":{"ID":"even.date_entere d","name":"date_entered","vname":"LBL_DATE_ENTERED ","vname_module":"EventSessions","source":"even"," type":"datetime","options":"","name_translated":"D ate Created","type_translated":"Date & Time"},"even.description":{"ID":"even.host4","name ":"host4","vname":"LBL_HOST4","vname_module":"Even tSessions","source":"even","type":"varchar","optio ns":"","name_translated":"Event Host 4","type_translated":"Text"},"even.host5":{"ID":"e ven.host5","name":"host5","vname":"LBL_HOST5","vna me_module":"EventSessions","source":"even","type": "varchar","options":"","name_translated":"Even t Host 5","type_translated":"Text"},"even.event_name":{"I D":"even.event_name","name":"event_name","vname":" LBL_EVENT_NAME","vname_module":"EventSessions","so urce":"even","type":"relate","options":"","name_tr anslated":"Event Name","type_translated":"Related Value"},"even.speaker1":{"ID":"even.speaker1","nam e":"speaker1","vname":"LBL_SPEAKER1","vname_module ":"EventSessions","source":"even","type":"varchar" ,"options":"","name_translated":"Event Speaker 1","type_translated":"Text"},"even.speaker2":{"ID" :"even.speaker2","name":"speaker2","vname":"LBL_SP EAKER2","vname_module":"EventSessions","source":"e ven","type":"varchar","options":"","name_translate d":"Event Speaker 2","type_translated":"Text"},"even.speaker3":{"ID" :"even.speaker3","name":"speaker3","vname":"LBL_SP EAKER3","vname_module":"EventSessions","source":"e ven","type":"varchar","options":"","name_translate d":"Event Speaker 3","type_translated":"Text"},"even.speaker4":{"ID" :"even.speaker4","name":"speaker4","vname":"LBL_SP EAKER4","vname_module":"EventSessions","source":"e ven","type":"varchar","options":"","name_translate d":"Event Speaker 4","type_translated":"Text"},"even.speaker5":{"ID" :"even.speaker5","name":"speaker5","vname":"LBL_SP EAKER5","vname_module":"EventSessions","source":"e ven","type":"varchar","options":"","name_translate d":"Event Speaker 5","type_translated":"Text"},"even.event_type_id": {"ID":"even.event_type_id","name":"event_type_id", "vname":"LBL_EVENT_TYPE","vname_module":"EventSess ions","source":"even","type":"relate","options":"" ,"name_translated":"Event Type","type_translated":"Related Value"},"even.url":{"ID":"even.url","name":"url"," vname":"LBL_URL","vname_module":"EventSessions","s ource":"even","type":"varchar","options":"","name_ translated":"Event URL","type_translated":"Text"},"even.website":{"ID ":"even.website","name":"website","vname":"LBL_WEB SITE","vname_module":"EventSessions","source":"eve n","type":"varchar","options":"","name_translated" :"Event Website","type_translated":"Text"},"even.event_for mat":{"ID":"even.event_format","name":"event_forma t","vname":"LBL_FORMAT","vname_module":"EventSessi ons","source":"even","type":"relate","options":"", "name_translated":"Format","type_translated":"Rela ted Value"},"even.date_modified":{"ID":"even.date_modi fied","name":"date_modified","vname":"LBL_DATE_MOD IFIED","vname_module":"EventSessions","source":"ev en","type":"datetime","options":"","name_translate d":"Last Modified","type_translated":"Date & Time"},"even.location":{"ID":"even.location","name ":"location","vname":"LBL_LOCATION","vname_module" :"EventSessions","source":"even","type":"varchar", "options":"","name_translated":"Location Description","type_translated":"Text"},"even.locat ion_maplink":{"ID":"even.location_maplink","name": "location_maplink","vname":"LBL_LOCATION_MAPLINK", "vname_module":"EventSessions","source":"even","ty pe":"varchar","options":"","name_translated":"Loca tion Maplink","type_translated":"Text"},"even.location_ url":{"ID":"even.location_url","name":"location_ur l","vname":"LBL_LOCATION_URL","vname_module":"Even tSessions","source":"even","type":"varchar","optio ns":"","name_translated":"Location URL","type_translated":"Text"},"even.lunch":{"ID": "even.lunch","name":"lunch","vname":"LBL_LUNCH","v name_module":"EventSessions","source":"even","type ":"varchar","options":"","name_translated":"Lu nch Served","type_translated":"Text"},"even.modified_u ser_id":{"ID":"even.modified_user_id","name":"modi fied_user_id","vname":"LBL_MODIFIED","vname_module ":"EventSessions","source":"even","type":"assigned _user_name","options":"","name_translated":"Modifi ed by","type_translated":"User Name"},"even.name":{"ID":"even.name","name":"name" ,"vname":"LBL_NAME","vname_module":"EventSessions" ,"source":"even","type":"name","options":"","name_ translated":"Name","type_translated":"Name"},"even .no_date_end":{"ID":"even.no_date_end","name":"no_ date_end","vname":"LBL_NO_DATE_END","vname_module" :"EventSessions","source":"even","type":"bool","op tions":"","name_translated":"No End Date","type_translated":"True or False"},"even.no_date_start":{"ID":"even.no_date_s tart","name":"no_date_start","vname":"LBL_NO_DATE_ START","vname_module":"EventSessions","source":"ev en","type":"bool","options":"","name_translated":" No Start Date","type_translated":"True or False"},"even.parking":{"ID":"even.parking","name" :"parking","vname":"LBL_PARKING","vname_module":"E ventSessions","source":"even","type":"varchar","op tions":"","name_translated":"Parking Instructions","type_translated":"Text"},"even.refr eshments":{"ID":"even.refreshments","name":"refres hments","vname":"LBL_REFRESHMENTS","vname_module": "EventSessions","source":"even","type":"varchar"," options":"","name_translated":"Refreshments Served","type_translated":"Text"},"even.reminder_s ent":{"ID":"even.reminder_sent","name":"reminder_s ent","vname":"LBL_REMINDER_SENT","vname_module":"E ventSessions","source":"even","type":"bool","optio ns":"","name_translated":"Reminder Sent","type_translated":"True or False"},"even.session_number":{"ID":"even.session_ number","name":"session_number","vname":"LBL_SESSI ON_NUMBER","vname_module":"EventSessions","source" :"even","type":"int","options":"","name_translated ":"Session Number","type_translated":"Integer"},"even.date_st art":{"ID":"even.date_start","name":"date_start"," vname":"LBL_START_DATE","vname_module":"EventSessi ons","source":"even","type":"datetime","options":" ","name_translated":"Start Date","type_translated":"Date & Time"},"even.tracking_code":{"ID":"even.tracking_c ode","name":"tracking_code","vname":"LBL_TRACKING_ CODE","vname_module":"EventSessions","source":"eve n","type":"varchar","options":"","name_translated" :"Tracking Code","type_translated":"Text"}};
-->
</script>


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks