Jump to content


Caspio Evangelist
  • Posts

  • Joined

  • Last visited

  • Days Won


Community Answers

  1. Vitalikssssss's post in Is it possible to do a cross join (or a workaround) was marked as the answer   
    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.
  2. Vitalikssssss's post in Use external database instead of the Caspio Tables was marked as the answer   
    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:
    You may also consider using REST API for transferring the data from you database into Caspio:
    Hope this helps.
  3. Vitalikssssss's post in Create a Counter Card Data Page was marked as the answer   
    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.
  4. Vitalikssssss's post in Populate Field 2 Based on Value of Field 1 was marked as the answer   
    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.
  5. Vitalikssssss's post in Converting virtual fields to numeric values for use in calcualtions was marked as the answer   
    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,
  6. Vitalikssssss's post in How to configure a calculated field as a Search field in Data Page? was marked as the answer   
    Hello @ryancys,
    You may check the following tutorial video for more information related to the deployment of two Datapages in one web-page:
  7. Vitalikssssss's post in Unable to filter on VARCHAR created by formula was marked as the answer   
    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.
  8. Vitalikssssss's post in Passing non-Table field Parameters via Query String was marked as the answer   
    Hi @norkaman

    Do you use the following syntax to reference first 2 parameters? 
    [@WID] and [@LBE]?
  9. Vitalikssssss's post in Line breaks in Text(64000) fields not recognized in html block insert was marked as the answer   
    Hi @Ed727,
    I am afraid that long text without HTML tags  will be rendered as a single line string.
  10. Vitalikssssss's post in Left Join to Add/Update Child Records was marked as the answer   
    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.
  11. Vitalikssssss's post in Hiding Cascading Elements in form was marked as the answer   
    Hi telepet,
    You can hide cascading fields from a user with HTML blocks. 
    You may refer to this article for further information:
    Hope this helps. 
  12. Vitalikssssss's post in Possible to add "Reset Search" button next to "Search" buton? was marked as the answer   
    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.
  13. Vitalikssssss's post in Set passwords to expire was marked as the answer   
    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.
  14. Vitalikssssss's post in Show Specific Fields on Tabular DataPage was marked as the answer   
    Hi Bill,
    I would suggest using Formula field in the table instead of the Calculated field.
    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.
  15. Vitalikssssss's post in Possible to change height of listbox in a search form? was marked as the answer   
    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.
  • Create New...