Vitalikssssss

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

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

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

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

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

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

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

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

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

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

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

Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss

Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?

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

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