Help with Criteria & functions please

[RMDiekmann]

I am needing to gather custom record information from a destination device of a circuit in a circuit report.  I am currently using .....=IFNA(OBJECTDATA('eval circuit destination device', 'Device', 'Power'), OBJECTDATA('eval circuit destination device', 'Device-External', 'Power'))  to bring back device info, but I would also like to bring back custom record info of those devices as well. Is there anyone out the that can help with this?

[Pat Stanford]

If the record is attached to the object that is displaying in the database subrow, then a simple formula of:

 

='Record'.'Field' 

 

Where Record is replaced by the record name and Field is replaced by the Field name should get you what you want.

 

If this is something else we will need a better description of what you are trying to do to be able to help.

[RMDiekmann]

@Pat Stanford Sorry Pat... thanks for the quick response. My report criteria is set up for circuits in CC, Not the device it is connect to. I believe the function that I posted evaluates the circuit destination device and returns information from that device. I am looking for custom record information about that device that the circuit is connected to.

[Pat Stanford]

@RMDiekmann

Can you post a simplified file with a couple of objects, the Report, and what field and what Record and Field(s) you are looking for.

 

It is probably going to take a custom Worksheet Script to get what you want.

Databases only easily report data that is directly attached to the object reported in the database.

 

 

[Nikolay Zhelyazkov]

Hello @RMDiekmann,

 

You can use directly this formula in this case:

 

=OBJECTDATA('eval circuit destination device', '<custom record name here>', '<custom record field here>')

 

If the destination device has this custom record attached it will give you its data.

 

Best Regards,

Nikolay Zhelyazkov

[RMDiekmann]

Thank you @Nikolay Zhelyazkov this nailed it. I tried something similar with my original post but was missing a parentheses. Thank you both for the effort. I love finding these little time savers. This workflow I am working on is going save our company about 6-9 man hours on every project we do. Happy Holidays to you both.

[Conrad Preen]

On 11/24/2023 at 4:44 PM, RMDiekmann said:

This workflow I am working on is going save our company about 6-9 man hours on every project we do.

 

@RMDiekmann And that is what ConnectCAD is all about !!!