Jump to content


  • Posts

  • Joined

  • Last visited

CMorris's Achievements


Newbie (1/14)



  1. I am trying to create a triggered action that will copy a record from one table into another. That part is simple and I have it working fine. However, there is one field where I want to pull one field from the unique ID that matches the insert. As you can see in the screen cap below, the validation failed. Is there a way to do this, or a workaround?
  2. 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: CASE WHEN [@cbParamVirtual2] = 'mm' THEN [@cbParamVirtual1]/25.4 ELSE [@cbParamVirtual1] END 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!
  3. 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?
  4. 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...