Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by TsiBiRu

  1. HI @kpcollier, You're welcome, I'm happy to now that this is working for you now. It was my pleasure to assist you with this. Kind regards, TsiBiRu
  2. Hi @kpcollier, To test if the code is working, I would suggest to look in the URL and see if the parameter contains a value. If it has a value, then it only confirms that there is nothing wrong with your code. We just need to fix this on the receiving part and ensure that we are receiving it using the exact variable name [@val] in this example In regards to your second question, you will simple need to add a new HTML block to and create a new/2nd drop-down <!-- As you can see, I've added '2' in my id below id='2[@field:Listing_ID], this is to diffrentiate it with o
  3. Hi @kpcollier You are already right, you will just need to update the variable on your on load to match the one that we've passed in our code So that would be [@strUser] in my example. window.location.replace("https://www.google.com?val=" + strUser); Regards, TsiBiRu
  4. Hi @kpcollier No worries, it is always my pleasure to help anyone in this community. You can try to use the code below, I've added two HTML blocks on my Tabular Report Datapage. 1st HTML Block is to display the drop-down <!-- I've set the ID to the ID of the records so that we will pass the selected value from the drop down where the button is clicked--> <select id='[@field:kpcollier_Client_ID]'> <option value="[@field:Primary_Client]">[@field:Primary_Client]</option> <option value="[@field:Additional_Client]">[@field:Additional_Client]<
  5. Hi @kpcollier I've created a solution for this and provided it to your post below Regards, TsiBiRu
  6. Hi @kpcollier If what you want is to create a dropdown which contains values from your two fields, the I can suggest that you create your own custom drop-down, and use the value of your fields for both the display and stored value. <select id='dropID'> <option value="[@field:FieldName]">[@field:FieldName]</option> <option value="[@field:FieldName]">[@field:FieldName]</option> </select> I hope this helps, Regards, TsiBiRu
  7. Hi @bbeshlian, The code below does not hide the submit button, but it will prevent the user from submitting the form until the entered value is valid. For this solution to work, the value of the Virtual 2 (Which is a calculated field ) should be positive So basically, the code below will get the value of 'Virtual2' field and if the value is negative it will prevent the form from being submitted until the value of this field is a positive number. <script> document.querySelector('#caspioform').onsubmit = function(e) { e.preventDefault(); var balanc
  8. Hi @DaveC2019, So that we can assist you better with this, kindly provide as an exported copy of your DataPage so that we can formulate the validation directly to it. Please export it with its dependencies If your ables contains sensitive information then you can just export your table without Data, to reach the interface below you will need to click the 'Add' button first. Kind regards, TsiBiRu
  9. Hi @bbeshlian, Can you point me to the forum post where I've provided this code, please? And you can also provide us the direct URL of the DataPage that you are currently working so that we can make the necessary adjustment to make the code work. I'm guessing that we just need to update the this line 'var amount = document.getElementsByName('Virtual2')[Invalid].value;' Regards, TsiBiRu
  10. Hi @PackDaddy, I've created a sample Datapage with your workflow so that you can download and import it to your account so that you can see how it works. Please see the attached file Earth Moon MARS What I did are the following: 1. I've created virtual fields to allow the user to enter the weight of each the objects, and allow them to select the Space Object (Earth, Moon, Mars) 2. Then I've created an HTML block to display the message 3. After that, I've added the fields from my table that will get its value from the user input.
  11. Hi @bbeshlian, I'm happy to know that I was able to help you with this one. Regards, TsiBiRu
  12. Hi @bbeshlian, I was able to create validation without using JavaScript, what I did is the following: 1. I've created a virtual field and use the SQL statement below to compare the dates ( installment payment date (Date1) and effective date (Date2) ) to determine if it is valid or not. 2. I've hidden that virtual field using the method in this article CASE WHEN [@field:Date1] < [@field:Date2]THEN 'Invalid' ELSE 'Valid' END 3. Then I've inserted an HTML block to display the error Message, and added it to section two. 4. Then I've created a rule that will on
  13. Hi @bbeshlian, That is good to know. Regards, TsiBiRu
  14. FHi @bbeshlian, If you want to set a default value to your number/currency field you can achieve this using two options. 1. Is setting/assigning the default value in your Datapage(Usually Submission Form), go to the Advanced Tab of your field then click on 'On load' and try to make it like the one below. 2. The other option is via Trigger action. For more details about this kindly check this Article I hope this helps. Regards, TsiBiRu
  15. Hi @DaveC2019, Just follow the steps that I've provided in my previous comment, especially adding a virtual field where we will use an SQL statement to check if the inputted receiver name is in your table. And just update the 'cbParamVirtual1' in the code below accordingly <script type="text/javascript"> // This function will run if the value in our Virtual1 is change document.getElementsByName('cbParamVirtual1')[0].onchange = function() {myFunction()}; function myFunction() { // This code will get the value of Virtual1 var test = document.getElementsByName('cbParamVirt
  16. Hi @kkounkel, When you say you wanted to send a random policy manual to your employees, what are the expected behavior of your workflow? 1. Does all of your employees will receive the same random policy manual per week or each employee can have a different manual that is sent to him/her per week? 2. Do you want to restrict duplicate policy manual being sent to your employee (An employee can't receive the same manual again unless all the other manual is received)? - If yes, what will happen when all the manual has been sent(Do you intend to start a new round, like starting t
  17. Hi @joneslovescaspio, Kindly elaborate on your workflow, so that we can better help you with this. Regards, TsiBiRu
  18. Hi DaveC2019, What you need to do is to add a virtual field in your submission form, then set its form element as a calculated field and use the SQL code below to check if the receiver name that the user entered can be found in your user authentication table. I've also added the exported copy of the sample DataPage that I've worked with, just import it to your account so that you can see how it works. Kind regards, TsiBiRu You can try using the SQL below, the code below will get the a value from your 'combined_user_name' field in your 'UserAuthentication' table if
  19. Hi @twinsdad, Just to add up to the previous comment, to turn off the default results if nothing is entered into the search you can set your report DataPage to 'Display search form and results on separate screens' By setting it up this way, it will not display any results until the user searched for something. For more details about this, you can check this article I hope this helps. Regards, TsiBiRu
  20. Hi @DesiLogi, I think your code above is not set to go to 'Next Record' in your details page, it will simply submit/update the record that is currently on the first record that is being displayed on your Details Page. It is just like clicking directly on the Update button, and after that, you will be redirected to the Results Page. Because if you analyze your code, let's say that the value of your virtual field now is 10, so it will go to your else condition (which is basically the code below) which will submit/update the record. After that, it will be redirected to the results page
  21. Hi @joneslovescaspio, Just to add up to the previous comment, I think it would also be better if you check this article it contains useful information about some issue that you may encounter with your JavaScript codes when the Ajax loading is enabled. And it contains information on how to fix it. I hope this helps Regards, TsiBiRu
  22. Hi @ hctr1 I've just tested the code below directly on your web site using the Dev Tools, and I can confirm that the code below is now working. You just need to copy and paste this code on the footer of your DataPage and that should do it. <script type="text/javascript"> document.getElementsByName('cbParamVirtual1')[0].onchange = function() {myFunction()}; function myFunction() { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); } </script> Let me know if you will still encounter some issue. Regards, T
  23. Hi @hctr1 Thank you for providing the deployed URL of your DataPage and a login credential. I had a hard time making this solution work on your webpage as well. When I access your DataPage directly using your deployed URL (https://c5esh804.caspio.com/dp/b1c76000b16b1c0bcbb643b38c67) this code works, which will submit your submission DataPage. Kindly try this on your end as well <script type="text/javascript"> document.getElementsByName('cbParamVirtual1')[0].onchange = function() {myFunction()}; function myFunction() { // submit the form if an value is selected setTimeo
  24. Hi @hctr1, You are using a Submission Form/DataPage, right? You can just try to disable the Ajax loading in your DataPage, just click on this button. If you are still having an issue making the solution above work, please provide me the deployed URL of your DataPage, and I will try to fix this for you. Regards, TsiBIRu
  25. Hi @hctr1 To find the ID of your dropdown just follow the steps below. 1. On the preview or deploy mode of your Datapage press F12 on your keyboard to open the Dev Tools in your browser 2. Then press Ctrl+Shift+C on your keyboard, or simply click on this Icon, just make sure that it is highlighted. 3. Click on your Dropdown, the element attribute of your dropdown should be highlighted Just double click on the 'id' (cbParamVirtual1 in this example), then copy and paste it to our code in my previous comment. I hope this help. Regards, TsiBiRu
  • Create New...