Jump to content

BaySunshine

Caspio Ninja
  • Posts

    60
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by BaySunshine

  1. Hi @pmcfarlain, While I didn't grasp all the details you provided, I can make some suggestions to improve your task: 1) Modify WHERE in UPDATE clause to specify which records in tbl_ggl_job_lines_days table should exactly get updated. Since there is no reference to any fields from tbl_ggl_job_lines_days, the one value that is returned from SELECT will get updated to all the records in that table. Here is one example you can refer to: This will update only the records where the IDs in both tables match. 2) Modify SELECT query and add the joins that you have added below in the UPDATE part to this query including WHERE Unit_Type = "FREIGHT". I am not sure if you need to add these joins only in SELECT query or add in both SELECT and UPDATE but they have to be added in SELECT query for sure. I hope this helps.
  2. Hi @chuckiecc, Are you not able to add your code in a HTML block? Can you give more details on your issue so I can give you a better suggestion?
  3. Hi @af123, When adding any script in HTML editor, always click 'source' and add it or disable the editor by unchecking the box below and then add the code. If not, the code will show as it is and will be read as text instead of JavaScript code. Also, the URL in the screenshot seems incorrect. It cannot have both http and https. Try removing "http://www." part from it and test.
  4. Hi everyone, Caspio has a howto article on this topic: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ Hope that helps.
  5. Hi @Yelbic, To display a image, add a HTML block, Click on the image icon on the right and open the dropdown and choose the file field. You can specify the width and the height of the image to customize the size of the image.
  6. Hi @jeffs88keys, You can give the following a try: 1) Add a HTML block in your report. 2) Click Source and add the following code: <span id="[@field:ID#]showDisclaimer1" style="color:red"></span> <span id="[@field:ID#]showDisclaimer2" style="color:blue"></span> <script> if("[@field:photo/]") { document.getElementById("[@field:Id#]showDisclaimer1").innerHTML="DISCLAIMERS OUT OF COMPLIANCE"; } else { document.getElementById("[@field:Id#]showDisclaimer2").innerHTML="DISCLAIMERS IN COMPLIANCE"; } </script> Replace "ID" in [@field:ID] with the actual unique ID field name in your table. Also, replace "photo" in [@field:photo/] with actual file name in your table. Also add the other field that you wanted to verify in the IF condition. I hope this helps.
  7. Hi @sfraden, Please try adding your code within the BeforeFormSubmit event function. This should ensure to perform the validation after all the fields are populated. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { // do something }); </script> Regards,
  8. 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,
  9. Hi @sfraden, How about you add a calculated value in your submission form and perform the validation before submitting the form? Add a virtual field to your form, change the form element to calculated value. Using CASE WHEN and SELECT query, validate to see if the record already exists in the table. If it does, then return 1, else return 0. In your JavaScript, verify the value of this virtual field. If the value returned is 0, then submit and the form. If the value returned is 1, then just redirect the form. The formula in the calculated value can be written as follows: CASE WHEN (SELECT ID FROM TABLE_NAME WHERE FIELD1=TARGET.[@field:FIELD1] AND FIELD2=TARGET.[@field:FIELD2] AND.....)!='' THEN 1 ELSE 0 END Hope this helps.
  10. Hi @Batchini, You can use calculated value or field if you want to concatenate the fields from the same record. Can you give an example so I can provide you a better solution? Regards,
  11. Hi, Try adding a progress loading bar as suggested in the video below: Adding a Progress Loading Bar to Caspio DataPages - YouTube **Insert inside the Header of your DataPage** <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/pace/1.0.2/themes/black/pace-theme-loading-bar.css" /> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pace/1.0.2/pace.min.js"></script> <script> Pace.on("done", function(){ setTimeout( function() { document.getElementById( 'cb-content' ).style.display = 'block'; }, 200); }); </script> <div id="cb-content" style="display:none;"> **Insert inside the Footer of your DataPage** </div> Regards,
  12. Hi @wgroth, Can you attach a screenshot to show when the code did not work? For me, the code that @rush360 suggested is working fine. Thanks,
  13. The above code will not work for the new DataPages that have "Responsive" checkbox enabled. You can use the following instead for such pages: <style> div { margin: auto; } </style>
  14. Hi everyone, Email trigger does not still allow attachments in Caspio. However, a workaround it is to create another table using a trigger which will store just the email addresses, count of records and any other information as you wish. Make sure that the email address field is unique so you don't accidentally store it more than once. Include IF statement in the trigger and use 'exists' or 'not exists' operator to verify if an email address exists. Add a checkbox field in the new table and also a date field to store the date the email was sent. Run a task everyday which will send out an email for all the email addresses in this table once. Check the box once an email is sent and update the date field. In the email body, include a link that will pass this email address to a filtered report DataPage as a parameter. The users can click on the link to view the records. I hope this helps. Regards,
  15. Hi @DesiLogi, The error "Values cannot be submitted due to a data restriction" can be caused due to formula fields or triggers. Do you have those in your table? If you do, check those first. Disable trigger temporarily and try. If there is formula field, verify if the formula used is correct. Other way to confirm if JS is causing this error is by removing the code from the DataPage and test it. Before that make sure to save it on notepad or some place. If you still get the error, then it means that there is something else that is causing the error. Regards,
  16. Hi @NickO, Any time you have a many-to-many relation between two tables, always create a third table which has ids from both tables. That way you avoid having this kind of an issue. Example of a many-man-many relation: In this example, Orders and Products table are related many-to-many. So, a third table is added, Order_Products which will join these two tables individually by one-to-many relationship. I hope that helps. Regards,
  17. BaySunshine

    Tim

    Hi @TimJaggs, The only way to do an auto save in Caspio is by using Grid Edit functionality of a report. The Grid Edit works like an Excel sheet wherein you enter data in each cell and the system automatically saves the data. Here is the howto link for Grid Edit: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ The other suggestion that Caspio usually gives for long forms is to create a multi-step form. In this the first step uses a submission page and the rest uses Details page with auto submission. You can refer to the steps from this article https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/. Hope it helps.
  18. Hi @arnold, You cannot add fields dynamically to a table in Caspio. As a workaround for your use case, you can add some extra fields in the table and rules to show/hide them in the form. Refer to the howto article https://howto.caspio.com/datapages/forms/conditional-forms/ for help on creating rules in a submission form. Hope that helps.
  19. Hello @MrsWhitebread, To achieve this workflow, create a view for client-funder table based on the matching issue area. Then create a report DataPage using the view as the data source and filtered on predefined criteria. Pass search values for client, funder and issue area of match as parameters to the DataPage. It will then pull the matching results based on the specified criteria. I hope that helps.
  20. 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,
  21. Hi @Durand, Is your Description field set as a Cascading text field to show the description of a part number from another table? If so, I advise you to add a Virtual field and change the form element of this field to 'Calculated value'. Add a Case..When statement as below: ************* Case when [@field: Part_Number] is null Then 'Invalid Part Number' End ************* Add a Rule to the DataPage for both the Virtual field and the Description field. Rule 1: Part number field 'is blank', 'hide' Description field Rule 2: Part number field 'is not blank', 'hide ' Virtual field. I hope that helps. Regards,
  22. Hi @JanineB, Tasks can be set to run at specific intervals during the day, week or a month etc. However, if you are looking for updating the empty values as soon as they are inserted, you can use a trigger. For this, create a triggered action on the main table based on an insert action on the table. Then add a update trigger to update the inserted table field. Add a join to join the inserted table with the city table based on their ids. Hope that helps.
  23. 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.
  24. Hi @FinTheHuman, Add left and top features to your code and you should be able to place it anywhere on the window. <a class="workorder" href="#" onclick="window.open("https://www.google.com/","mywindow", "menubar=1,resizable=1,width=750,height=950, top=150, left=500")">Google</a> I hope this helps.
  25. Hi @george43, Thanks for correction. I missed it. Yes, it should be document.getElementsByName("Value1_1")[0].value.
×
×
  • Create New...