Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by AtayBalunbalunan

  1. There may be various solutions to this using Triggered Actions, CaptnK. You may refer to the following as a sample reference. It is highly advisable to work on test tables and data when troubleshooting Triggered Actions to prevent modifications of your actual live data. You may try the above and check if it works for you.
  2. Perhaps, you may consider adding Formula Fields for the calculations. https://howto.caspio.com/tables-and-views/data-types/formula-fields/
  3. Seems that there is no example of this in one of their ready-made apps. But it can be achieved by following the instructions in https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/. If you could also provide screenshots or add more details to the workflow that you want to achieve, we may find a solution to it.
  4. From https://stackoverflow.com/questions/17186777/adding-padding-to-select-options: Other resources: https://stackoverflow.com/questions/5887133/how-to-style-a-select-tags-option-element https://stackoverflow.com/questions/12301729/styling-for-option-values-in-a-html-select-drop-down-doesnt-work-in-chrome-sa https://stackoverflow.com/questions/22681141/select-option-padding-not-working-in-chrome https://stackoverflow.com/questions/31177789/increase-gap-between-select-menu-options
  5. Can you provide a screenshot of your triggered action? It will also help if there's a screenshot of the tables, sample input and the results. Not sure if you want to bulk update records, but if it is, you may try Loops.
  6. The following library may help. https://www.jqueryscript.net/other/jQuery-Plugin-For-BarCode-QR-Code-Reader-WebCodeCam.html https://serratus.github.io/quaggaJS/
  7. You may also follow the suggestion in this post using additional DataPages.
  8. To prevent potential abuse/phishing, they also set a limit of 10 emails daily for Free and Trial accounts. It's best to contact Caspio for these cases. https://howto.caspio.com/troubleshooting/errors-and-messages/why-do-i-get-error-50522/
  9. For toggling password visibility, you may try the solution in https://www.w3schools.com/howto/howto_js_toggle_password.asp. For customizing forms, there are a couple of suggestions on https://howto.caspio.com/styles/.
  10. You can refer to https://forums.caspio.com/topic/11849-design-question/ for a suggestion using triggered action.
  11. There are several trigger setup that can achieve the output for this, kgraham2121. You can use the following for basis. I've used Variables and Loops. Please use test tables first when developing a trigger to avoid messing up with live data.
  12. This may be possible using triggered action depending on your workflow. How are you going to add new child records? If you are stamping an ID from the parent record to the child record upon insertion, you can update the value of the total number of child records in the parent record. Below is a sample. Your trigger will be different based on your table design.
  13. You can inspect the calculated field element. One way to get the value is by this code. document.querySelectorAll(".cbResultSetCalculatedField")[0].innerHTML;
  14. Can you check if there is an error in the browser's console, senicholas? https://wordpress.org/support/article/using-your-browser-to-diagnose-javascript-errors/
  15. Suggestions in https://stackoverflow.com/questions/23306882/javascript-close-current-window may work.
  16. You can achieve this with separate Search Page and Results Page. https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ Your report is filtered by the parameter while you have a search form which is actually a submission form.
  17. You can also get the unique ID for the DOM element using event.detail.uniqueSuffix. An example can be seen in https://howto.caspio.com/datapages/ajax-loading/.
  18. You need to add another condition, Corpcatalog. It will depend on how you filter it. If you have a default value, the formula would look like this: SELECT Count(SubscriptionComplete) FROM GrowerSubscription WHERE SubscriptionComplete="1" AND Manager="CorpCatalog"
  19. Please click Show Details when the prompt appears, heatherangela. It will tell you the list of dependencies. If it's a triggered action, you need to remove the field from there.
  20. Can you try the following code in your footer, Doolysw? <script> var yesNoSpan = document.querySelector("td[data-cb-cell-name*='EditRecordFIRE_PLAN']").nextSibling.firstElementChild; if (yesNoSpan.innerHTML == "No") { yesNoSpan.parentNode.parentNode.style.display = "none"; } </script> This is tested when the responsive option is disabled.
  21. Can you try TUMF_ID and Status without the square brackets?
  22. The following references might help. https://stackoverflow.com/questions/4676321/how-do-i-make-a-field-autofocus https://www.geeksforgeeks.org/javascript-focus/ https://www.w3schools.com/jsref/prop_text_autofocus.asp
  23. Why not use a Details Report? Then show search form with results below it.
  • Create New...