On a custom table extending the task table, should new State choice added on custom or global scope?

Smith Johnson
Tera Guru

Hello,

I am new on the custom app development, and I would like your opinion on the following 🙂

I am working on a custom app created with App Engine Studio. 
I have a table extending the task table, and I would like to modify the choices of the State field.

Does it make sense to add new choices for the State field on my custom app scope or on global scope?
What's the best practice on fields that are inherited from a parent table? 
Could you please provide your reasoning on this?

Thank you in advance,
Smith.

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Smith Johnson 

If the state is not used in any other table and since it’s a custom app, it's better to create the new value only in a new table (meaning a custom table only). If you create it in the parent table, it will be visible everywhere, and every child table will need to make changes. So, it's better to create it within the scope of the custom table.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Smith Johnson 

If the state is not used in any other table and since it’s a custom app, it's better to create the new value only in a new table (meaning a custom table only). If you create it in the parent table, it will be visible everywhere, and every child table will need to make changes. So, it's better to create it within the scope of the custom table.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Jaspal Singh
Mega Patron
Mega Patron

Hi Smith,

 

Well, if it custom table that you need state choices for then better to add it to custom table's state field instead of task.

It will make sense to add it to task table in case, you want it to be available for other tables as well extending task table.