making boolean type (True/False) field in a custom table

[Amit Dey1]

hi , I have to make a boolean(True/False) type field  in a custom table , when ever I am searching in field type , it is not showing  , for that OOB field named active in service now , it is a boolean type field , as it is not present in my custom table , I can't use it , so how can we achieve this ?

[Basheer]

Hi @Amit Dey1 

Follow the below steps

Navigate to application navigator 

sys_glide_object.LIST > Enter

You will be shown with all data types

In the name search for Boolean

It should be in visible ticked, if it is not visible ticked it wont show up for usage.

If it is unticked then you need to modify the ACL's which is making the field readonly and mark it to ticked and revert the ACL to previous version.

[Amit Dey1]

hi @Basheer  actually our requirement is like some variable in catalog form referencing in sys_user table and active true users only we can select ,  and if we select some user previously who become inactive now , then the variable is becoming empty while loading of the form , like this same requirement we want to build in for a variable which is referencing to the custom table , if we user selected any value which is inactive now , while opening the form , the variable will become empty and user has to fill the form again