Leaderboard

Hello @Medron, You can try this code: — Luna —

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/

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.

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?

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

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

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

Hi kpcollier, I just discovered that it is possible to change the "View Details" text. You can modify it under Localization: -JolliBeng

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

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

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

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.

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

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

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

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

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

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!

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

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

Hi Jeffs88keys, Do you have a sample webpage we can inspect? Are the DataPages deployed using the Embed deploy method?

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.

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.