Jump to content

Barbie

Caspio Guru
  • Posts

    169
  • Joined

  • Last visited

  • Days Won

    6

Posts posted by Barbie

  1. Hello there @Kuroshi,

     

    I believe they have this article called Function reference which includes all the function that you can use in a formula. Here it is: https://howto.caspio.com/function-reference/. You can check the replace function as this can achieve your current workflow. Here's the formula:
     

    replace(replace(replace(replace(replace([@field:Name],'a',''),'e',''),'i',''),'o',''),'u','')

    You can change the field Name, by the way.

     

    Hope this works. 

     

    - Barbie

  2. Hello @Kuroshi,

    I also tried to use CSS but I believe we the only way to adjust it is by using JavaScript code. I used this and it worked.
     

    <script type="text/javascript">
    document.addEventListener('DataPageReady', chartUpdateHandler)
    
    function chartUpdateHandler(event) {
     var cleaner = function(interv) {
      clearInterval(interv);
     }
    
     let interv = setInterval(() => {
      if (!!Highcharts.charts[0]) {
       console.log(Highcharts.charts[0]);
       Highcharts.charts[0].update({
    legend: {
            layout: 'vertical',
            itemMarginTop: 5,
            itemMarginBottom: 5,
            padding: 5
            }
       });   
       cleaner(interv);
      }
     }, 200);
    }
    </script>

    I hope this helps.

     

    Regards,

    Barbie

  3. Hello @StephenMyall, I believe this is expected behavior. If the system noticed that it can't be display in one page, it will make another page for the remaining results. If you want to customize your PDF result, I read some information here in forum and this might need custom coding. I am not sure how do you want to achieve your current workflow but you can check with their support members. 

    Here's a reference regarding the topic: https://howto.caspio.com/datapages/pdf-download/pdf-download/

    Hope this helps.

  4. Hello @Kuroshi,

    I encounter this error before I don't exactly remember what is the RMA that I requested. But I resolved it by removing the 'Designated Entry Page' and setting it to none. I would also suggest to check the app parameters value since sometimes it is incorrect because it does not exist in your account. Please also refer to this:
    https://howto.caspio.com/authentications-and-connections/authentication/authentication/

    Hope this helps.

  5. Hello @Kuroshi,

    If the width of the Tabular report exceeds the width of the screen, if you try to adjust the width of any fields inside the DataPage itself, it will not be possible. But I have found a solution that you can use. Please use the CSS code below:
     

    table[data-cb-name^="cbTable"] tbody tr.cbResultSetTableHeader th:nth-child(5)
    {
    padding: 1px 120px !important;
    }

    You can change the number inside the nth-child(5) based on the position of the field.

     

    I hope this works. 

  6. Hi,

    Since you mentioned that you are importing a file in the table, triggered action will not work. So basically, this is expected behavior.

    Triggered Actions currently will not run from import of data through either manual import or DataHub tasks. This is also stated here: https://howto.caspio.com/tables-and-views/triggered-actions/

    Triggered action will only work if you are inserting the records manually inside the table.

    I hope this helps.

    -Barbie

  7. Hello, 

    This specific workflow can be achieve using JavaScript custom coding. I can provide you a sample logic for reference. 

    <script type="text/javascript">
    document.addEventListener('DataPageReady', function(event) {
    document.querySelector("input[name='Submit']").disabled = true;
    document.addEventListener('change', function(event) {
    var ID = document.getElementById("InsertID").value;
    if( ID == '')
    {
    document.querySelector("input[name='Submit']").disabled = true;
    }
    else
    {
    document.querySelector("input[name='Submit']").disabled = false;
    }
    });
    });
    </script>

    I hope this works. 

    - Barbie

  8. Hi again @Batchini,

    I tested this on my end and confirmed that even if you have special characters such as dash (-) and/or using ‘OLE Object’ as a DataType, Caspio will automatically fix it once imported. For the  OLE Object, it will be automatically change as Text(64000) once imported. 

    I hope this helps. 

    - Barbie

×
×
  • Create New...