Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    409
  • Joined

  • Last visited

  • Days Won

    11

Posts posted by NailDyanC

  1. Hi, just to add to the previous comment above. This can also be done in the DataPage level. If you would like to do it in this way. 

    You may use a calculated field that will determine if that value is already existing in your table and just add a JavaScript that will prevent the form to be submitted if the value is existing:

    CASE WHEN 
    (SELECT COUNT(field_name) FROM Table_name WHERE fieldname = [@field:fieldname] THEN
    'Existing' 
    ELSE
    'Not Existing'
    END

    Then, you may add this JavaScript in the footer of your DataPage:

    <script>

     document.addEventListener('BeforeFormSubmit', clickHandler);

    function clickHandler(event) { 

    var calc = document.querySelector("[id*=fieldID]").innerText;

     

    if (calc  == "Not Existing"){

    event.preventDefault();

    window.alert("Submission BLOCKED!");

    }

    else {
    document.location = "http://www.mysite.com/menu.html";
    }

    }

    </script>

     

    Just change the field names and table names depending on the field that you are using. 

  2. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to  the different fields, right? If that is the caseon your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2]  + ' ' + [@field:FieldName2] .......... on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. 

    I hope that helps.

     

    powersearch.png

  3. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to  the different fields, right? If that is the caseon your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2]  + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. 

    I hope that helps.

    powersearch.png

  4. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to  the 2 fields, right? If that is the caseon your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. 

    I hope that helps.

     

     

    image.png

  5. Just want to add to the previous comment above if you would like to know and start with Caspio. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below:
     

    Introduction to Table and Table Design  
    Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
    One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
    Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

     

    Caspio also has training materials that can help you in building your applications.

    You may want to visit them: 

    https://howto.caspio.com/

    https://howto.caspio.com/getting-started/

    https://www.youtube.com/CaspioInc

     

    And if you have any platform related questions,  I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. 

    You can reach them through this contact details: 

    Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line. 

  6. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below:
    Introduction to Table and Table Design  
    Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
    One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
    Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

     

    Caspio also has training materials that can help you in building your applications.

    You may want to visit them: 

    https://howto.caspio.com/

    https://howto.caspio.com/getting-started/

    https://www.youtube.com/CaspioInc

     

    And if you have any platform related questions,  I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. 

    You can reach them through this contact details: 

    Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line. 

  7. Hi, just want to add in the previous comment above, you may use a calculated field that will determine if that value is already existing in your table and just add a JavaScript that will prevent the form to be submitted if the value is existing:

    CASE WHEN 
    (SELECT COUNT(field_name) FROM Table_name WHERE fieldname = [@field:fieldname] THEN
    'Existing' 
    ELSE
    'Not Existing'
    END

    Then, you may add this JavaScript in the footer of your DataPage:

    <script>

     document.addEventListener('BeforeFormSubmit', clickHandler);

    function clickHandler(event) { 

    var calc = document.querySelector("[id*=fieldID]").innerText;

     

    if (calc  == "Not Existing"){

    event.preventDefault();

    window.alert("Submission BLOCKED!");

    }

    else {
    document.location = "http://www.mysite.com/menu.html";
    }

    }

    </script>

     

    Just change the field names and table names depending on the field that you are using.

  8. As I understand it, what you are trying to do is to add minute values to your timestamp based on when the field [@field:END_Pickup] is null?

    If the [@field:END_Pickup] is blank, the result of the formula should be the date on the [@field:Carrier_Date] + the number of minutes stated on the field [@field:ETA_to_Pickup].

    If the above statements are correct, may you please try using this formula:

    CASE WHEN [@field:END_Pickup] IS NOT NULL THEN DateAdd(minute, [@field:END_Pickup], [@field:Carrier_Date]) ELSE 'END Not Provided'END

    I hope this helps.

  9. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below:
    Introduction to Table and Table Design  
    Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
    One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
    Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

     

    Caspio also has training materials that can help you in building your applications.

    You may want to visit them: 

    https://howto.caspio.com/

    https://howto.caspio.com/getting-started/

    https://www.youtube.com/CaspioInc

     

    And if you have any platform related questions,  I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. 

    You can reach them through this contact details: 

    Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line. 

×
×
  • Create New...