Is it possible to have a field on a screen that calculates based on other values on the screen without having the value populate a field in the database. I don't want the value to persist in the database as it will change daily. An example would be lease term remaining.
I have seen examples for adding scripts to the OnChange box. However, it seems like these are for populating a value in the database. What if I want the calculation done when the screen loads. It there a place to do this? Can someone please shove me in the right direction?
Any assistance is greatly appreciated!
I have seen that you have posted other questions recently indicating you were working with derived values within views so I guess you have sorted out the calculation part.
Are you happy with this? Another approach is to use a dummy field approach and have the calculated and displayed using a create script.
You can see that I have used this approach in this article
I used this same method for the same purpose that you (Michele) are using it for now. I believe I even reformatted a date like this. The only issue I noticed with it is that it always left an empty cell at the bottom which created extra space, which I then had to use a custom script to remove.