Jump to content


Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


Vitalikssssss last won the day on September 6

Vitalikssssss had the most liked content!


About Vitalikssssss

  • Rank
    Advanced Member

Recent Profile Visitors

1,198 profile views
  1. Vitalikssssss

    How to create a conditional link?

    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
  2. Vitalikssssss

    Blocking Past date selection

    Hi there!
  3. Vitalikssssss

    JS Date Restrictions Quit Working

    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
  4. Vitalikssssss

    Time input mask

    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
  5. Vitalikssssss

    Search within range

    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
  6. Vitalikssssss

    Insert and Update Sums in other Table

    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
  7. Vitalikssssss

    Java Script Rule In Update Form

    Hi @edujobs2k18, You can restrict editing of the field with Conditional Rules. Please check this topic for more insights:
  8. Vitalikssssss

    Trying to group gallery results

    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.
  9. Vitalikssssss

    Timed editing block

    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
  10. Vitalikssssss

    Timed editing block

    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
  11. Vitalikssssss

    Trying to group gallery results

    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
  12. Vitalikssssss

    How to create a conditional link?

    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
  13. hi @roattw , You need to check if your filtering criteria on the report page were joined with "AND" block. Hope this helps.
  14. Vitalikssssss

    In-app messaging update

    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
  15. Vitalikssssss

    simpe form to open image url

    Hi @satch, Do you store images in public repositories? or maybe you plan to store them in Caspio? Please let me know. Regards, vitaliksssss