Jump to content


Caspio Ninja
  • Content count

  • Joined

  • Last visited

  • Days Won


douvega last won the day on December 6 2017

douvega had the most liked content!

About douvega

  • Rank
    Advanced Member
  • Birthday 01/12/1989

Recent Profile Visitors

428 profile views
  1. 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.
  2. 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.
  3. 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.
  4. douvega

    Authentication/Login Page Looping Issue

    Yes, I have had some reports too.
  5. 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.
  6. 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.
  7. Hi, I could recommend you playing around with this app template provided by Caspio. Then, you can add a datapage that will only hold the username next to the LOGOUT button in the top navbar of the above mentioned app. It could be a HTML datapage using an Authentication that holds the user name. Optionally, if you have more advanced HTML knowledge, you could create a dropdown that shows only the name and the options under it would be My Profile and Logout, I usually do that and it looks nice. Hope it helps. Regards.
  8. douvega

    Hiding Duplicate Records with Same Field Value

    Hi, You have two options at this stage. If you have multiple records that share the same ID, then you need to reestructure your table as there must be a one to many relationship between them. Once you do that, you base your report in the unique records table. Please review the following articles to make sure you understand table relationships and its importance: * Relationships * Relationship settings * Managing relationships If you are not keen of getting your database properly configured as described in step one, then you can use Group option in the report datapage. This article will guide you through the steps. Regards.
  9. douvega

    counting in table

    Hi, You can accomplish that by using Calculated Fields with SQL subqueries in your report. Please check this article for more info about this approach. Just in case you are still unclear about it after reviewing the above article, you can share the name of the tables or views you would use for the calculations so we may help you with a sample SQL query. I hope this helps, Regards.
  10. douvega

    Unique over two fields

    Hi , This is possible within Caspio. You just need to create a formula field in the table level which joins the fields you are interested in being unique across records and then mark this field as unique. Check this article for more info. Regards.
  11. douvega

    DataPage Pricing

    Hi @herrma29, If datapage usage is your concern, I will recommend you consulting with an experienced Caspio developer to look at possible options to help your app stick within the limits of your budget, it is not always possible but it is not imposible by integrating some JS plugins or custom code, you will be surprised of how flexible Caspio can be. I hope you can find an appropriate solution for your case. Regards.
  12. Hi @LyaP Alternatively, you could use this service to look for an appropriate flow for your request. I can think only in an API solution. However, I am also sure Caspio could create this behaviour for you in a custom development project. I hope it helps. Regards.
  13. Hi @46hypex, The work around is to store your files in an external storage service such as Google Drive, AWS S3 or Dropbox and then get the link in your Caspio table to display it as a downloadable URL for everyone. This is done through API connections for which you may need custom development. This is just a suggestion so you can consider this option. Regards.
  14. douvega

    Authentication/Login Page Looping Issue

    A temporary solution is clearing your browser cache. I was told they are aware of this issue and they working on it.
  15. douvega

    Custom Dropdown Choices

    Hi @Casey, You can call fields and data from another tables(s) or view(s) in a Details section of a report datapage through calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/, please go to "Subqueries in Calculated Fields" section on that page. I hope this can help. Regards.