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.

The Field Condition Builder with a dependent reference field doesn't show related field

IgorMK
Tera Contributor

I have a field named "Table" which references sys_db_object. Its default value is the sys_id of "Incident".

IgorMK_0-1697524497715.png

 

I've also defined a Condition Field Form Builder named "Conditions" that is dependent on the "Table" field.

 

IgorMK_1-1697524563595.png


However, no fields are displayed.

IgorMK_2-1697524688454.png

 

How can I solve this problem?

I know that the Condition Builder works with a "Table Data" type, but I would like to use the reference. My idea would be to create a field "Abc" of the "Table Data" type in the table and transfer the value from "Table" to "Abc" using a Business Rule.

Do you have other solutions?

1 ACCEPTED SOLUTION

udaysoni
Tera Guru

hi @IgorMK,

Create Table field with type Table Name and give default value as incident

Screenshot 2023-10-17 at 3.11.46 PM.png

And keep the filter Condition as it is

Screenshot 2023-10-17 at 3.13.31 PM.png

And it will work like this

Screenshot 2023-10-17 at 3.14.16 PM.png

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

View solution in original post

4 REPLIES 4

Not applicable

Do you want to see all incidents (like from incident table the condition be like "short_description=='blahblah' impact==1" or you want to select the types of fields you have in the incident table definition ?
If first you need to point to incident table not sys_db_object (the table definition itself - this would do any good if you are dynamically doing stuff with under the hood structure).
Also, note that you should use singular names for tables and columns - yours is "tables" bad practice which will bring unexpected behaviours.

Hey, thanks for your advice! I wanted to select the types of fields i have in the incident table definition. Incident is just an example here, what's important for me is that the condition works in the form. I will simply use the "Table Name" type..

udaysoni
Tera Guru

hi @IgorMK,

Create Table field with type Table Name and give default value as incident

Screenshot 2023-10-17 at 3.11.46 PM.png

And keep the filter Condition as it is

Screenshot 2023-10-17 at 3.13.31 PM.png

And it will work like this

Screenshot 2023-10-17 at 3.14.16 PM.png

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

IgorMK
Tera Contributor

This is the way, it works! Thanks!