How to remove choices of a field inherited from parent table

Go to solution
Pritam7
Tera Contributor

‎09-08-2023 12:37 PM

I have a 'state' field in the pm_project_task table which was inherited from 'task' table. I want only three choices open, closed, cancelled in the state field but it has inherited all the choices. How can I remove those choices? If dictionary over ride can be used, please let me know how to configure that.

Thanks in advance

0 Helpfuls
  • 1,257 Views
1 ACCEPTED SOLUTION

Go to solution
Astik Thombare
Tera Sage

‎09-08-2023 07:07 PM - edited ‎09-08-2023 07:09 PM

Hi @Pritam7 ,

Please Follow bellow steps to remove fields from pm_project_task table 

Step 1: Right-click on the form header and go to "Configure," then select "Form Design."

astik_0-1694225168221.png

Step 2: In the Form Designer, locate the gear icon near the "state" field (or the field you want to modify).

astik_1-1694225213411.png

 

Step 3: Scroll down in the Field Configuration options until you find the choices you want to remove, and click on the "X" or cross symbol next to them.

astik_2-1694225236865.png

 

Step 4: After removing the unwanted choices, click on the "Save" button in the Form Designer to save your changes. Now, when you return to the "pm_project_task" form, you will not be able to see those removed choices.

This process deactivates or hides certain choices within a field, rather than deleting the entire choices itself from the table.

 

Please mark my answer as correct if it helps you 

 

Regards,

Astik Thombare

 

 

View solution in original post

2 REPLIES 2

Go to solution
Astik Thombare
Tera Sage

‎09-08-2023 07:07 PM - edited ‎09-08-2023 07:09 PM

Hi @Pritam7 ,

Please Follow bellow steps to remove fields from pm_project_task table 

Step 1: Right-click on the form header and go to "Configure," then select "Form Design."

astik_0-1694225168221.png

Step 2: In the Form Designer, locate the gear icon near the "state" field (or the field you want to modify).

astik_1-1694225213411.png

 

Step 3: Scroll down in the Field Configuration options until you find the choices you want to remove, and click on the "X" or cross symbol next to them.

astik_2-1694225236865.png

 

Step 4: After removing the unwanted choices, click on the "Save" button in the Form Designer to save your changes. Now, when you return to the "pm_project_task" form, you will not be able to see those removed choices.

This process deactivates or hides certain choices within a field, rather than deleting the entire choices itself from the table.

 

Please mark my answer as correct if it helps you 

 

Regards,

Astik Thombare

 

 

Go to solution
Community Alums
Not applicable

‎09-09-2023 12:14 AM - edited ‎09-09-2023 12:17 AM

Hi @Pritam7 ,

 

There is no dictionary override for choices. Please follow the below steps.

 

  1. Open the state field dictionary (right click on the field > configure > dictionary). This will take you to sys_dictionary form where table field will have value as task.
  2. Scroll to the bottom and Go to Choices (related list)
  3. Click new and add three choices for pm_project_task table one by one. Give table name, choice label, choice value and sequence.
  4. Once the choices are added explicitly for the child table, then child table choices overrides the parent table choice and you will see only three choices which you recently created for child table (pm_project_task).

 

Please mark the answer as correct or helpful if it helps you.

 

Thank you,

Santosh Poudel

0 Helpfuls