JoennAquilino

RE: I've got a question. I used the code and have a bit of an issue. What if there's more than 1 page? It will not calculate the balance since it's a new page and the last balance is not recorded on anyway so the it will not run. Does anyone have any ideas how it can be done? Thank you!

Hello, I don't know if it's Wordpress issue but for some reason, whenever I deploy a datapage in iFrame, both wordpress code and html code, it wont receive any parameters however when using different deployment, it's working fine. Currently I deployed the datapage using the other means but I'd prefer using iFrame on some instances. Thank you.

Hello, Try adding IsNull on the field inside the Sum. SELECT Sum(IsNull(FieldTwo,0)) From tTable_Name WHERE tTable_Name_Field = '[@field:FieldOne]' EDIT: I didn't noticed the date. I reported this post. Sorry. I saw this thread at the top where the unanswered threads are located.

Hello, I would like to ask if I'm able to show certain field even though it didn't meet the criteria. For example The date is my critera Field1|Field2|Field3|Date User1|2____|2____|Now User2|_____|_____|____ <- Does not meet the criteria but still shows. User3|_____|3____|Now Something like that? Is that possible? Thank you.

Hello, I would like to ask if it's possible to load data using to set of criteria like the result for this(April) month and before it's column is the result for last month(March)? Thank you

It does work! Thanks. I tweaked it a bit.

What I want is, I have all groups be totalled. However I want to compute the total of each group.

Hello, Is it possible to compute the group totals when collapsed(the aggregated total)? I have this calculated fields but it only calculates when the group is expanded. I want to calculate the values of them when it's collapsed, too. Thank you. Example Collased data here(total) ||Collased data here2(total)||Calculated 2000________________||1000_________________||3000 Something like that?

Greetings, I want to do something like this... On the tabular report... Column 1 || Column 2 || Column 3 ________||_________||10000 1000____||800______||10200 <-- Formula: (1000-800)+The value above the current row. the 10000. 2000____||400______||11800 <-- Same formula. My problem is, how can I compute them with the value above the current row? Is there a way(javascript) to do that? Or maybe part of the feature of CASPIO? Is it even possible? Thank you.

As far as I know, there is none. Only javascript. You might want to read this thread: http://forums.caspio.com/index.php/topic/3200-js-concatenatecombine-two-fields-into-one-field/ It's easy to follow.

I've read that. What I want to send parameter to the new datapage which cannot be done without using HTML.JS(Not sure if not). I've tried alot of things. It's working now actually. Thanks. (I'm posted the thread since I've been working on this for the whole day and somehow, it's working now after changing a bit of the code)

Hi! I would like to ask for some help. Thanks in advance. My problem here is, I actually want to open other data page to add new data to a dropdown on my form. I've read this (http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/add-an-option-to-a-public-facing-dropdown/). It's actually working. What I want now is send a parameter together with the URL. I've used javascript actually, however, it's not working. On my footer: <script type="text/javascript"> var PARAM; var URL1; function popup(){ PARAM= document.getElementsByName("InsertRecordCASCADINGFIELD")[0].value; URL1 = 'URLHERE' + PARAM; window.open(URL1,'popup','width=500,height=300,scrollbars=no,resizable=no,toolbar=no,directories=no,location=no,menubar=no,status=no,left=0,top=0'); return false; } document.getElementById("IDHERE").onclick = popup; </script> On the HTML Block next to the dropdown: <a id="IDHERE">LINK</a> It's not working, even though I've tried this one on a normal .html and works. Whenever I click it, new window is not opening. (That's the problem, actually)

I've tried that one actually but still didn't work. I tried this one... <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var field1= document.getElementById("EditRecordField1").value; var field2= document.getElementById("EditRecordField2").value; var allfield= field1+field2; document.getElementById("EditRecordAllField").value = allfield; } var v_btn = document.getElementById("Mod0EditRecord"); if(v_btn.addEventListener){ v_btn.addEventListener('mouseover', concatenate); }else if(v_btn.attachEvent){ v_btn.attachEvent('onmouseover', concatenate); }else{ var prevEvt = v_btn.onmouseover v_btn.onmouseover= function(){ concatenate(); prevEvt && prevEvt(); }; } </SCRIPT>

Hi! I'm trying to figure out what's wrong this code(http://forums.caspio.com/index.php/topic/3200-js-concatenatecombine-two-fields-into-one-field/) when editing data. I'm not going anywhere. Is there another way to edit a concatenated table field? Or maybe, is there a way to combine two fields and edit certain table field when submitted? Thank you. EDIT Oh, I made it work. Thanks.