Fetch data from Custom DocType

I created new DocType called TSCategoy with 2 fields, category_type and activity_type.

Now I want to replace the standard Timesheet Activity and replace it with my new custom one. The idea is that when User selects a category_type in Timesheet, next column will show the activities that belong to a selected category, for example:
Category: Admin can have 3 Activities: Invoicing, Office Support, General

I was able to create custom field in “Timesheet Detail” that links to “TSCategory”, but that only gives me category_type field. I don’t know how to add another field that will change based on selected category_type.

thanks.

@bedo
You will have to create 2 custom fields in Timesheet Detail such as category_type and activity_type using Customize Form. After that,
In Options field of activity_type, add category_type.activity_type.
It will get fetched automatically when you select a category_type.

Thanks,
Mohini

1 Like