Leaderboard

Just include the dates in the criteria. On Search Filters, enable the On Exit, and then you can then use these parameters on the WHERE (i.e. WHERE Call_Outcome = 'Sale/Offered' AND DateColumn >= '[@DateParameter1]' AND DateColumn <= '[@DateParameter2]'

@Tubby Thank you for giving a sample. This helped a lot. Thanks for the help guys! Those articles are very helpful. -AL

Try this one, this will only run once, when the DataPage is loaded, after that, it will not run anymore unless you refresh <script> document.addEventListener("DataPageReady", function(e){ var gridEditButton = document.querySelector("a[data-cb-name='GridEditButton']"); gridEditButton.click(); }); </script> This is much simpler method than the one above. That's to force Grid Edit. You don't need the other script for this, just the style, maybe

Hello @kpcollier, I tested the same DataPage design in my account and you are correct, in your example we need to hide the 2 last cells in the row with the Totals. In DevTools the layout has the following view: Basically, as I checked, the cbResultSetTotalsDataCell CSS class is used only for the Totals. However, we can use a more complex selector to refer to the required cells. tr[data-cb-name='grand_total'] td:nth-of-type(3), tr[data-cb-name='grand_total'] td:nth-of-type(4) {display: none;}

Hi everyone! I had the same question on how to calculate median and found out that there is no built-in function in SQL for that I have found a workaround though, here is my example: SELECT ( (SELECT MAX(Price) FROM (SELECT TOP 50 PERCENT Price FROM Products_sold ORDER BY Price ) AS BottomHalf) + (SELECT MIN(Price) FROM (SELECT TOP 50 PERCENT Price FROM Products_sold ORDER BY Price DESC) AS TopHalf) ) / 2 AS Median Where 'Price' is the field name, 'Products_sold' - table name. You want to make sure to change these to your field/table names. Here is a helpful exter

Oh, you don't have to! Appreciate it, though! Hope it works for you.

Hi @af123, When adding any script in HTML editor, always click 'source' and add it or disable the editor by unchecking the box below and then add the code. If not, the code will show as it is and will be read as text instead of JavaScript code. Also, the URL in the screenshot seems incorrect. It cannot have both http and https. Try removing "http://www." part from it and test.

Hello @af123, You need to disable the html editor so that it will not read as a text instead it will read it as html tag. You may also access this link for your reference: https://howto.caspio.com/authentications-and-connections/authentication/create-a-standalone-login-screen-2/ https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/

You absolutely nailed it!!! It seems so simple now that I actually see it. I will hang on to this code and example since I'm sure I can find other uses for it going forward. And also adapt it to some other scenarios too. Again, thanks so much for the fast solution.

Not sure if what I understood is correct, but, you can try this, create a Calculated Value, this is to check if the date today is less than 5 or not. If it's 1, user can input any date, if it's 0, only on the current month and later. CASE WHEN DATEPART(day, GetUTCDate()) <5 OR (DATEPART(day, GetUTCDate()) >= 5 AND DATEPART(month,GetUTCDate()) <= DATEPART(month, [@field:Date])) THEN 1 ELSE 0 END Script on the footer: (change the number on cbParamVirtual1 depending in your Virtual Field) <script> document.addEventListener("BeforeFormSubmit", function(e){ var a= doc

Hello fellow Caspio-ers Has anyone come up with any clever ideas of ring-fencing development work from deployed, production datapages. I get nervous when I need to make changes to a table or view when the related data pages are in use. Thanks Gill

Try this one, just create a var for each dropdown you have, put that var in the two arrays (dropdownarray and valuesarray) , and you're good to go <script> document.addEventListener("change", function(event){ var d1 = document.getElementById("cbParamVirtual1"); var d2 = document.getElementById("cbParamVirtual2"); var d3 = document.getElementById("cbParamVirtual3"); var dropdownarray= [d1,d2,d3] var valuesarray=[d1.value, d2.value, d3.value] for(var j=0; j<=dropdownarray.length;j++){ //counter for dropdownarray for (var i=1; i<dropdownarray[j].length; i++) { //counter for

Hi, just to add to the previous comment above. You may also try this other workaround:

Hello, I am trying to make a cascading dropdown field that receives the value from the parent field selection and still have the rest of the values from the dropdown source show along with it. Sort of like the option 'Match all when blank' but I want to match all - all the time, and populate the dropdown with the cascading value. I am building a scheduling calendar. We take information from our Work Order Table to use for creating records for the Scheduling Table. Each Work Order record has a technician assigned. When a work order is selected in the Scheduling Submission Form, the T

Hi @kpcollier, Choosing a specific value from a dropdown can be achieve with a bit of javascript. First, identify the dropdown element and create an array the represents the dropdown choices: const dropdownEle = document.querySelector('[name*=field_name]'); const dropdownChoices = dropdownEle.options; Next, create the makeSelection function: function makeSelection(selectionID) { // loop all the dropdown options for(let i = 0; i < dropdownChoices.length; i++) { // if the dropdownChoice matches the selectionID... i

Hello Caspio Community! Let me explaining my scenario firstly please. Currently I'm stuck on how to authenticate REST API calls in a secure manner. I have a new app stood up and ready to launch (this app is/well always be locked behind Caspio Login) . However, before I launch this app I was wondering if I could use "document.cookie()" user token to make API calls instead of the bearer token that I have been using for development. If I could use a user token instead of an API key I would feel much more secure. Thank you for taking time out of your day to read this! I

Hi @kpcollier Then a bit of javascript to check for the parameter. <script> var p = '[@your_parameter]'; if(p !== '') { console.log('parameter present - auto search'); yourAutoSubmitFunction(); } else { console.log('no parameter - behave normally'); } </script> Pair this with the AutoSubmit described here (and that you mentioned) To prevent a loop, reset Caspio parameters with (cbResetParam=1 on the link back to search. Search form URL: /your-search-page.html?cbResetParam=1 I hope this helps

There's no way to do that. Closest thing is use List or Gallery Reports DataPage and make it look like the Details Page

Hi @Ewens You can try creating SELECT statements inserted in a calculated field. For example: (SELECT SUM(ColumnA) FROM TableName WHERE Condition)/(SELECT SUM(ColumnB) FROM TableName WHERE Condition) For more information, you can browse this article or watch this video tutorial as well: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ https://www.youtube.com/watch?v=15zAruBT3LA Hope this helps!

Hi @jimarch, You can hide the employee number using some CSS Style. Here is the article for your reference: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ The field will be hidden, but it will still be saved in the table. Hope this helps!

Hello @Hayleyy, 1) If the video files are stored in the Files section of your Caspio account, you may use the <video> tag inside the HTML block. For example: <video width="320" height="240" controls> <source src="[@field:Video_file/]" type="video/mp4"> Your browser does not support the video tag. </video> Also, you may firstly host a video in the hosting site, for example, YouTube, copy the video embed code and paste it to the HTML block. For both options, there is an issue with iOS devices that cannot render the video correctly and the issue

I believe they "might" have started a LinkedIn group for Caspio Certified Developers. If not, it would be good for consideration.

Looking for one or multiple programmers to work on existing CRM built on the online cloud database caspio (https://www.caspio.com/) . Private company currently has custom CRM program on the caspio platform and we are looking to automate more processes and integrate with multiple API’s from Twilio, Google Docs, Slack, and MapQuest. Pay is negotiable, please contact us with your resume and qualifications.

Hi @RunForrestRun, If you want to change the font color of the current record page on all Detail's DataPages then it is possible in Styles: Go to Styles -> Form/Details -> Navigation -> Current Record For more in depth customization, go to Styles -> Source -> All -> Find .cbFormJumpToTextField class -> change color or other attributes to the required value Hope this helps!

Just wanted to add that if anyone wants to hire programmers/developers to help with your Caspio Application projects, it is also a good idea to look for Caspio Certified App Developers. I recently heard they have a certification program and figured it's best if those who you will hire are certified to make sure every penny you spend is worth it. - LOEY

So, I was testing this new HowTo Article I found. It seems that it will not work for the Inline Insert and Inline Edit, so, I made one, if ever anyone needs it INLINE INSERT <script type="text/javascript"> document.addEventListener('input', function(event) { var x = document.getElementById("InlineAddFIELDNAME").value; document.getElementById("InlineAddFIELDNAME").value=x.replace(/[^a-zA-Z0-9 ]/g, ""); }); </script> I set the event listener to input as the Inline Insert and Edit is not a form, this will, however, PREVENT special characters for being ty

Hi @Cherry, Based on what I understand, in your Reports Page, you will have a column for Sales Person. Then, you would like to sort the report based on the most outstanding sales person. First, you need to have a calculated field in your reports. You can have an SQL statement to count how many instances that this sales person is being selected by the customer. For example: SELECT COUNT(Sales_Person_ID) FROM TABLE WHERE Sales_Person_ID=target.[@field:Sales_Person_ID] Change the field name and the Table Name. Lastly, sort the report using this calculated field. See

Yeah that's doable. Main Table, is one Table, the 2nd sheet is another Table. Just use Triggered Action, or, if you're importing the data, you will need to use Application Task first to sum up those value you want to sum up. Triggered Action is for new entries that will be inserted on the main table, it will get added on the 2nd table (or update the 2nd table's values), if something is updated, as well, you can update the 2nd table through triggered action. You can then use that 2nd table for your Pivot DataPage. Look around the forums or HowTo or Youtube videos about triggered actions, t

ahh, I don't know, I believe only radio buttons accept images use img tag for the display . i.e. <img src="https://multimedia.3m.com/mws/media/1484762F/3630-61-slategray-swatch.jpg" alt="test" width="50px"/>

Some of these prices are outrageous. $450 for that custom calendar, that I have literally posted on here how to create. $600 for a Multi Step Form... $150 just to be able to show the password?! Am I the only one that finds it pretty crazy that these aren't Standard Features, either? I understand paying for things like the Kanban board, but 90% of these 'App Extensions' are really simple and seem like they should come with the paid subscription.

You can still combine all of them in a View, just that it would be OUTER JOIN, nothing is similar. You can create another field in all your tables just to store the table name. Use View as the Data Source for Reports DataPage, and use Keyword Search. https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ You might encounter some problems with joining all those tables tho, if you have so much records in each one. Setting up the Reports DataPage will be too much work, as well.

Hi @PeterER8, Do you want to count only the number of cells that has 'Green' value per record? Is your expected output similar to the following? If yes, you can just use CASE-WHEN statements in your formula field that will check if the field has 'Green' value. (CASE WHEN [@field:Reason_1] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_2] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_3] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_4] = 'Green' THEN 1 ELSE 0 END)

instead of `[@field:name]` , try something like var qStringVal = document.getElementById("link-[@cbRecordIndex]").textContent ; or document.getElementById("link-[@cbRecordIndex]").innerText; var qStringVal = `[@field:name]`;

I am using the below code to populate inline insert fields to make data entry easier for users (got it from a post by @DefinitelyNot31337). I am having some problems on one page though and hoping somebody can help clear it up. My search and results are on one page. The search is using 2 fields (SolutionID and ProductID) both go to Parameters of the same name ([@SolutionID and [@ProductID]). There is a third field (FeatureID) which is a Cascading Drop Down based on the ProductID. As soon as I make FeatureID a Cascading Drop Down, it fails. If I leave it as a regular drop down, the co

Thanks for the help Melody, I figured it out. The syntax was incorrect as my User_Id Field is a string value, I should pass it in ''. The corrected query is : SELECT COUNT(DISTINCT PropertyKeyId) FROM UI_FactTrxn_1 WHERE InvestorUserId = '[@authfield:Users_UserId]'

OK - I circled around to this one more time, and really looked at the code that was provided by iren (thx again). I discovered there was an extra "." at the end of the first if statement ".checked.==false)"... I removed it, tested, and it now works. So.. thanks very much again Iren. Here's the working code. <SCRIPT LANGUAGE="JavaScript"> function ocProductsCheck() { if (document.getElementById("InsertRecordOC_print").checked==false) { document.getElementById("InsertRecordOC_newsletter").checked=false; } } document.getElementById("InsertRecordOC_print").onchange=o