Jump to content


Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


Vitalikssssss last won the day on March 22

Vitalikssssss had the most liked content!


About Vitalikssssss

  • Rank
    Advanced Member

Recent Profile Visitors

1,088 profile views
  1. 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
  2. Vitalikssssss

    Change Datapage Row in Different color based on condition

    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
  3. Vitalikssssss

    How to display Authenticated User Name in HTML Menu Bar

    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
  4. Vitalikssssss

    Norm.Dist function from Excel

    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 CaspioData_2018-Jun-27_1417.zip
  5. Vitalikssssss

    Create json File

    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
  6. 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
  7. Vitalikssssss

    SELECT COUNT() possible?

    @AndrewCHughes, Can you show me your query expression? Does this issue appear on any table?
  8. Vitalikssssss

    Chrome login loop

    Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  9. Vitalikssssss

    SELECT COUNT() possible?

    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
  10. Vitalikssssss

    Replace document.write with innerHTML

    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
  11. Vitalikssssss

    Complex Search logic with Date/Time field

    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
  12. Vitalikssssss

    Move Submit button

    Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss
  13. Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?
  14. Vitalikssssss

    Login for REST API

    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
  15. Vitalikssssss

    Show distinct records

    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