Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @ministry, You can achieve the desired functionality with standard functionality of Caspio. You need to create a separate authentication for each user group: "Normal", "Admin" and use this authentication on Datapages which are relevant to each group. You may check this video for more insights: https://www.youtube.com/watch?v=YEzM1c624Jk Hope this helps. Regards, vitalikssssss
  2. Hi @Alison, You can design Trigger in such a way which allow you to achieve the desired functionality. You need to make sure that: 1. Your parent/child table has one-to-many relationship; 2. You create a special table which will be used as insert template. 3. Please note that you would need to list the same number of records in insert template as the number of days which you could have in the date range. 4. You need to create a Trigger. You may import my example into your account and check the structure there. Regards, vitalikssssss Submit_multiple_records_date_range_1_0_2018-Sep-28_1423.zip
  3. Hi @Berti, I can say that Caspio uses HighChart library to render the chart. I don`t have a solution for your described case but perhaps you can try to use a solution from this topic: Stackoverflow Regards, vitalikssssss
  4. Hi @rgiljohann Please note that Caspio form does not support on load event handlers and you need to use Caspio built-in event handlers. The onload event should be replaced with Caspio built-in event as shown below: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { // do something }); </script> You can find more details in this article: https://howto.caspio.com/deployment/ Hope this helps. Regards, Vitalikssssss
  5. Hi @JaredL, You can find a solution in this forum topic:
  6. Hi @Harbinger, You may try to use Formula field to concatenate values from two fields. The formula field is available as a field for RLS. https://howto.caspio.com/tables-and-views/data-types/formula-fields/ Regards, vitalikssssss
  7. Hi @kpcollier, Perhaps you can try to achieve the desired join with Full outer join type in View. You can also use filtering criteria in order to show only certain records. Full Outer Join – Includes all records in both tables, even when there are no matching records on the other side. In this case you will have both properties without agents and agents without properties. https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/ Hope this helps. Regards, vitalikssssss
  8. Hi @yballan3, As far as I know, you can initiate a scheduled task with REST API call. I am not sure if you will be able to implement REST API call from Wordpress web-page, because it requires some back-end coding. https://howto.caspio.com/web-services-api/rest-api/older-rest-api-versions/datahub-operations/ Hope this helps. Regards, vitalikssssss
  9. Hi @rgiljohann, I would highly recommend creating a separate trigger for on "Update" event which will delete the updated record if criteria met. You currently have all events enabled (Insert, Update, Delete) which might create a lot of confusion after you try to test the Trigger. Also, you need to change "Delete from" clause to #inserted if you would like to delete only updated record if criteria is met. Hope this helps.
  10. Hi @Stepford, You can find this information in the HowTo library. https://howto.caspio.com/apps/importing-an-app/ Regards, vitalikssssss
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. Hi @edujobs2k18, You can restrict editing of the field with Conditional Rules. Please check this topic for more insights:
  18. 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.
  19. 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
  20. 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
  21. 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
  22. 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
  23. hi @roattw , You need to check if your filtering criteria on the report page were joined with "AND" block. Hope this helps.
  24. 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
  • Create New...