Jump to content

Vitalikssssss

Caspio Evangelist
  • Content Count

    518
  • Joined

  • Last visited

  • Days Won

    51

Everything posted by Vitalikssssss

  1. Hi roattw, You should make sure that you have used correct names of table/column (case sensitive). You may try to use the following expression: select count(user_id) from table_name where CME_Category='Value' Hope this helps.
  2. Hi Accountability, Have you put this part in a Header of the Datapage? <div id="datefix"> Can you send me a screenshot from your browser console? Perhaps we`ll be able to trace an error from there. Regards, vitalikssssss
  3. Hi MyNameIsSean, It looks like the issue has been fixed. I have been able to create a Trigger which inserts the Timestamp value from parent table into Date&Time field. Regards, vitalikssssss
  4. Hi 888Washington, You can lookup for reference record in another table by creating a Join with #inserted. It is difficult to offer you a precise solution without table structure or a screenshot of your existing Trigger. By the way, I have recently signed up for the Webinar: Introduction to Triggered Actions. Perhaps you will be able to find an answer or some insights there. You can sign-up via following links: Wed, Oct 25, 2017 3:00 PM - 4:00 PM EEST Wed, Oct 25, 2017 9:00 PM - 10:00 PM EEST Thu, Oct 26, 2017 3:00 AM - 4:00 AM EEST Hope this help
  5. Hi Melwyn, I have a doubt that desired functionality can be achieved with Triggered Actions feature. I have a Trigger in my App which concatenates first and last reference number into a single Text(255) field. You may try to achieve desired functionality on a Datapage level by using the Javascript solution from this Forum topic. It will allow you to store selected values in one field which will be separated by a comma. Hope this helps.
  6. Hi Accountability, Try the following code: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRecordDefined_Time_Out').onchange = DateCheck; </script> </div> I have corrected some minor
  7. Hi MyNameIsSean, That is very odd behavior which I believe will be resolved in an upcoming Caspio Bridge release. In the interim, you can try to build the Triggered action as per below as a temporary workaround. Hope this helps.
  8. Hello Accountability, I would suggest using following code if you prefer to restrict form submission if the condition "dateout <= datein" is met: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRe
  9. Hi Sudesh, It looks to me that you have used Data/Time data type. You should use Text(255) datatype for the field in question. Hope this helps.
  10. Hello NeoInJS, Perhaps you can try to replicate the desired layout with Pivot table. http://howto.caspio.com/datapages/reports/pivot-table/ Hope this helps.
  11. Hi Newgoblin49, You can create a relational database in Caspio. You may find more details here: http://howto.caspio.com/tables-and-views/relationships/ Hope this helps.
  12. Hi rickin21, You may try to change the triggering event to ".onsubmit". <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value); var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value); var v_rates = parseFloat(document.getElementById("InsertRecordRates").value); var v_ratesot = parseFloat(document.getElementById("InsertRecordRate_OT").value); var v_amount = ((v_hours * v_rates)+(v_hoursot * v_ratesot)); document.getElementById("InsertRecordAmoun
  13. 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
  14. 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.
  15. 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
  16. 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.
  17. Hi roattw, You can concatenate several fields in single value with Formula field: Formula-fields Hope this helps.
  18. 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
  19. 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.
×
×
  • Create New...