I’ve been looking through the designer help hoping that there is something that would allow me to do something that I couldn’t do in R5 but I can’t find what I need.
In a nutshell, I have 2 types of documents in a categorized view. There is exactly 1 of document A and there may be several of document B. Document A has the value “Alloted Time” and Dcoument B has the value “HoursWorked”. Right now I have AllottedTime in one column and the summary of all of the “HoursWorked”. In a third column, I would like to subtract column 2 from column 1. Possible?
Within a category, it should be possible. Make your AllotedTime value positive and your HoursWorked values negative, then total the column. In this way, you aren’t really subtracting one column from another, but you should reach the same result.
Nope. That would meant that Notes would need to “know” what rows in the view need to be recalculated when the A document is saved - views don’t work that way.
In a view, a row displays data from only one document. So I think the values that you want to subtract need to be in one document. Perhaps you can use an agent to put them there.Colour values seem to be the only special case. A view is able to get data from a profile document to use as colour values, but not to use as ordinary data values.