Vitalikssssss

Hi @asesores,
That is very interesting question.
I come up with a workaround which would allow to create a cross join between 2 tables in Caspio.
Basically, you would need to add an additional field in both tables and specify the identical values for all records. 
Table #1
 
Table #2

Create a View with Full Outer Join by the Join Field:

Here is a result which you shall have:

 
Hope this helps.
Regards,
vitalikssssss
 

Hi @Vincent,
Your data needs to reside in Caspio tables in order to work with it via Datapages.
You may check this article which explains how you can import your date:
https://howto.caspio.com/tables-and-views/importing-data/
You may also consider using REST API for transferring the data from you database into Caspio:
https://howto.caspio.com/web-services-api/rest-api/
Hope this helps.
Regards,
vitalikssssss
 

Hi @Empbusk,
The requested part is actually covered in the following tutorial video.
You would need to use a Details Datapage along with calculated field in order get the count of number of records. 
Also, some HTML/CSS will be required to apply box styling of the element.
Hope this helps.
 
 

Hi @mgredmond,
You can add your actual field into submission form and use Calculated value form element to reference the result of Virtual field.
Advanced Calculated value settings allows you to hide field.

The formula expression will need to have a CASE logic block because Calculated value works with "Value" section of dropdown.
It might look like this:

Hope it helps.
Regards,
Vitalikssssss

Hi @CMorris,
Values from virtual fields do not have a datatype.
You would need to wrap the fields reference with single quotes to make them string type and convert the string to float type.
You can use T-SQL function CAST or CONVERT for this.
So, your expression will look like this:
CASE WHEN '[@cbParamVirtual2]' = 'mm' THEN CAST('[@cbParamVirtual1]' AS FLOAT)/25.4 ELSE CAST('[@cbParamVirtual1]' AS FLOAT) END Regards,
vitalikssssss

Hello @ryancys,
You may check the following tutorial video for more information related to the deployment of two Datapages in one web-page:
 

Hi @randybow,
The Date&Time comparison methods is not available in View if you use the formula field as far as I understood. 
You need to make sure that each logic block of your CASE expression returns Date&Time datatype.
Please try the following expression:
CASE WHEN [@field:endDate] Is Null THEN CONVERT(Datetime, '06/01/2020', 101) ELSE CONVERT(Datetime, [@field:endDate], 101) END Hope this helps.
Regards,
vitalikssssss
 

Hi @norkaman

Do you use the following syntax to reference first 2 parameters? 
[@WID] and [@LBE]?
Regards,
vitalikssssss

Hi @Ed727,
I am afraid that long text without HTML tags  will be rendered as a single line string.
Regards,
vitalikssssss

Hi @mgredmond,
Do you use View as a Datasource for the Datapage? 
Perhaps you trying to write a parameter into the table which is not editable.
Hope this helps.
Regards,
vitaliksssss

Hi telepet,
You can hide cascading fields from a user with HTML blocks. 
You may refer to this article for further information:
https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
Hope this helps. 

Hello telepet,
Please note that Search button can be referenced by id "searchID" and this id is not dynamic.
You can use following script to hide the Search button:
<script> document.getElementById("searchID").style.visibility = "hidden"; </script> You can find the id for referencing Caspio standard buttons in the following topic.
Hope this helps.

Hello telepet,
I am afraid that Caspio offers this as premium feature named SAML. It is available only on Corporate level subscription.
I would suggest designing your app in the way which will force the user to change his password in X number of days.
You can have a date field in authentication table which will store information about the date of password expiration and JS condition to check if password expired or not. Perhaps you can direct the user to Password recovery form, so he could change this password.
 
Hope this helps.
vitalikssssss

Hi Bill,
I would suggest using Formula field in the table instead of the Calculated field.
Formula-fields
You may use "CASE" statement to create records correction logic in formula field.  
Create a Report with predefined filtering criteria based on formula field in order to display only records which need a correction.
Hope this helps.
 
Regards,
vitalikssssss
 

Hello telepet,
I would suggest changing the number of "Rows to display" value (by default it has 5 rows) in the Advanced tab of Listbox setup.