Jump to content

BaySunshine

Caspio Ninja
  • Content Count

    56
  • Joined

  • Last visited

  • Days Won

    4

Reputation Activity

  1. Thanks
    BaySunshine got a reaction from awolagain in Free account   
    Hello @awolagain,
    You can request any app from Free App Templates for Your Online Database | Caspio to be uploaded to your account but keep in mind that the number of deployed DataPages allowed for free accounts are only 5. So, if you wish to deploy the app on a host and use it for your business, you will be able to do deploy only 5 of them at a time. However, if you want to just see and learn how the tables are designed and DataPages are built etc, you can do so without any issues. You can also preview any number of DataPages separately without having to deploy them. 
    To request an app to be uploaded to your account, select any app on that link and click on "Request app" button and fill out the form. The app will be uploaded by Caspio support team on the same or the next business day.
    I hope that answers your questions.
    Regards,
  2. Like
    BaySunshine got a reaction from Nicole in Select Distinct Records   
    Hi @bbeshlian,
    The solution for this issue is to use a table which has ID field marked as unique field in the table. Use this field as the data source of your report DataPage.  To show the rest of the fields in the report, use calculated fields with SQL queries to query the view based on the same ID value. Be sure to include a Where condition which will help only pull a certain record for the respective ID value.
    When using a view in the calculated field, add '_v_' to the name of the table like shown below:
    select field_name1 from _v_viewname where field_name2='..........'
    I hope that helps.
    Regards,
  3. Like
    BaySunshine got a reaction from kpcollier in 'Click to add more' or something similar?   
    Hi @kpcollier,
    You can use triggers to insert 3 lines in a new/existing table on an insert action in a table.  For calculating total cost estimates, you can use a report. 
    I hope that helps.
     
     
  4. Thanks
    BaySunshine got a reaction from Harbinger in Fixing concatenate function in JS code   
    Hi @Heineperson, 
    Caspio has stopped supporting onsubmit code:  https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/
    Please try the following fix:
    <SCRIPT LANGUAGE="JavaScript"> document.addEventListener('BeforeFormSubmit', function (event) { var x0 = document.getElementsByName("EditRecordassociatedSpecies")[0].value; var x1 = document.getElementsByName("cbParamVirtual2")[0].value; if (x0 && x1) {  document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0+"; "+x1; } else {   document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0 + x1; }  }); </SCRIPT>
  5. Like
    BaySunshine got a reaction from Heineperson in Fixing concatenate function in JS code   
    Hi @Heineperson, 
    Caspio has stopped supporting onsubmit code:  https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/
    Please try the following fix:
    <SCRIPT LANGUAGE="JavaScript"> document.addEventListener('BeforeFormSubmit', function (event) { var x0 = document.getElementsByName("EditRecordassociatedSpecies")[0].value; var x1 = document.getElementsByName("cbParamVirtual2")[0].value; if (x0 && x1) {  document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0+"; "+x1; } else {   document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0 + x1; }  }); </SCRIPT>
  6. Like
    BaySunshine got a reaction from RBobowski in Expressions in Triggers   
    Hello RBobowski,
    Expressions can be used in Select statement the way you did. You could also use 'Equal' or any other comparison operator instead of 'Exists' and compare the value with the aggregate calculated in the Select statement.
    Triggers do not allow usage of variables in Caspio like we do in any other programming language. You can have an alias for a field in the Select statement and use that alias in other parts of the same query such as in Where, Group By etc but cannot use it in other trigger actions such as insert, update or delete.
    Hope this helps.
    Regards,
×
×
  • Create New...