Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by BaySunshine

  1. The fields in the Search form can be referred to as Value1_1, Value2_1, Value3_1 etc in the order they are displayed. So, to access Value_1, you can enter: document.getElementsByName("Value1_1").value or document.getElementByID("Value1_1").value Hope that helps. Regards,
  2. Hi @JolliBeng, In Download Settings, select data to be printed from the Details page instead of the Results page. In the Details page, add all the fields that you intend to display in the PDF. I hope that helps. Regards,
  3. Hi @kpcollier, You can freeze first columns from Results Page Options settings. https://howto.caspio.com/datapages/reports/fixed-rows-and-columns/
  4. Hi @wvantongeren, Also make sure to add a group by clause if there are multiple records containing the same ID. Is OffertNR an ID field? If it is then try the following: SELECT sum(Teller) FROM K_Schadekenmerken_Data WHERE OfferteNR = target.[@field:OfferteNR] group by OfferteNR For examples, check out https://www.w3schools.com/sql/sql_groupby.asp.
  5. Hi @JckDY, To use JavaScript in Caspio, please first take a look at This has the useful tips on how to address each form element in different types of DataPages. Also, Caspio does not require coding. Only if you want to customize your app and have very advanced features added to your app, then you may need some coding. Mostly an app can be created using the standard features and minimal JS code. Caspio has many helpful online articles and videos that can help you start with your app. https://howto.caspio.com/getting-started/
  6. Hi @Heineperson, Caspio has stopped supporting onsubmit code: https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/ Please try the following fix: <SCRIPT LANGUAGE="JavaScript"> document.addEventListener('BeforeFormSubmit', function (event) { var x0 = document.getElementsByName("EditRecordassociatedSpecies")[0].value; var x1 = document.getElementsByName("cbParamVirtual2")[0].value; if (x0 && x1) { document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0+"; "+x1; } else { document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0 + x1; } }); </SCRIPT>
  7. Hi @skyflare1, This code assumes that the phone field in your table have values with a hyphen in them. And regarding login, code will work on the search form whether or not you have a login on your form. I hope that helps.
  8. Hi @AndrewCHughes, The query provided by @Vitalikssssss works when a integer field . For example, ID=5. No need of adding quotes on either side. What were you using for your where condition? Regards,
  9. Hi @kpcollier, You can use a Calculated Value field if this is for a Submission form and write a Select query to fetch the correct value. For example, your select query can look like the following: SELECT JOB_NUMBER FROM TABLE_NAME WHERE JOB=TARGET.[@FIELD:fieldname] fieldname = exact field_name from the current datasource. Similarly include the exact field names for JOB_NUMBER, TABLE_NAME and JOB from the table you are pulling the values from. I hope that helps. Regards,
  10. Hi @NJConrcs, You can try the instructions from this article except that replace virtual field with a real field from the table since virtual fields do not store values in a table: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ Hope that helps. Regards,
  11. Hi @Perzival, The solution for this question has been already answered in Regards,
  12. Hi @jardenblack26, Try adding '!important' at the end of your code. For example, width=10px !important. Here is a link for info on this rule: https://css-tricks.com/when-using-important-is-the-right-choice/ Regards,
  13. Hi @Scott, In the Email block, change the table name from ABGCMembershipCoporate to Inserted. For the update trigger, change one of the fields in Inner Join to RenewalsTable.MemertsiopGUID. Right now it is joining only on its own record. So, the update will happen always whether or not it matches with GUID field from RenewalsTable or not. I hope this helps. Regards,
  14. Hi @scottknz, A simple way to show an icon is to save the email image on your web server. In the form, use an HTML block and click on the image button and add the URL of your email image. Specify the height, width etc. In the Advanced tab, select 'continue element on the same line' option. Hope that helps. Regards.
  15. Hi @rrodask, To resolve this issue, try select 'inserted' table from the list instead of 'tbl_r1_ronda_quala'. Hope that helps. Regards,
  16. Hi @Mtasc, @NealPatil, @edujobs2k18, Caspio displays the date values in the table in only US format. The localization option only applies to DataPages. So, you can download the data from a Report DataPage to view the output in your chosen format. Hope that helps. Regards,
  17. Hi @Magnum, Please verify the following: 1) Is the join Notes_Log.UserId = User_Auth.Email correct? 2) Are Notes_Log.ClaimNumber and User_Auth.Email both unique fields in their tables? If the above are right, there doesn't seem to be any error with the trigger. Please provide a screenshot of the table designs of both tables so we can test. Regards.
  18. Hi @NeoInJS, Another way to do this without using JavaScript is by using triggers. If you do not have triggers in your plan, please ignore this idea. First in the submission form, create a Rule which hides the Permanent Address field. If the checkbox is checked, then show it and the user enters the address. If not, it will be hidden. If the checkbox field is not checked, the trigger will execute. Create a trigger on this table which will update the inserted record with "Permanent Address = Present Address" only when the checkbox is checked. Hope this helps. Regards.
  19. Hello @RJOHNSON, There is a way to do this using standard features. Here are the steps: 1. Add an Autonumber field to your table. 2. In the submission form, add a Virtual field. Make sure you create this field under a separate Section. 3. Set its form element to 'Calculated Value'. 4. Enter a formula for the field: select top 1 fieldname from tablename order by id desc Replace fieldname and tablename with the respectives names from your table. 5. Click on Rules and create two rules as below: RULE 1: Under criteria, select the virtual field and operator as 'Is Not Blank'. Under Actions, select Action as 'Hide' and choose the section this Virtual field falls under. This will make sure that the Virtual field value is hidden. RULE 2: Under criteria, select the virtual field and operator as 'Greater than or Equal', and Value as 200 or your desired number. Under Actions, select Action as 'Disable' or 'Hide' as per your requirement and choose the field name that you want to disable. The only downside of this idea is that the virtual number spins while it is still calculating the value. But after that everything works as expected. Hope this helps. Regards,
  20. Hello Scott, This can be done by an update trigger followed by an email trigger on that table. Please attach an image of your trigger so we can see where the issue is. Thanks.
  21. Hello @directrix, The formula worked for me. What is the datatype of your fields? I have D_Date as Date/Time, D_Serial as Number, D_Text as Text. The error can be caused by the data that you entered as well. Provide us sample data that you entered and I will try to reproduce the issue. Regards,
  22. Hello RBobowski, Expressions can be used in Select statement the way you did. You could also use 'Equal' or any other comparison operator instead of 'Exists' and compare the value with the aggregate calculated in the Select statement. Triggers do not allow usage of variables in Caspio like we do in any other programming language. You can have an alias for a field in the Select statement and use that alias in other parts of the same query such as in Where, Group By etc but cannot use it in other trigger actions such as insert, update or delete. Hope this helps. Regards,
  23. The fields in the Details page are addressed as 'EditRecordFIELDNAME' with field name being the actual name of the field as it is in the table. Please refer to this article for help on how to address different Caspio form elements in JavaScript code. By just changing the field name as per the above format in the code from the other forum article should get you the desired results. I hope this helps.
  24. Is one of those fields a formula field by itself? To troubleshoot the error, I suggest you to try one case...when at a time. Make a duplicate of your table or add a test record to your existing table and test it out. This way you can narrow down to see which particular field/condition is causing this error. I hope that helps.
  25. Hello humidor, Yes, you can do this by following the steps below: 1. Make the formula field as 'display only'. 2. Add a virtual field of checkbox type. 3. Use 'Rules' to hide the separate field based on the value of a checkbox. 4. If the user chooses to change the date, they enable the checkbox and the separate field shows up. 5. User can enter the data and hit 'Submit'. Hope this helps. Regards,
  • Create New...