Condition field on a form

MStritt
Tera Guru

I am looking to add a field (or anything) on our Account form, that displays the current running total (number) of open cases associated with that Account. I came across a conditions field (which I've created), but when I attempt to 'Add Filter Condition', I see:

find_real_file.png

find_real_file.png

find_real_file.png

Not sure where I need to config/select a table. I need to use the case table for this, so I can capture the total number of open cases against the account.

Unless, there is another way to accomplish this?? 

9 REPLIES 9

AirSquire
Tera Guru

Hi MStritt, you need to add a table field also on which your condition field will be dependent.

Condition field type: A field that adds a condition builder to a form. Condition builders require specifying a dependent field whose values the system uses to display choice list options. Typically, the dependent field is the Table field.

Documentation: Condition field types

Regards
Air

Hi Air,

Thanks for the reply. That's what I thought I did. Added a Conditions type field to the form. Maybe I didn't configure it correctly?

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

refer below link

Condition field types

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

I looked at that. Not sure I understand what I need to do. I created the condition field on our Account form (account table). The count I want to show, is the total number of cases opened against that account. So, the condition table is the case table (I would assume). How do I configure the condition field to use the case table? Then, how to add conditions to the field?

We have a related list on our account form/table called Cases. It shows all the cases that have been opened under that account.