Jump to content

Vitalikssssss

Caspio Evangelist
 View Profile  See their activity

  • Content Count

    531

  • Joined

  • Last visited

  • Days Won

    54

 Content Type 

Posts posted by Vitalikssssss

  1. Use external database instead of the Caspio Tables

    in General Questions

    Posted

    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

     

  3. How to make my update form work

    in General Questions

    Posted

    Hi @Talmax,

    Here is some information which should help:

    1. You may use the following syntax to receive the parameter in custom elements such as <div> located in Datapage: [@PARAMETER_NAME]

    2. You may use timeout redirection settings if you have authentication enabled.

    8l4vrm5.png

    3. Make sure that you pass the parameter which identifies the record which will be shown.

    e.g. if you try to open below Datapage you would need to pass parameter with a name Record_ID and it should look like the following.

    https://xxxxxxx.caspio.com/dp/xxxxxxx273ac9f6ff0a41199812?Record_ID=3

    w7OA9cz.png

     

    Regards,

    vitalikssssss

     

  4. Hide/Format groups in tabular datapage

    in User JavaScript and CSS Discussions

    Posted

    Hi @NickO,

    It looks like it possible only with Collapsible group  --> Collapsed by default settings enabled:

    bnUllLr.png

    You may use the following JS if you have the same type in your Datapage: 

    <script type="text/javascript">

document.addEventListener('DataPageReady', hideRows);

function hideRows () {

document.querySelectorAll("td[class*='cbResultSetGroup1LabelCellNumberDate']").forEach(function (el) {
    
    if (el.innerHTML < 1000) { //replace this value with the one which you would like to set as target
        
        el.parentNode.style.display = 'none';
   
    }

});

document.removeEventListener('DataPageReady', hideRows);

}
</script>

    Hope it helps.

    Regards,

    vitalikssssss

  6. CASE statement returns a blank value no matter what

    in Calculations and aggregations

    Posted

    Hi @NickO,

    I think you need to simply combine the condition for assigning 'Primary' value with OR logic operator.

    Perhaps you should try the following expression: 

    CASE
WHEN 	

		[@calcfield:3] = 2 OR 
		[@calcfield:4] = 2 OR
		[@calcfield:5] = 2 OR
		[@calcfield:6] = 2 OR
		[@calcfield:7] = 2 OR
		[@calcfield:8] = 2 OR
		[@calcfield:9] = 2 OR
		[@calcfield:10] = 2 OR
		[@calcfield:11] = 2 OR
		[@calcfield:12] = 2 OR
  		[@calcfield:13] = 2 OR
		[@calcfield:14] = 2 OR
		[@calcfield:15] = 2 OR
		[@calcfield:16] = 2 OR
 		[@calcfield:17] = 2 THEN 'PRIMARY'
        
ELSE 'NOT'
END

    Hope this helps.

    Regards,

    vitalikssssss

  7. Interactive Filter for Results Page

    in DataPages

    Posted

    Hi @JDEV101,

    I doubt that it would be possible to replicate the same type of filtering but you can get close to it.

    You may look into creating a separate form based on Submission form with Virtual fields which will act as a Search Form by passing parameters to the Report.

    This concept explained in this tutorial video: https://www.youtube.com/watch?v=K3CKFjuSIt4

    You may make you Submission form interactive by using Rules: https://www.youtube.com/watch?v=K3CKFjuSIt4

    Hope this helps.

    Regards,

    vitalikssssss

     

  12. Copy a record in the same table

    in General Questions

    Posted

    Hi @DonateGood,

    You can use Triggered Action feature in order to create this type of functionality.

    1. You need to add new field based on which Triggered Action executes.

    dDK397M.png

    2. Create a Triggered action which will fire on update event.

    Note: You will need to use two blocks.

    First block "Insert" going to copy the record if the checkbox is checked and the second one "Update" will uncheck the box after copy has been made.

    qhnplpF.png

    Please note that you will need to click on "Refresh" button in order to see new records which has been copied.

    image.png.2a5ca74260167614b7cd1ccf8e6961

    Hope this helps.

    Regards,

    vitalikssssss

     

  16. Edit Page Suddenly Not Working

    in User JavaScript and CSS Discussions

    Posted

    Hi @ababcock,

    I think the issue caused by the invalid way how you try to reference the Update button. 

    document.getElementById('Mod0EditRecord').onmouseover = ...

    Caspio has recently introduced some changes in the way how ID of the element is generated.

    Unique postfix has been added to each element of a Datapage.

    jglYwu2.png

    You can use CSS selectors to get the element by partial name e.g.  

    document.querySelector("input[id^='Mod0EditRecord']")

    or by using class to refer to the Update button e.g. 

    document.getElementsByClassName('cbUpdateButton')[0];

    Hope this helps.

    Regards,

    vitalikssssss

  18. Layouts

    in DataPages

    Posted

    Hi @DruidCtba,

    In regards to your questions:

    1. Datapage and columns width adjusted automatically in order to fill out the container where it is embedded and to fit content of columns.

    You can define the width of the columns as explained in this article: https://howto.caspio.com/datapages/datapage-components/field-configuration-options/field-and-column-width/

    Quite often this setting gets overwritten if Datapage do not fit the container. You can define width of the Datapage (container) as explained in this article:

    https://howto.caspio.com/styles/fix-the-width-of-the-datapage/

    2. It is possible to have separate colors for Odd and Even rows. You can change the color of Even rows in the following settings in Caspio Styles:

    2G3oWeB.png

     

    3. It is possible to change the layout of fields. There is a checkbox field in "Advanced"which allows you to place fields in the same line and also change the position of labels.

    You can check this article for more information:

    https://howto.caspio.com/styles/put-multiple-fields-on-one-line/ 

    Hope this helps.

    Regards,

    vitalikssssss

     

     

  21. Change background color after expired

    in User JavaScript and CSS Discussions

    Posted

    Hi @vanderLeest,

    Please make sure that you use the expression in Formula field, since Calculated field/Calculated value do not support HTML output.

    Also, you need to tweak your expression because concatenation with "+" available only for string type.
    Also both logic block should return same datatype.  

    CASE
WHEN [@field:MS_InvAmount] > [@field:MS_Budget] 
THEN '<span style="color:#ffff00;">'+CAST([@field:MS_InvAmount] AS nvarchar)+'</span>'
ELSE CAST([@field:MS_InvAmount] as nvarchar)
END

    Hope this helps.

    Regards,

    vitalikssssss

×
×
  • Create New...