Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. hi @roattw , You need to check if your filtering criteria on the report page were joined with "AND" block. Hope this helps.
  2. Hi @Medron, What type of messaging system do you need? I know that Real Estate application template contains a form which app users can use to send a message to a broker. You can check the functionality here: https://www.caspio.com/real-estate-listings/ Hope this helps. Regards, vitalikssssss
  3. Hi @satch, Do you store images in public repositories? or maybe you plan to store them in Caspio? Please let me know. Regards, vitaliksssss
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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 c
  10. Hi @SteveAeroOps, It is a really strange issue. Do you use View as a data source for the datapage in question?
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. @AndrewCHughes, Can you show me your query expression? Does this issue appear on any table?
  22. Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  23. 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
  24. 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
  25. 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
  • Create New...