Jump to content

ray985

Members
  • Content Count

    10
  • Joined

  • Last visited

Reputation Activity

  1. Like
    ray985 got a reaction from subraasingapore in Using external parameters in calculated field   
    Thanks. That did the trick.
    For anyone else that has the same problem, here's the code I ended up using in the calculated field box. I passed the parameter "wattsaved" in the URL to Caspio which came from a textbox in my form. 
    CASE WHEN [@field:Per]='watt saved' THEN ([@field:Rebate] * '[@wattsaved]') WHEN [@field:Per]='kW saved' THEN ([@field:Rebate] * ('[@wattsaved]' / 1000)) ELSE 0 END  
×
×
  • Create New...