Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @robbiel, You are correct, Caspio Bridge doesn`t allow you to schedule an import/export of file. Only documents Excel, Access, XML are supported. Regards, vitalikssssss
  2. Hi everyone, Does anyone have a Javascript solution which can hide Line series on page load? So, the chart will look like this: I did find this option in DP wizard. Thanks, vitalikssssss
  3. Hi @Heineperson, Sorry, I forgot to add inner HTML in my code. Please try to use the following code: <div id='record[@cbRecordIndex#]'></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ("[@field:tblRareTaxonTable_ProfileStatus]" == "Active") { document.getElementById("record[@cbRecordIndex#]").innerHTML="<div style='background:#A0CE4E;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><strong><a href='https://saveplants.org/national-collection/plant-search/pl
  4. Hi @Fleshzombie, The error which you have encountered means that your SELECT expression returns an array of values instead of single value. This is a current limitation of Caspio Bridge as far as I know. If you need to display multiple values you can create a separate report with the same filtering criteria as in your SQL expression and embed this report in HTML block using the Iframe deploy code. You would need to specify an external parameter (DeviceWirelessNumber=[@field:DeviceWirelessNumber]) in Iframe source URL. I need to mention that this approach will f
  5. Hi @Vipul, The following condition is set in the wrong way in your code: if(''!=='0') You need to specify the field name which you would like to compare with '0': if('[@FieldName]' == '0') You can find a detailed guide in this article: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ Regards, vitalikssssss
  6. Hi @Vipul, You can use the authentication field to display username. You may use the guide from this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/personalize-a-message-for-your-users/ Hope this helps. Regards, vitalikssssss
  7. Hi there, You can create an equivalent of Norm.Dist function by using the calculated field which is available on Report type of Datapage. I have this T-SQL example as a guide. I have created my example based on Details page. Your table needs to have following values: 1. Sigma; 2. Mean; 3. Value; and following set of calculated fields: 1. @x Expression: (([@Value] - [@Mean]) / [@Sigma]) 2. @Z Expression: (ABS( [@calcfield:@x] ) / SQRT( 2.0 )) 3. @t Expression: (1.0 / (1.0 + 0.5 * [@calcfield:@Z])) 4. @ans Expressio
  8. Hi @Clint, You cannot export table/view from Caspio Bridge in JSON format. You can use Caspio REST API in order to get records from a table/view in JSON format. Hope this helps. Regards, vitalikssssss
  9. Hi @LyaP, In my opinion request workflow can be achieved with custom programming on Caspio back-end. You can contact these guys to make sure that this can be done. Regards, vitalikssssss
  10. @AndrewCHughes, Can you show me your query expression? Does this issue appear on any table?
  11. Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  12. Hi @AndrewCHughes, It is possible to specify COUNT function in REST API query which will return a count of matched records. Here is a simple example: Hope this helps. Regards, vitalikssssss
  13. Hi @Heineperson, You can try following code with inner HTML: <div id='record[@cbRecordIndex#]'></div> <script type="text/javascript"> debugger; document.addEventListener('DataPageReady', function (event) { if ("[@field:tblRareTaxonTable_ProfileStatus]" == "Active") { document.write("<div style='background:#A0CE4E;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><strong><a href='https://saveplants.org/national-collection/plant-search/plant-profile/?CPCNum=[@field:tblRareTaxonTable_CPCNumber]' <span style='col
  14. Hi there, Could anyone help me to resolve the issue with the following search logic scenario: a user can search by Date field with "from&to" range with criteria, but if criteria are blank I would like to return records with blank Date field Field datetype: Date&Time Thanks, @Vitalikssssss
  15. Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss
  16. Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?
  17. Hi @Medron, You can find a list of all available REST API methods in Swagger. More information available in this article: https://howto.caspio.com/web-services-api/rest-api/swagger-ui/ Regards, vitalikssssss
  18. Hi @cbaker10, You would need to use separate tables: Table 1 for courses with assigned teachers Table 2 for enrollments These tables should have a one-to-many relationship. For your report, you should use Table 1 and Calculated field with SQL expression if you would like to display a count of enrollments from Table 2. Alternatively, you can use your existing View and Collapsible Group of records by teacher name. Here is the link to an article about : https://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/ Hope this helps.
  19. Hi @georgep, You can try using the following code: <div id="icon"></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ('[@field:XXXX]' != '') { document.getElementById("icon").innerHTML='<a href="[@field:XXXX]" target="_blank"> <img src="../resources/File_icon_INS.png" alt="Files" height="40" width="40" /></a>'; } }); </script> Hope this helps.
  20. Hi @janetflorence, I have experienced the same issue too. I doubt that you could get a detailed description within current feature set of Caspio Bridge. We should bring this to the attention of Caspio Product Team. Please vote in Caspio Idea Box for the feature enhancement: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/7688223-describe-upload-errors Thanks, @vitalikssssss
  21. Hello @roattw, You can place following CSS into Datapage Header in order to place the form in the center of a web-page. <style> table { margin: 0 auto ; } </style> Hope this helps. Regards, vitalikssssss
  22. Hi @jeffs88keys , I would suggest taking a look at Tabular Report Datapage with Inline insert option enabled if you would like to add multiple items by single Datapage. https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ Hope this helps. Regards, vitalikssssss
  23. Hi @faile486, You can use Cascading Dropdown form element in order to automatically populate dropdown options based on the previous selection of user. You may find more details in the following article: https://howto.caspio.com/datapages/datapage-components/cascading-elements/ Regards, vitalikssssss
  24. Hi @DesiLogi, You can define formatting settings for a particular field in order to over-write Datapage localization settings. Hope this screenshot helps: Regards, @Vitalikssssss
  25. Hi @NeoInJS , I was able to create validation check for Inline edit with jquery. You should wrap your fields in div with ID. Also, you need to disable ajax on your report and paste the following script in the footer. You can use following code as an example. Header <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="cbform-improvement"> Footer: </div> <script> $("#cbform-improvement #Mod0InlineEdit").click(function(e){ window.alert("check"); if(document.getElementsByName("Inline
  • Create New...