This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Is it possible to create a property that totals values from related objects?

We have two objects - Monthly Timesheet and Timesheet Record, the later being a subtype of the first.

Both objects have a number property - Monthly Total and Total Hours respectively.

The Monthly timesheet will have multiple timesheet records added to it and I want the Monthly total, on the Monthly Timesheet, to add up each of the Timesheet Records total hours.  Both properties types are Number (real).

My thinking was to make the Monthly total property, a calculated property using VBScript but I am useless at creating VBScript. 

The other thought was using Managed Properties in the Compliance kit but I haven't been able to achieve that as yet.

I could really do with another pair of eyes, any help would be much appreciated.

Thanks in advance Blush

K

Parents
  • This isn't something you can do with the built-in configuration options (or with Compliance Kit) alone so I suggest reaching out to your M-Files representative. There may be some consulting solutions available that would save you the trouble of scripting/coding a custom extension for this.

Reply
  • This isn't something you can do with the built-in configuration options (or with Compliance Kit) alone so I suggest reaching out to your M-Files representative. There may be some consulting solutions available that would save you the trouble of scripting/coding a custom extension for this.

Children