I am adding a new palette and when I fill in the "based on" field I am unable to find one of my fields called "work type". Do you know why this isn't showing? I checked the FLS and it's visible.
Heiko Lindner (Privat) Forum Ambassador
if you added the field on service appointment object as picklist and your user has proper permission, it should be visible to choose.
As already mentioned, maybe you can think of a platform automation to populate the right color hexcode like '77e455' into the field FLS_GanttColor__c. This will be used a color, if it's filled, instead of the standard color code.
@Emmy Castle, I don’t think there’s a workaround for this. Additionally, for the Based On input, we should use a field that can change over time - for example, Due Date. In this case, service appointments will be color-coded based on how close they are to the due date.
On the other hand, Work Type is unlikely to change and will likely remain the same regardless of any updates to the service appointment. As a result, I don’t think it’s a good idea to build some custom functionality to color-code a service appointment based on its work type.
However, if you decide to proceed with a custom solution, you will need to update the FSL__GanttColor__c field on the Service Appointment object to set the appropriate color under different conditions.
Thank you!
@Emmy Castle, thanks for the clarification!
The Work Type field is a lookup, not a picklist. It is a reason why it is not available.
@Emmy Castle, in the description, you mentioned Work Type, which is a lookup field. Are you planning to use this field or another one?
Hello @Emmy Castle!
For the Based On input, the following field types are supported:
- Picklist;
- Checkbox;
- Number;
- Date.
Please read the Color-Code the Gantt for more details.
Thank you!