CAB date selection by drop down field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Need suggestion on how to configure a date field where the CAB dates should show the dates for the upcoming 6 weeks. Please see the below screenshot from a table where cab dates can be configured by the Change team. and only these dates will appear under the CAB date selection for the end user on the change form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @dassan,
If these dates are stored in a custom table, the best approach is to configure your CAB Date field as a Reference field or a Lookup Select Box pointing directly to that custom configuration table.
You can then apply an Advanced Reference Qualifier on that field to dynamically filter and display only the records where the date falls within the upcoming 6 weeks using script include or a query.
Before making this change, verify if the CAB date field you are modifying is an Out-of-the-Box (OOB) field. Changing the data type of an OOB field from a Date/Time to a Reference field is highly discouraged as it will break platform schema consistency, impact OOB CAB Workbench functionalities, and cause issues during future upgrades.
If it is an OOB field, the safest best practice is to:
1. Leave the OOB date field as-is (and hide it from the form).
2. Create a new custom Reference field pointing to your CAB table with your 6-week filter.
3. Use a simple Business Rule to map the selected date from your custom field back to the OOB date field behind the scenes.
Hope this helps!
Thanks,
Chirag