Jump to content


Popular Content

Showing content with the highest reputation since 10/15/2018 in all areas

  1. 3 points
    Hello @Medron, You can try this code: — Luna —
  2. 2 points

    Adding Media link in Caspio

    Hi, Yes, it is possible to Caspio. Caspio apps may be deployed to Facebook in two ways: 1. Canvas Page - This is your DataPage loaded as a Facebook standalone app. 2. Page tab - This is your DataPage deployment that is accessible directly from your business profile page. You can refer to this link for reference: https://howto.caspio.com/tech-tips-and-articles/social-media/create-facebook-apps-and-page-tabs-with-caspio-datapages/
  3. 1 point

    Source in HTML DataPage

    Hi, May I clarify if you are referring to the source of an HTML DataPage? Unfortunately, there is no data source in the HTML page, it is made by default. You can use it to implement pages using HTML and CSS.
  4. 1 point

    Adding Media link in Caspio

    Thank you, all your replies are so helpful. I have a question related to this post, How can I deploy my application to facebook? Is it possible?
  5. 1 point

    Grid edit by default

    @jasonkaeb You are welcome! I was glad to help you.
  6. 1 point


    Hi JckDY, The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below: Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Caspio also has training materials that can help you in building your applications. You may want to visit them: https://howto.caspio.com/ https://howto.caspio.com/getting-started/ https://www.youtube.com/CaspioInc -JolliBeng
  7. 1 point

    Rule Help

    Let's say if the value in another field is OTHER you want to unhide this field and make it require. Then you need to first add a section and have this field in a section as only one action per field is possible. Two rules you need: 1- Value = OTHER make the field required 2- Value is not equal = OTHER Make it Hidden So you are doing it the other way around instead of saying if value = OTHER Unhide you say If value is not OTHER Hide
  8. 1 point
    Hi kpcollier, I just discovered that it is possible to change the "View Details" text. You can modify it under Localization: -JolliBeng
  9. 1 point


    Hi Everyone! You can now have Calculated Values on your Web Forms. It is similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions. -JolliBeng
  10. 1 point

    Modify table structure

    Hi, Just want to add some additional resources to this old post. Here are some Howto Documentation that I've used in building and modifying my tables: https://howto.caspio.com/tables-and-views/creating-and-modifying-a-table/ https://howto.caspio.com/tables-and-views/modifying-a-tables-design/ https://howto.caspio.com/tables-and-views/table-and-database-design/ Hope that helps. Regards, @NailDyanC
  11. 1 point

    AutoComplete based on Role

    Hello, (A different approach) If I understand you correctly, it's not actually hard to implement as it seems. I, myself, wanted to implement this before. I am assuming that you are using an Authentication in your DataPage. If so: First, what we need to do is to somehow add to a Default_Task field to the DataSource of your Authentication (much easier if it's a View, but you can also do with a field with manually input value. Hopefully this makes sense. I am attaching an image for you to better visualize my point). Once it's in your authentication field, you should be able to use that as an OnLoad value on pretty much all kinds of DataPages Hope this helps you, kpcollier Regards, DN311337
  12. 1 point
    If you are using SQL SELECT to read the value you need to use the name of the field form that table not using parameter so you need to have: SELECT COUNT(DISTINCT PropertyKeyId) FROM UI_FactTrxn_1 WHERE InvestorUserId = [@authfield:Users_UserId] And you do not have to replace the value with 0 as COUNT returns 0 if there is none.
  13. 1 point

    Authentication Login Box

    Hi Corpcat, You can add a Header/Footer to you Authentication, disable the html editor, then add this code: <style> td[class*="cbLoginButtonContainer"] { display: none; } </style> Then add an HTML block after below all your fields, then put this code: <div style="text-align: center; position: relative;"> <input type="submit" onmouseout="cbButtonHover(this,'cbLoginButton');" onmouseover="cbButtonHover(this,'cbLoginButton_hover');" class="cbLoginButton" value="Login" id="Login1" name="Login"> </div> After that, select your second to the last field, click Advanced tab and check Continue next element on the same line. -JolliBeng
  14. 1 point
    DevArora is correct about the behavior of reset buttons. I just wanted to add my version JavaScript solution that will clear the values of all text elements on a specific DataPage. Just paste the snippet below in an HTML Block on Configure Search Fields Page (with HTML Editor disabled from the Advanced tab). <button type="button" onclick="resetForm()">Clear Form</button> <script> var myForm = document.querySelectorAll('form[action*="[@cbAppKey]"] input[type=text]'); function resetForm() { myForm.forEach(function(elem) { elem.value=""; }); } </script> Hope this helps. `DN31337
  15. 1 point
    Hi @Perzival Yes it can be done. You can create a calculated/formula field then insert the following code: CASE WHEN [@field:Estimate] = 'Minimum' THEN [@field:Equivalent] * 0.10 WHEN [@field:Estimate] = 'Average' THEN [@field:Equivalent] * 0.15 WHEN [@field:Estimate] = 'Maximum' THEN [@field:Equivalent] * 0.25 END Alternatively, if you wish to add or do something to the logic above, you may visit our Function Reference article on this link: https://howto.caspio.com/function-reference/ I hope this helps. H
  16. 1 point

    Change Bulk Edit Icon

    Hello Role21, You can also change the icon for the Bulk Edit in Styles. Just go to you Style>Results Page> Page Actions> Toolbar Image Actions Hope this helps. -JolliBeng
  17. 1 point
    Hi @roattw, You can implement the solution from this topic . 1. Disable AJAX loading of Datapage; 2. Place the following code into Datapage Header: <style> .wrapper1, .wrapper2 { width: 100%; overflow-x: scroll; overflow-y: hidden; } .wrapper1 { height: 20px; } .wrapper2 {} .div1 { height: 20px; } .div2 { overflow: none; } </style> <script src="https://code.jquery.com/jquery-1.9.1.js"></script> <div class="wrapper1"> <div class="div1"></div> </div> <div class="wrapper2"> <div class="div2"> 3. Place the following code in Datapage Footer: </div> </div> <script> $(function () { $('.wrapper1').on('scroll', function (e) { $('.wrapper2').scrollLeft($('.wrapper1').scrollLeft()); }); $('.wrapper2').on('scroll', function (e) { $('.wrapper1').scrollLeft($('.wrapper2').scrollLeft()); }); }); $(window).on('load', function (e) { $('.div1').width($('table').width()); $('.div2').width($('table').width()); }); </script> Make sure that you disable HTML editor otherwise it breaks the code in the Header. Hope this helps. Regards, vitalikssssss
  18. 1 point
    Hello HampasLOUpa, If you want to interchange those special DataTypes (Autonumber, GUID, Random ID) to each other or change them to other DataTypes (Number, Integer, Calendar, etc), change them to Text(255) first and then to your desired DataType. Interchanging special DataTypes (Autonumber, GUID, Random ID) to other DataTypes directly won't work. I'm not really sure why but think this by design. I hope this helps. Thanks!
  19. 1 point

    Yesterday's Date

    Use this code in the footer of the submission page: <script> today = new Date(); yesterday = new Date(today); yesterday.setDate(today.getDate() - 1); var dd = yesterday.getDate(); var mm = yesterday.getMonth()+1; //January is 0! var yyyy = yesterday.getFullYear(); if(dd<10){dd='0'+dd} if(mm<10){mm='0'+mm} yesterday = mm+'/'+dd+'/'+yyyy; document.getElementById("InsertRecordStartDate").value = yesterday; </script> I got this code from https://stackoverflow.com/questions/16686640/function-to-get-yesterdays-date-in-javascript-in-format-dd-mm-yyyy
  20. 1 point

    Lightbox in Weebly

    Hello everyone, I have tried to use the Lokesh Dhakar version in the caspio 'how to' section http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-a-lightbox-view-for-images/ but it won't work. The image displays but when you click on it it goes to a new page, sizing remains the same and the image appears in the top middle of the screen with a white background. To be blunt, it looks ridiculous and on a functional basis is useless. I'm not sure whether it's outdated coding on the 'how to page' or whether it is a compatibility issue with Weebly, the later seems a bit odd. Anyone got this to work in Weebly and if so was there any troubleshooting you can guide me on? If not, does anyone have an alternative workable lightbox solution for caspio into a Weebly site? Any help would be greatly appreciated, Cheers Chris
  21. 1 point
    Hi Jeffs88keys, Do you have a sample webpage we can inspect? Are the DataPages deployed using the Embed deploy method?
  22. 1 point
    The problem (I get error when trying) is those calculated fields aren't drawing from the same table. Is there a way to put, instead of [@calcfield:1] the actual syntax from calcfield:1 which is: SELECT Proposals_Deposit FROM Proposals Where ProposalID=target.[@field:Items_ProposalID] AND CompanyID ='[@authfield:CompanyID]' That said, calcfield2 is even more complicated because it's choosing from 3 other calculated fields, in a different View. If I can somehow use all sub-SELECTs instead of the [@calcfield:1 or 2] that would probably do it but I don't know how, or if it's possible.
  23. 1 point
    Hi, Please make sure that all the following steps are done: a. Copy the code below and paste inside the <head> section of your web page: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> b. Download the JavaScript file from here and upload the file to your website hosting. Once uploaded, you’ll need to reference this file in the <head> section of your web page. Example: <script src="http://yoursite.com/yourfolder/jquery.signaturepad.min.js"></script> c. Edit the Details page of the DataPage and choose form element "hidden" for "Signature" field in the Configure Fields screen. Insert an HTML Block after the "Signature" field. Go to the Source of the HTML Block and insert the following code. <div class="sigPad signed"> <div class="sigWrapper"> <canvas height="55" width="198" class="pad"></canvas></div> </div> <script> var sig = eval("[@field:Signature]".replace(/"/g, '"')); $(document).ready(function () { $('.sigPad').signaturePad({displayOnly:true}).regenerate(sig); }); </script> d. Insert Header & Footer using the picker button at the lower right of the DataPage Elements. Disable HTML editor for both Header and Footer from the Advanced tab. Copy the code below and paste inside the HTML Header. <div id="cb_sign_wrapper"> e. Copy the code below and paste inside the HTML Footer. </div> I hope, it helps.