Vitalikssssss

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

Hi there!

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

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

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

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

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

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.

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

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

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

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

hi @roattw , You need to check if your filtering criteria on the report page were joined with "AND" block. Hope this helps.

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

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