Condition field on a form
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2020 08:56 PM
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:
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2020 09:13 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2020 09:20 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2020 09:24 PM
Hi,
refer below link
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2020 09:32 PM
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.