Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi NikkiC, I`ve made some modification to your JS. Try to use a snippet of code below. It should resolve all described issues. Hope this helps. <div id="el" class="c-rating"></div> <script src="http://www.cambridgedata.org/Testboard/manager/five-star-rating-master/js/dist/rating.min.js"></script> <script> // target element var el = document.querySelector('#el'); // current rating, or initial rating var currentRating = '[@field:QA_Tester_Rating#]'; // max rating, i.e. number of stars you want var maxRating= 5; // callback to run after setting the
  2. Hi RkaydianFlower, I am afraid that 9.7 release did not enable parameter usage of List datatype. Hopefully, this option will be available soon.
  3. Hi acslakeland, Perhaps you may consider a simpler solution restrict password sharing for the user of your application. In the Advanced setting of Authentication, you can check option: " Only one session per user ". By enabling this option each of your app users can have only one active session. If another login is detected, the old session is expired immediately. Hope this helps.
  4. Hi wdandrews, It seems like you forgot to disable HTML editor in a block, hence snippet of code is rendered as text. Hope this helps!
  5. Hi Gregstand, It looks to me that you need something similar to this. Hope this helps.
  6. Hi Mark, I believe that it is possbile. You may customize JS solution from this post: https://forums.caspio.com/index.php?/topic/3200-js-concatenatecombine-two-fields-into-one-field/ You need to change element_id to reference Virtual field(correct syntax: cbParamVirtualX ). You may also need to change an event trigger i.o. onsubmit. Hope this helps.
  7. Hi nuimage, I see that you have missed an assignment operator '=' in your code after "document.getElementById('EditRecordAttendees').value": So code in Footer should look like this: </div> <script> document.getElementById('EditRecordAttendees').value = parseInt(document.getElementById('EditRecordAttendees').value) + 1; document.getElementById('caspioform').submit(); </script>
  8. Google viewer frame will display embed document from Caspio if you encode the URL link of file stored inside Caspio account: So, URL link will look like this: https%3A%2F%2Fe1.caspio.com%2FdpImages.aspx%3Fappkey%3D____%26fileID%3D_____ I have used following link to generate the encoded URL. Hope this helps
  9. Hi RkaydianFlower I believe that it should be possible after 9.7 Caspio Bridge platform release. http://howto.caspio.com/release-notes/caspio-bridge-9-7/ Hope this helps.
  10. Hello wdandrews, I would suggest using a special form element on your search form called Cascading: http://howto.caspio.com/datapages/datapage-components/cascading-elements/ This element allows restricting a possible amount of option in child field based on the selection in parent field. Please note that "distinct" option is enabled by default for a different type of form elements (dropdown\listbox\radio button etc). Hope this helps.
  11. Hi MyNameIsSean, Caspio DB can only consume API calls currently. Perhaps you can take a look Zapier if they have an available Zap for email verification upon creating a record in Caspio. Hope this helps.
  12. Hi Julien, Did you put your script in Details datapage? Please note that you use the wrong syntax to reference the field. I would highly recommend looking at this Forum post: https://forums.caspio.com/index.php?/topic/4377-js-guide-caspio-form-elements/
  13. Hi nuimage, I do not beliave that this is possible. Perhaps you may take a look at method described on Howto: http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/ Hope this helps.
  14. Hi MattFL, I guess that is a system security restriction which you will not be able to overcome. http://howto.caspio.com/integration/web-services-api/rest-api/special-considerations/ You may try to authenticate the user based on another field type.
  15. Hi MyNameIsSean, How you considerate to implement an email verification process as described in this HowTo article: http://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-how-to-validate-a-user-email-address/ It should be much easier. Hope this helps.
  16. Hi McNamara, You may try to change attributes in class ".cbFormFile" in order to adjust the spacing. Hope this helps.
  17. Hello nuimage, Please note that @calcfield2 will have value after page load as per your described workflow, hence. I would suggest having two Datapages (Report&Single record update form) to replicate your workflow. On your Report Datapage you can place a link in HTML block to Single record update form and pass @calcfield2 value as a query string. Parameters-as-query-string-values Hope this helps.
  18. Hi Bill, I would suggest using Formula field in the table instead of the Calculated field. Formula-fields You may use "CASE" statement to create records correction logic in formula field. Create a Report with predefined filtering criteria based on formula field in order to display only records which need a correction. Hope this helps. Regards, vitalikssssss
  19. Hi Craig, Note that then you select a parameter in the email set-up it uses "value" and not display value. I am afraid that you cannot reference "display value". You need to have Virtual field with form element "Cascading TextField" selected. This element will filter the records in Job_Table by job number and pickup the job name. Please use method like in this article if you do not want to display Virtual field on form. Hope this helps.
  20. Hello telepet, I would suggest changing the number of "Rows to display" value (by default it has 5 rows) in the Advanced tab of Listbox setup.
  21. Hi roattw, You can concatenate several fields in single value with Formula field: Formula-fields Hope this helps.
  22. Hi cigarprofiler, You can retrieve the brand name by using Cascading elements.Cascading element will filter the brand table by value in the virtual field (brand_id). Here is a link to the tutorial article: Cascading-elements Hope this helps
  23. Hi mikeg, Your syntax to store a value in the variable is incorrect. You should reference Field value by id to assign the value to a variable: var a = parseFloat(document.getElementById("EditRecordArea1_Sq_Ft").value); Check this post for more information js-perform-a-calculation-on-values-entered-in-a-webform
  24. Hi mikeg, I assume that you are using "Single record update" form in your case and you have initial values already stored in a table, am I correct? If so it seems like field value marked as "NaN" does not have any value stored. Please describe how do you retrieve the values such as [@field:Area1_Sq_Ft] ? This code will not work since you have not defined IsNull function between <Script> tags however, it will work in Caspio Calculated/Formula fields since this type of fields has isNull function defined.
  25. Hi mdav20, Your thought is going in the right direction. I would suggest having a table to store the data about installation/removal of tires. You can place a Formula field datatype to calculate hrs difference between hrs "installed" and "removed". Here is a link to Formula field article: Data-types/formula-fields You can use Pivot table report or Tabular Report (with grouping by tire_ID ) to calculate total hrs in use for each tire. Pivot-table Data_grouping
  • Create New...