Caspio Rockstar
  • Content count

  • Joined

  • Last visited

  • Days Won


Mathilda last won the day on March 13

Mathilda had the most liked content!

1 Follower

About Mathilda

  • Rank
    Advanced Member
  • Birthday

Recent Profile Visitors

687 profile views
  1. You may sort fields on a date field in the descending order and return only 5 records for report. You can find this setting on the Advanced tab of the results page options screen of wizard. Hope that helps
  2. Hi blarney, This is the common problem for CMS users. If you use embed code, the datapage become a part of a webpage, hence inherits all style attributes, defined for the webpage. Is your CMS allows editing CSS code of your theme? If yes, you need to edit CSS of your CMS and delete or edit some attributes. If you can't edit CSS of the theme, overwrite elements in the header of the datapage. For example, if your CMS enforces borders, add the following code in the header of datapage: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } </style> Using iframe deployment eliminates style issues, however you may face problems with passing parameters. Hope that helps
  3. As far as I now, facebook ID services is not available in caspio since approx. 2014. I think that PS team can do that, this is the easiest way
  4. Yes, it's possible, add one more criteria and select is blank comparison type. You may also make this criteria to be hidden. Hope this helps
  5. Try using my code instead of document.write part <script type="text/javascript"> var uniqueId = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) { var r = Math.random()*16|0, v = c == 'x' ? r : (r&0x3|0x8); return v.toString(16); }); document.write('<button id="'+ uniqueId +'">take me away</button>'); var button = document.getElementById(uniqueId.toString()); if(button){ button.addEventListener('click', function(event){ event = event || window.event; document.location.href = ""; event.stopPropagation(); event.cancelBubble = true; event.returnValue = false; return false; }, false); } </script>
  6. Hi AnaBella, welcome to forum! You may use html block for this purpose. Use html tags to locate your field values as you wish. Parameter picker allows to select field parameters instead of actual fields. You may find more info here
  7. Try adding a condition before concatenation. Use my code instead of this part: document.getElementById("InsertRecordemailstosend").value = x1+" "+x2+" "+x3+" "+x4+" "+x5+" "+x6+" "+x7+" "+x8+" "+x9+" "+x10+" "+x11+" "+x12+" "+x13+" "+x14+" "+x15+" "+x16+" "+x17+" "+x18+" "+x19+" "+x20; if (document.getElementById("cbParamVirtual1").checked==true) { document.getElementById("InsertRecordemailstosend").value = x1+" "+x2+" "+x3+" "+x4+" "+x5+" "+x6+" "+x7+" "+x8+" "+x9+" "+x10+" "+x11+" "+x12+" "+x13+" "+x14+" "+x15+" "+x16+" "+x17+" "+x18+" "+x19+" "+x20; } else{ document.getElementById("InsertRecordemailstosend").value = x12+" "+x13+" "+x14+" "+x15+" "+x16+" "+x17+" "+x18+" "+x19+" "+x20; }
  8. This will be included in the upcoming release. You will see a new datatype when your site is updated. You may use this page to check maintenance date for your data center
  9. Hi Heidi, You can append data to table using manual import or scheduled import task. But it's impossible to insert more than 1 record at once though the datapage. You may want to contact Professional Services team, I think they will be able to implement that.
  10. Make fields onload receive the same parameter that each of them pass. It should help.
  11. If you export the whole app from dev account, during import in production account you will be able to replace existing app or import as a new app. Replacing is not and option, since you will overwrite everything, including data source tables, therefore I would recommend using custom manual export and select only those datapages which you need to import back in the production account. You may want to sort datapages on the last modified date in the dev account, this way you will find datapages, which should be exported. If you don't want to do that, just select all the datapages without dependencies. Then import the file into the production account. Don't worry about appkeys, because appkeys of the datapages will remain the same, since datapages were created in this account initially. System will identify the datapages on appkeys and you will be able to replace existing datapages. You may test on one datapage first to see how it works. Hope that helps. Please feel free to ask if something is not clear enough.
  12. Hi Milos, As far as I know, you can't upload this php code to caspio server. Perhaps API intergation will help. Check the "post table row" table operation in this article
  13. I would recommend separating html and java script. Also you should use getElementById instead of getElementByID. Try using html code in html block: <div style="text-align: center;"> <input type="submit" onclick="myfunction()" value="Submit" /> </div> And the following script in the footer: <script> function myfunction() { var virtualval = document.getElementsByName("cbParamVirtual4")[0].value; document.getElementById("InsertRecordMyFieldName").value = virtualval; } </script>
  14. Hi, welcome to forum I edited your script a little bit, we need to use another syntax for autocomplete fields. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x0 = document.getElementById("EditRecordOtherCollectors").value; var x1 = document.getElementsByName("cbParamVirtual2")[0].value; var x2 = document.getElementsByName("cbParamVirtual3")[0].value; var x3 = document.getElementsByName("cbParamVirtual4")[0].value; var x4 = document.getElementsByName("cbParamVirtual5")[0].value; document.getElementById("EditRecordOtherCollectors").value = x0+" "+x1+" "+x2+" "+x3+" "+x4; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>