Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
More View questions
- Thread starter kbuck
- Start date
There is one thing that is useful to keep in mind when creating views : the less work the view design has to do, the faster it will display and update.
In other words, if you have results to display in a view, and those results are rather process-intensive, it is better to put a hidden field on the form and do the calculations there, then just display the field value (the result) in the view.
That being said, view column formulas do not have any means of taking into account results from another column. There had been talk about such functionality for R6, but in the end that got removed, or was never brought to beta. You can play will column values in LScript, but you do not have access to that in column formulas.
So, if you must do the calculation in the view, you will have to repeat the formula for the first column in the second one, and work from there.
In other words, if you have results to display in a view, and those results are rather process-intensive, it is better to put a hidden field on the form and do the calculations there, then just display the field value (the result) in the view.
That being said, view column formulas do not have any means of taking into account results from another column. There had been talk about such functionality for R6, but in the end that got removed, or was never brought to beta. You can play will column values in LScript, but you do not have access to that in column formulas.
So, if you must do the calculation in the view, you will have to repeat the formula for the first column in the second one, and work from there.
- Status
Similar threads
