Jump to content


  • Posts

  • Joined

  • Last visited

Posts posted by CMorris

  1. I have a datapage that utilizes virtual fields to collect user input values that I don't want to store in tables, but do want to use for some generally simple calculations.  However, because virtual fields don't store the input as numeric, I keep getting calculation errors.  Here is a simple example of one calculation that I can't get to work:


    VirtualField1 is a text box

    VirtualField2 is a dropdown with the options "in" and "mm"

    VirtualField3 is a calculated field with the following formula:


    WHEN [@cbParamVirtual2] = 'mm' THEN [@cbParamVirtual1]/25.4

    ELSE [@cbParamVirtual1]



    No matter what tweaks I have tried, I either get a "calculation error" message or just nothing appears in the VirtualField3.  Any suggestions would be greatly appreciated.  Thanks!

  2. Hi, I am a beginner to Caspio and scripting.  I have a datapage that is embedded into the HTML on my site.  I have the datapage set to conditionally format/hide certain sections of the page based on user input.  That is all working perfectly.  However, the first option on my datapage is a dropdown with 2 choices.  I would like to pass a parameter from that dropdown to conditionally change an image on the webpage where the datapage is embedded.  So, for example:

    User chooses option "A" from the dropdown on the datapage and the image on the page where the datapage is embeded becomes a picture of an apple

    User chooses option "B" from the dropdown on the datapage and the image on the page where the datapage is embeded becomes a picture of a banana

    I have found examples on line of scripts that will change an image based on the output of a dropdown, but the dropdown and the image are both part of the same source (if that makes sense).  In my case, my dropdown is in Caspio, but the image isn't.  I know this needs to be done with Javascript and I know I can pass parameters from Caspio "on exit", but can I pass them "on change"?  If so, how do I do that?

  3. I am developing an app that will be account based.  Each parent account will be able to have a set number of active users.  Each active user will be able to login under the parent account and work with the app.  The parent account admin can currently activate or deactivate a user.  Currently the admin can view a report datapage of all users and choose which ones are active.  I would like to have a way to count the number of users that are currently activated whenever a record changes and check that against what is allowed for their account.  If they have too many activated, I want to send an error message or prevent them from saving/updating the user record.  I assume I will need to do this through a triggered action whenever my user accounts table is updated, but I'm not sure how to do so.  Is this even possible?

  • Create New...