Jump to content

Vitalikssssss

Caspio Rockstar
  • Content Count

    494
  • Joined

  • Last visited

  • Days Won

    49

Everything posted by Vitalikssssss

  1. Hi @satch, Do you store images in public repositories? or maybe you plan to store them in Caspio? Please let me know. Regards, vitaliksssss
  2. Hi @satch, Would you like to show a URL which user can click after he/she inputs the file reference name? Please correct me if my understanding of this inquiry is not correct. Thanks, Vitalikssssss
  3. Hi @HughD, I would recommend taking a look at Triggered action feature. You can set up a Trigger which will delete the record if it doesn`t meet the requirements and also you can set up an Email Trigger to inform the user that his record was rejected. You can find more details in this article and there is a video available too: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, vitalikssssss
  4. Hi @satch, It looks like you can utilize a 13.0 Caspio Bridge feature called "Calculated Values". You can check a release notes for further information about this feature. https://howto.caspio.com/release-notes/caspio-bridge-13-0/ Hope this helps. Regards, vitalikssssss
  5. Hi @rgiljohann, You can pass parameters on exit from the Search form if you have one in your Datapage. I do not think it will be possible to pass parameters from Result set except via query string. Hope this helps. Regards, vitalikssssss
  6. Hi @kvarjavand, I communicated with Caspio Support about the similar issue the other day and they told me AJAX functionality currently enabled on submit / login events which can refresh embedded datapage without page reload. I am afraid that Edit/Insert/Delete events on tabular report do not trigger AJAX datapages refresh. You can submit a feature request to Caspio product team via IdeaBox . Hope this helps. Regards, vitalikssssss
  7. Hi @Magnum, You can use calculated fields with SQL query to count id`s and to retrieve an oldest and the latest date user submitted case id. Finally, you can use DateDiff() function to calculate a number of days the user has been working on the case. You can check the following article for further information about SQL usage in Caspio: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You can check the following topic if you prefer to exclude weekends, holidays from a number of days which individual has spent during working on the case: Hope this helps. Chrees, vitalikssssss
  8. Hi @SteveAeroOps, It is a really strange issue. Do you use View as a data source for the datapage in question?
  9. Hi @MichaelB, I didn`t receive the "Failed integrity check" error message. This error means that you have a relationship with "Referential integrity" enabled. This option will not allow creating a record in "child" table if an ID value is not presented in a "Parent" table. Blank values in a "child" table also giving the same error. Hope this helps. Regards, Vitalikssssss
  10. 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
  11. 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
  12. 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/plant-profile/?CPCNum=[@field:tblRareTaxonTable_CPCNumber]' <span style='color:#482441;'>Go To Profile</span></a></strong></span></div>"; } else { document.getElementById("record[@cbRecordIndex#]").innerHTML="<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> Regards, vitalikssssss
  13. 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 face some styling issues. This article explains how to re-size Iframe: https://howto.caspio.com/faq/deployment/remove-iframe-border-and-change-size/ Hope this helps. Regards, vitalikssssss
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. @AndrewCHughes, Can you show me your query expression? Does this issue appear on any table?
  20. Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  21. 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
  22. 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
  23. 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
  24. Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss
  25. Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?
×
×
  • Create New...