Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


BaySunshine last won the day on February 2

BaySunshine had the most liked content!

About BaySunshine

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @FinTheHuman, Add left and top features to your code and you should be able to place it anywhere on the window. <a class="workorder" href="#" onclick="window.open("https://www.google.com/","mywindow", "menubar=1,resizable=1,width=750,height=950, top=150, left=500")">Google</a> I hope this helps.
  2. Hi @george43, Thanks for correction. I missed it. Yes, it should be document.getElementsByName("Value1_1")[0].value.
  3. 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,
  4. 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,
  5. Hi @kpcollier, You can freeze first columns from Results Page Options settings. https://howto.caspio.com/datapages/reports/fixed-rows-and-columns/
  6. 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.
  7. 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/
  8. 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>
  9. 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.
  10. 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,
  11. 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,
  12. 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,
  13. Hi @Perzival, The solution for this question has been already answered in Regards,
  14. 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,
  15. 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,
  • Create New...