Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


douvega last won the day on September 7

douvega had the most liked content!

About douvega

  • Rank
    Advanced Member
  • Birthday 01/12/1989

Recent Profile Visitors

475 profile views
  1. douvega

    Estimate app

    Hi, To provide you with a strong answer, I would need to know how you are submitting new records to the database. However, I can also point you to this article https://howto.caspio.com/datapages/datapage-components/calculated-values/ which will show you how to use calculated values in the datapage. You can call price from your cost tables and calculate live in your submission datapage. I hope it helps. Regards.
  2. douvega

    Show or Hide Search in datapage header

    Hi, Have you tried to use your same div tags but in datapages header and footer? I mean, in the search configuration wizard, you should add Header/Footer and disable the HTML editor of these fields. Then, in the header you put <a href="#filter" data-toggle="collapse" style="color:green;"><i class="fa fa-filter" aria-hidden="true"></i> Search/Filters</a><div id="filter" class="collapse"> In the Footer, you close the div by using </div> If that one does not work, then we can try to loop through the HTML by using JS and get the table id by using the AJAX event handlers and add and .hide() or show() with jQuery. Hope to hear from you soon. Regards
  3. Hi, I think you could use some jQuery lines to grab those 3 cells and hidding them. Could you please deploy the datapage in URL mode and share the link to provide you with the proper coding? Please remove authentication if applicable. Regards.
  4. douvega

    Calculated Values in Update Datapages

    Hi, You can do that with custom JavaScript so the value gets recalculated when user enters a new digit in your field. To make it easier, I would recommend this JS plugin: http://autonumeric.org/ If you share the calculation you need, the name of the editable field and the method you are using to deploy your datapage, I could help you with the piece of code you would need. Regards.
  5. douvega

    Simple Check Box To Download

    Hi, If I understood correctly, you are trying to download the entries that you have selected via the checkbox field. If that is the case, then it is not that simple. I would explore JavaScript to reach something like that. You may have the checkbox with a unique id for each entry, then when checked store data into an array variable or remove it if checkbox is turned off, then a download button that creates a .csv or pdf, this using a plugin. Other option would be to store the selected entry keys and create a query that can be used in a new datapage that display whatever query you created by previously selecting entries. In any case, custom (possibly advanced) JavaScript coding is needed. Although I know I am not resolving your question, I hope to give you at least some light for you to achieve it. Regards.
  6. douvega

    API to Import Data from end user

    I would like to recommend you THIS 3RD PARTY SERVICE to import data through the API to Caspio. You can upload data from .csv files.
  7. douvega

    Bulk Update Yes/No Field

    Hi, You can create a Report > Tabular datapage: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/ Then enable the bulk edit option: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ I hope it helps.
  8. Hi, Please check this article: https://howto.caspio.com/files-and-images/uploading-files-and-images/ Scroll down to the section "Displaying and Downloading Files in Apps". If your question is not answered after reading that article, please share more details such as: Where are you storing the image?
  9. douvega

    (REST) Insert multiple records at once

    Hi everyone, I have discovered THIS SERVICE which will allow you to POST multiples entries or even uploading .csv data.
  10. Hi, It seems this is a one to many relationship case. You should have two tables, Bookings and Customers. From the tables perspective, you must create the booking first and the associate as many customers as you may need to one specific booking (please let me know if this is the intended behavior). So, you can use a submission form to create the new booking and then redirect the user to a tabular page that handles the booking customers but pass the newly created booking ID as a parameter. Check this article about how to deal with parameters https://howto.caspio.com/parameters/ In the tabular form based in the customers table, you use the Add records in top option in the page results section. This should have a hidden field that would receive the booking ID. This way you can associate as many customers as you need to the booking. Hope it helps.
  11. douvega

    counting in table

    Let me give you a general flow, remember that a strong backend structure will allow you to manage your app correctly. From the case you have exposed, your should have the following tables: Training_Centers Courses Batches Users Batch_per_Student Then, table relationships properly set up, where 1 training center may have several courses, etc. Remember this is a suggested structure, you may have it built already in such case I would have to get more details about it. You should base your datapage in a view that Displays the batches and then include a calculated field in the datapage with the following sql for counting passed students: SELECT COUNT(Training_Status) FROM STUDENTS_MASTER WHERE Training_Status='Pass' AND Batch_Rel_ID='[@the batch id field]' If you need another column with failed students, then change the Training_Status='Pass' part for Training_Status='Failed' which is the filter to know what to count. As mentioned above, depending on your tables structure, the query may change. Try to get the logic behind it so you can apply it to your specific case. Don't hesitate to ask more questions if you are still unclear it, include any details so the answer can be more accurate. Regards.
  12. douvega

    Passing Parameter from Parent URL to Embedded tabs

    I assume you are using the iFrame deployment method. If that is the case, you need to pass the parameters to the iframe src attribute. For example <iframe src="yourdomain.com?parameterA=value..." To grab the parameters from the parent URL, then you will need some JavaScript. Please follow these instructions. Add a unique ID to each iframe. <iframe id="frame1" ... Then, add the following JS to the web page that hosts your tabbed interface: <script> var urlParams = new URLSearchParams(window.location.search); document.getElementById("iFrame1").src = "yourdomain.com?parameterName=" + urlParams.get('the URL Parameter Name'); document.getElementById("iFrame2").src = "yourdomain.com?parameterName=" + urlParams.get('the URL Parameter Name'); document.getElementById("iFrame2").src = "yourdomain.com?parameterName=" + urlParams.get('the URL Parameter Name'); </script> Assuming your parent URL is similar to this: yourdomain.com?myParameter=Abc then the corresponding JS line would be like this: document.getElementById("iFrame1").src = "yourdomain.com?myParameter=" + urlParams.get('myParameter'); //This will create the correct source and will pass the parameter to the iFrame.
  13. douvega

    Authentication/Login Page Looping Issue

    Yes, I have had some reports too.
  14. douvega

    Authentication/Login Page Looping Issue

    Try this. Add a field or change something in your authentications and save them. Remove the field previously added or revert the changes and save the authentication again. It seems it works somehow. Let us know what happens.
  15. Keep in mind that premuim options would add premium costs. Although, I agree with the idea of Caspio offering Webhooks, it is not currently available, so work arounds require either 3rd party services or backend development. I would say Zapier would be the best option for you in this case since they can watch over new or updated records so you can process them automatically.