How to show various DocTypes in one Calendar view

ERPNext Customize ERPNext
21

I think this is a wonderfull solution and it should be easily available to whole community. So either it should be in the ERPNext itself or it should be in the marketplace.

2 Likes
22

Good recommendation, current low code/no code Calendar View works with one doctype only. The ability to create a combined view with data from multiple doctype will be so awesome.

Also, I want to say thank you both @avc @pedro_vde for this question, I also benefit from it. Quality questioner and answer-er are both important. :slight_smile:

Lately I see people ask questions in Telegram rooms, for me forum is way better as it is not flown away like chat.

NOTE: Virtual Doctype concept can make this a bit less dirty?

23

We should try if it also supports the Calendar View?

24

@avc @pedro_vde
i am having this error in gantt view . Did you guys resolve this?
pymysql.err.OperationalError: (1054, “Unknown column ‘tabCalendar.exp_start_date’ in ‘order clause’”)

25

Could you confirm if the “exp_start_date” field exists in the Calendar/doctype that you are using?

1 Like
26

@NCP my bad . had a spelling mistake. Thanks Man.

27

@avc @pedro_vde This is great ! Now, how what is the easiest way to add iCal subscribe link to this combo-calendar ?

The txt format I know how to prepare, but what is the proper way in terms of access token and endpoint exposure?

28

hello , i have same issues but i want when click for exemple in Task:Test 01 go to doc Test 01, AND for leave application go to the doc of leave application …

29

Hi @Hela_Guesmi:

Check this. Use options to capture eventClick behavior …
Have to manage proper get_events …

frappe.views.calendar['TT Task'] = {
    field_map: {
		start: "start_expected_data",
		end: "end_expected_data",
		id: "name",
		title: "subject",
		allDay: "allDay",
		progress: "progress",
		doctype_source: "doctype_source"
	},
	get_events_method: "get_events",
    
   options: {
        eventClick: function(e) {
            let data = e.event._def.extendedProps
            frappe.set_route('Form', data.doctype_source, data.name);
        }
    },
}

Hope this helps.

2 Likes