Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. 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
  2. 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 Expression: [@calcfield:@t]*exp(-[@calcfield:@Z]*[@calcfield:@Z]-1.26551223+[@calcfield:@t]*(1.00002368+[@calcfield:@t]*(0.37409196+[@calcfield:@t]*(0.09678418+[@calcfield:@t]*(-0.18628806+[@calcfield:@t]*(0.27886807+[@calcfield:@t]*(-1.13520398+[@calcfield:@t]*(1.48851587+[@calcfield:@t]*(-0.82215223+[@calcfield:@t]*0.17087277)))))))))/2.0 5. normdist (output) Expression: case when [@calcfield:@x] <= 0 then [@calcfield:@ans] else 1 - [@calcfield:@ans] end You may refer to my DP for more details. Regards, vitalikssssss
  3. 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
  4. 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
  5. @AndrewCHughes, Can you show me your query expression? Does this issue appear on any table?
  6. Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  7. 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
  8. 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='color:#482441;'>Go To Profile</span></a></strong></span></div>"); } else { document.write("<div style='background:#482441;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><span style='color:#FFFFFF;'><strong>Profile In Progress</strong></span></span></div>"); } }); </script> Hope this helps. Regards, vitalikssssss
  9. 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
  10. Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss
  11. Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?
  12. 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
  13. 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. Regards, vitalikssssss
  14. 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.
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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("InlineEditHours")[0].value > 100) { window.alert("save!"); } else if (document.getElementsByName("InlineEditHours")[0].value > 1000) { window.alert("do not save!"); return false; } else { window.alert("do not save!"); return false; } }); </script> Hope this helps. Regards, @Vitalikssssss
  21. Hello @MLaya, Please make sure that you have encoded Authorization header parameter "Client_ID:Client_Secret" in Base64 format. Hope this helps. @Vitalikssssss
  22. Hi @geoffdude, I believe that you have an issue with Javascript since Datapage URL link has changed after 10.0 Caspio Release. You can try to use the following script: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { window.open('[@cbBridgeServer]/dp/[@app:Public_Gallery_DP_AppKey]?category=[@category]&author=[@author]','_parent'); }); </script> Hope this helps. Regards, @Vitalikssssss
  23. Hi @pgjacob, You can create a custom formula within a single aggregation field in order to sum values from two fields. Here is an example: Hope this helps.
  24. Hi @AussieCaspio, You can create a View which will filter your table with promotion based on start and end date. Here is an example of filter: This article might be useful: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/ Regards, vitalikssssss
  25. Hi roattw, You should place each report within single CB in Squarespace and paste the script from the article below Datapages deploy code. This should resolve the issue. Regards, @Vitalikssssss
  • Create New...