Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by WatashiwaJin

  1. You can also check the full documentation about calculated values here: https://howto.caspio.com/datapages/datapage-components/calculated-values/
  2. For more information about this, you can also check Caspio's online help center: https://howto.caspio.com/function-reference/ https://howto.caspio.com/datapages/datapage-components/calculated-values/ https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ I hope this helps
  3. For further information, you can also check this helpful documentation about Styles in Caspio's online help center: https://howto.caspio.com/styles/ https://howto.caspio.com/styles/customizing-styles/ I hope this helps
  4. If you also wanted to check if the inputted value for "receiversname" field contains or is in the "combined_user_name" field of the table "UserAuthenticationTable", then you can try this Formula instead: CASE WHEN ([@field:receiversname] IN (SELECT combined_user_name FROM UserAuthenticationTable)) THEN 'Yes' ELSE 'No' END
  5. Check this article @DaveC2019: This might also help you, for your work-flow.
  6. And you can also refer to this article if you want the code to hide a column per condition:
  7. Hi @888Washington, You can also just try to use this code instead: <script type="text/javascript"> var elems = document.querySelector(".cbResultSetTable tbody").children; console.log(elems); for (let i = 0; i < elems .length; i++) { elems[i].children[07].style.display = "none"; elems[i].children[08].style.display = "none"; } </script> Just change the child number in this line "elems.children[07].style.display = "none";", first column is "0" and so on. Note: Add this code inside your Footer, make sure that you unchecked the "enable HTML Editor" in the advance option. I hope this helps ~WatashiwaJin~
  8. You can also refer to this article for more information:
  9. You can also add a formula field in your table that will get the overall TOTAL of the user evaluation. For Example (Formula field: TOTAL): [@field:EVALA] + [@field:EVALB] + [@field:EVALC] + [@field:EVALD] Then you can just call that one field in your calculated field instead: SELECT TOP 1 (TOTAL) FROM TABLE_EVAL WHERE USERS = '[@authfield:User_ID]' ORDER BY Feedback_ID DESC I hope this process also helps you ~WatashiwaJin~
  10. Hello @IamGroot, For you to be able to get the last score from your user's self evaluation, you can just use this SQL formula in your calculated field instead: (SELECT TOP 1 EVALA FROM TABLE_EVAL WHERE USERS = '[@authfield:User_ID]' ORDER BY Feedback_ID DESC) + (SELECT TOP 1 EVALB FROM TABLE_EVAL WHERE USERS = '[@authfield:User_ID]' ORDER BY Feedback_ID DESC) + (SELECT TOP 1 EVALC FROM TABLE_EVAL WHERE USERS = '[@authfield:User_ID]' ORDER BY Feedback_ID DESC) + (SELECT TOP 1 EVALD FROM TABLE_EVAL WHERE USERS = '[@authfield:User_ID]' ORDER BY Feedback_ID DESC) In this formula, it will just get the last value of (EVALA, EVALB, EVALC, & EVALD) in the TABLE_EVAL depending on the user logged in your DataPage. I hope this helps ~WatashiwaJin~
  11. Hi @IamGroot, If that is the case then you can try using this script instead: <div id="[@cbRecordIndex]"></div> <script> document.addEventListener('DataPageReady', function (event) { if ("[@authfield:UserType]" == "Employee") { var yourfield = document.getElementById('[@cbRecordIndex]'); if ("[@field:Inquiry_Type]".trim().toLowerCase() == "only admin") yourfield.parentNode.parentNode.style.display = "none"; } }); </script> You can also try this documentation in that kind of process: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/ I hope this answer your question. ~WatashiwaJin~
  12. Hey @FinTheHuman, You can try using this code for your Tabular DataPage: <div id="[@cbRecordIndex]"></div> <script> var yourfield = document.getElementById('[@cbRecordIndex]'); if ("[@field:Process]".trim().toLowerCase() == "Completed") yourfield.parentNode.parentNode.style.display = "none"; </script> Add this code inside HTML Block or in the Footer of your DataPage. Make sure the you unchecked the "Enable HTML editor". I hope this helps :) ~WatashiwaJin~
  13. Hey @FinTheHuman, I have a similar problem before, what I did is just get the DATEPART to eliminate the time value. I hope this helps ~WatashiwaJin~
  14. If you use Calculated field or value in this case, than you can use this formula to display the total number of records in your table: SELECT COUNT([@field:ID]) FROM tablename Please change the field:ID to your actual unique-identifier field and the tablename to the actual table you wanted to get the total of records. For more information about the formula function you can use in the calculation, check out this documentation: https://howto.caspio.com/function-reference/ I hope this helps ~WatashiwaJin~
  15. Hi @sergekaramazov, Your current structure is good, and it can be construct even better. As what @SunakoChan said, for you to successfully achieve the goal of your application you need to make sure that the tables are well-structured. And the first step in creating a web-based application is to build a normalized table. ___________________________________________________________ For : - This process can be all done/create inside your table or View, the helpful documentation is provided above(by: SunakoChan). And for this: - You can use Caspio's Report DataPage(s) to display all the records in your Inventory items. Check this Documentation: https://howto.caspio.com/faq/reports-datapages/ https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-embeddable-tabbed-interface/ Lastly, for: - What you can use for adding a new recipe sheets is Caspio's Submission form. Check this documentation: https://howto.caspio.com/datapages/forms/submission-forms/ _________________________________________________________________________ You can also check the free Ready-Made-Application that Caspio offer here. You may found a similar RMA for your application. And by the way, there are many great ways to learn Caspio platform. Caspio also offer free instructor-led training sessions multiple times per week and are open to everyone. However, you must sign up to reserve a seat. You can sign up to this link. I hope this helps ~WatashiwaJin~
  16. Hello @GLENNSTER, You can also use a calculated field in generating a Timestamp, check this documentations: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ And check this function references you can use in the Formula and calculated field: https://howto.caspio.com/function-reference/ I hope this helps ~WatashiwaJin~
  17. Hello @stevetimko, You can also refer to this video tutorials in adding a SUM result in your reports DataPage: I hope this helps ~WatashiwaJin~
  18. Hello @utdfederation, You can refer to this Caspio's video tutorial in creating a Registration and login form inside Caspio Bridge: I hope this helps ~WatashiwaJin~
  19. Hi @Elena, What I suggest for you to lessen the slowness of your page is: - limit the use of List- strings, drop-downs, images, and other fields that will load multiple data or large amount of file size. - Also limit the script code that you use. I think the calculation, virtual fields and parameters won't take affect the slowness of your page. ~WatashiwaJin~
  20. Hello @greyfoundation, If you wanted your End-User to select a table for the DataPage in your Website, I afraid to say that is not possible. What I suggest for you to do is create a View and use that in the DataPage , for you to be able to search a data in multiple table. Check this documentation about Creating Views. I hope this helps ~WatashiwaJin~
  21. Hello @normindr, You can also refer to this documentation about using datediff in calculated field: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ ~WatashiwaJin~
  22. Hello @DoDoTwin, I would like to infor you that you can use a "Calculated Field" in your Reports DataPages that can get the difference of your Date field and the current date. Check this documentation, for more information: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ I hope this helps. ~WatashiJin~
  23. Hello @joneslovescaspio, I just wanted to informed you that you can also check Caspio's latest updates in there twitter site at https://twitter.com/caspio I hope this helps ~WatashiwaJin~
  24. Hello @FinTheHuman, If you are referring, that the user has logged-in to your Website/DataPage and you want to set a reminder in a specific minute then you will need a simple script for that. Try using this code: <script> document.addEventListener('DataPageReady', function() { if ("[@authfield:tbl_User_Type]" == "Employee") { setInterval(function() { alert('You are currently logged-in as an Employee, please checked your Daily Task !!'); }, (30*60)*1000); } }); </script> You can also change the number of minute in this line of code: "(30*60)*1000" (the one that is highlighted). Note: Please add this code inside the Footer of your authenticated DataPage and make sure that you unchecked the "enable HTML editor" in the advance option. I hope this helps! ~WatashiwaJin~
  25. Hi @FinTheHuman, This is also might be helpful to you, the report will display the days remaining before the user's birthday. CASE WHEN Datediff(Month,[@field:Birthday],GetUTCDate())=0 AND Datediff(Day,[@field:Birthday],GetUTCDate())=0 THEN 'Happy Birthday to you!' ELSE CONVERT(VARCHAR(10), Datediff(Day,[@field:Birthday],GetUTCDate()), 101) + " days, before your Birthday" END I hope this helps ~WatashiwaJin~
  • Create New...