YourSolutions

Many Thanks for your reply, I will take a look at the various resources you have made available to me. I am not an experienced programmer / coder so I was really hoping for a simpler method. Would it not be possible to run an IF Function, for example: IF the "calculated field" value is > than or equal to 90% THEN send an email to Address X ELSE IF "calculated field" is between 60 and 89 THEN send an email to Address X and Address Y etc;

Hi There, I want an email with the contents of the report automatically sent to an individual(s) when a condition is met in a calculated field. For Example: Calculated field is greater than a certain value = Send email to person A OR Calculated field is between value X and Value Y = Send email to person A & B Each person has a unique email address. Any advice would be greatly appreciated! Many Thanks!

Thank You so much for such a thorough solution! Greatly Appreciated!

I am not able to select the "Calculated Field" from the "Data Source Fields" drop down menu, it doesn't appear there. I am in the same situation. I have a "Calculated Field" that runs a calculation which I need stored in a table. I am unable to get this calculated value to get stored in the table currently. Any assistance would be greatly appreciated!

Hi guys, I'm trying to have a situation where a form is displayed to the user whereupon they enter particular information (Fields A - E), should this information be reviewed (user ticks "reviewed, Y/N" box), further fields (Fields F - P) are made visible to the user where they can enter in more descriptive information which was not asked in the first form. At the end, all the information pertaining to a specific incident must be combined so that reports can generated at a later stage. Ideally, in my mind, should the user tick the "yes tick box", further fields are displayed upon which the user can enter in more descriptive information. If I'm not mistaken, and if function could be utilised in this case. Another way of explaining this: Is it possible for a user to enter information into a form (Fields A - E) and submit that form. The form is then viewed at a later stage and further information can be added to that specific form in new text fields (Fields F - P). Is this possible and if so, how would one go about doing this. Any information as to how this could be done would be greatly appreciated, if any further details are required please don't hesitate to ask. Many Thanks!