Calculation not refresh automatically

Is there a way to maybe use a button to allow for a formula to be recalculated only when the button is clicked. Have the formula below for an order form, but we want to not recompute the value as the months move along. If I created a "Calculate" button that the user clicks to see the value but it will stay at that value unless the button is clicked again. Any ideas on how this might be possible

remaining_months :=12 - @Month(@Today);

(38 * remaining_months) + 72
jforget1Asked:
Who is Participating?
 
SysExpertConnect With a Mentor Commented:
Or simply do all calculations in the button, and not on the form, so values only change when the button is pressed.


I hope this helps !
0
 
fgrushevskyConnect With a Mentor Commented:
@Command( [ToolsRefreshSelectedDocs] )
0
 
Sjef BosmanGroupware ConsultantCommented:
F9
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
jforget1Author Commented:
SysExpert,

I have the formula I am using in a button, how do I get this into a visible field. Do I use a computed value field? Standard field? How do I got the hand off of the calculated value from the button into a field the user can see?
0
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
Try this in your button:

remaining_months :=12 - @Month(@Today);
FIELD YourField:= (38 * remaining_months) + 72
0
 
jforget1Author Commented:
That worked, one last question, right now I have several area which appear dynamically based on the user selection, for this I have the Automatically Refresh Fields on the form design. If I leave this would it automatiacally refresh the value forced into this field by the button click when we get to next month? Or does using this method only refresh when clicked?
0
 
fgrushevskyCommented:
I believe only when clicked.
but again - you can add @postedCommand( [ToolsRefreshSelectedDocs] )  as last line in the button
0
 
jforget1Author Commented:
Thanks to all for the help here.
0
 
Sjef BosmanGroupware ConsultantCommented:
Normally, Automatically Refresh Fields should be avoided. Only when you have a spreadsheet-like form it is useful.
0
 
jforget1Author Commented:
OK thanks I changed it so my refreshing is happening at the field level and not the form level.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.