Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @Stepford, You can find this information in the HowTo library. https://howto.caspio.com/apps/importing-an-app/ Regards, vitalikssssss
  2. Hi @rgiljohann, You can delete a record with "Delete" action block. You can also set a "Where" condition in order to delete records conditionally. Hope this helps. Regards, Vitalikssssss
  3. Hi @Stepford, Perhaps exported copy of my datapage will provide you a better understanding. Ples Please refer to Datapage named "Company_table_conditional pop_up" and check the code from HTML block. Regards, vitalikssssss CaspioData_2018-Sep-06_1315.zip
  4. Hi @edujobs2k18, You may try to use the following Javascript solution: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { var entered_value = document.getElementById("InsertRecordDate0").value; var entered_date = new Date(entered_value); var permitted_date = new Date(); permitted_date.setDate(permitted_date.getDate()); if(entered_date < permitted_date) { alert("Cannot be a date in the past"); return false; } }); </script> This solution is designed for Submission form with AJAX enabled. Also, field name "Date0" used from your post. Hope this helps. Regards, vitalikssssss
  5. Hi there! Does anyone have a JS/Jquery solution to restrict the user to be able to enter only time value in a field (Text255)? I have a Tabular Report datapage with inline edit enabled. Thanks, vitalikssssss
  6. Hi @Scott17, You can use simple Javascript code to copy the value from one field into another. You may use this snippet of code as an example: <SCRIPT LANGUAGE="JavaScript"> function copy() { var date1 = document.getElementById("ValueX_Y").value; // X_Y values based on the layout of your fields document.getElementById("ValueX_Y").value = date1; // X_Y values based on the layout of your fields } var date1 = document.getElementById("ValueX_Y").onchange=concatenate; </SCRIPT> - ValueX_Y - X is the form element order, which starts at 1 and increments based on the order of the element in the form. - Y is the criteria. It starts at 1 and increments based on the criteria order. It is always 1 if the field has no extra criteria. You may refer to the following topic which explains how to refer to Caspio Form elements: Hope this helps. Regards, vitalikssssss
  7. Hi @edujobs2k18, I believe that you are not able to validate your expression because of your field name under SUM function. Please note that you should use the name of the field from your table "Student_Master" and be careful since the system is case-sensitive. Hope this helps. Regards, vitalikssssss
  8. Hi @edujobs2k18, You can restrict editing of the field with Conditional Rules. Please check this topic for more insights:
  9. Hi @MrsMedia, You can set predefined filtering criteria based on autonumber field and set a range as follow: Criteria 1: Greater than or equal 1 Criteria 2: Less than or equal 10 and it will return only the first 10 records. Hope this helps.
  10. Hi @cdutoit62 , Please note that only editable fields available in Conditional Rules. It doesn`t make a difference if you use standalone Details page i.o. Details section from Tabular report from my example. Hope this helps. Regards, vitalikssssss
  11. Hi @cdutoit62, I can suggest following steps to create your workflow: 1. Create a field in your table which will store an expiration date. You can use DateAdd() function in the Formula field. https://howto.caspio.com/function-reference/ You can use Triggered action or Calculated Value form element if you don`t want to set expiration date manually. 2. Create a –°onditional Rule on Details section of your Tabular Report. You need to set up a Rule which compares the current date with the expiration date. Please add a Virtual field and assign a hidden form element to it with a Timestamp default parameter. 3. Make all fields editable on Details section (assign TextField form element). 4. Create a conditional Rule which will make fields "Display only" if the expiration date is less then the Virtual field. You can check this article for further information about conditional rules: https://howto.caspio.com/datapages/forms/conditional-forms/ Hope this helps. Regards, Vitalikssssss
  12. Hi @MrsMedia, I can suggest using multiple Datapages (Gallery) on the single web-page. You can specify custom text in the Header of each Datapage. Hope this helps. Regards, Vitalikssssss
  13. Hi @Stepford, What datapage do you use? I have a Tabular Report datapage with an HTML block in which I have a JS which display the link to a pop-up based on the condition. Here is an example of Javascript code I`ve used: <div id='record[@cbRecordIndex#]'></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ("[@field:Name]" == "Jalian Corp") { document.getElementById("record[@cbRecordIndex#]").innerHTML="<a class='cbMenuItem' href='#' onclick='window.open(\"https://c3fot067.caspio.com/dp/498C4000f7c51a179b034f26a6a5\", \"mywindow\", \"menubar=1,resizable=1,width=500,height=500\")'>Link</a>"; } else { document.getElementById("record[@cbRecordIndex#]").innerHTML="Profile In Progress</strong>"; } }); </script> Hope this helps. Regards, vitalikssssss
  14. hi @roattw , You need to check if your filtering criteria on the report page were joined with "AND" block. Hope this helps.
  15. Hi @Medron, What type of messaging system do you need? I know that Real Estate application template contains a form which app users can use to send a message to a broker. You can check the functionality here: https://www.caspio.com/real-estate-listings/ Hope this helps. Regards, vitalikssssss
  16. Hi @satch, Do you store images in public repositories? or maybe you plan to store them in Caspio? Please let me know. Regards, vitaliksssss
  17. Hi @satch, Would you like to show a URL which user can click after he/she inputs the file reference name? Please correct me if my understanding of this inquiry is not correct. Thanks, Vitalikssssss
  18. Hi @HughD, I would recommend taking a look at Triggered action feature. You can set up a Trigger which will delete the record if it doesn`t meet the requirements and also you can set up an Email Trigger to inform the user that his record was rejected. You can find more details in this article and there is a video available too: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, vitalikssssss
  19. Hi @satch, It looks like you can utilize a 13.0 Caspio Bridge feature called "Calculated Values". You can check a release notes for further information about this feature. https://howto.caspio.com/release-notes/caspio-bridge-13-0/ Hope this helps. Regards, vitalikssssss
  20. Hi @rgiljohann, You can pass parameters on exit from the Search form if you have one in your Datapage. I do not think it will be possible to pass parameters from Result set except via query string. Hope this helps. Regards, vitalikssssss
  21. Hi @kvarjavand, I communicated with Caspio Support about the similar issue the other day and they told me AJAX functionality currently enabled on submit / login events which can refresh embedded datapage without page reload. I am afraid that Edit/Insert/Delete events on tabular report do not trigger AJAX datapages refresh. You can submit a feature request to Caspio product team via IdeaBox . Hope this helps. Regards, vitalikssssss
  22. Hi @Magnum, You can use calculated fields with SQL query to count id`s and to retrieve an oldest and the latest date user submitted case id. Finally, you can use DateDiff() function to calculate a number of days the user has been working on the case. You can check the following article for further information about SQL usage in Caspio: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You can check the following topic if you prefer to exclude weekends, holidays from a number of days which individual has spent during working on the case: Hope this helps. Chrees, vitalikssssss
  23. Hi @SteveAeroOps, It is a really strange issue. Do you use View as a data source for the datapage in question?
  24. Hi @MichaelB, I didn`t receive the "Failed integrity check" error message. This error means that you have a relationship with "Referential integrity" enabled. This option will not allow creating a record in "child" table if an ID value is not presented in a "Parent" table. Blank values in a "child" table also giving the same error. Hope this helps. Regards, Vitalikssssss
  • Create New...