Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

Hi,

refer below link

Condition field types

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x 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.