Jump to content


  • Posts

  • Joined

  • Last visited

sgriesbach's Achievements


Newbie (1/14)



  1. If I understand this correctly, I cannot reliably use Formula fields in a script at the end of a form. Indeed, it does not seem to work for my case, so I tried what you describe here and I still can't get it to work. My form is a Report form with a Details page. I have several Formula Fields set up in a table. Once the user submits the form, the Formula Fields get recalculated and are in the table nicely. The form has Ajax loading enabled, and the wizard is set to "Display Search Form Above the Results". In the JS at the end of this form, I want to sum up several of the Formula Fields, store the sum and do some other operations with the sum. I've tried setting up Virtual fields for each of the Formula fields, but I do not seem to get the Virtual values into the script. Example Details Page Setup: Formula field called ADJ set to Display Only and do not pass field value as a parameter [@ADJ] (note: I did try passing it directly, that doesn't work either) Virtual field called Virtual1 set to Hidden, set to receive value of ADJ on load, and pass field value as a parameter [@Virtual1] Here's a stub of the footer JS <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { var v1 = document.getElementById("EditRecordVirtual1").value; do some math with v1... // end of function }); </script> I'm not getting the v1 value, the script stops/fails at that line. Thanks for any advice!
  2. Is there a way to use the Datasheet "Replace" function to find and replace blanks in a particular field? thanks!
  • Create New...