Jump to content

Meekeee

Caspio Guru
  • Content Count

    218
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Meekeee

  1. Just an update: You could use the Calculated Values on this one. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions that you can use for your Total: https://howto.caspio.com/datapages/datapage-components/calculated-values/ OR Try to use Formula Field instead: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ I hope it helps!
  2. This is only for the progress bar of the page as also indicated here: If you want it to be redirected in a page, your new workflow is correct. I hope it helps!
  3. Just an update: You could now insert it in the emails, check it here: https://howto.caspio.com/automatic-emails/ I hope this helps!
  4. Just an update: You could try to check the Conditional Forms to disable the field: https://howto.caspio.com/datapages/forms/conditional-forms/I hope this helps!
  5. May I know what is the error or what might be the problem you were encountering? What is your expected result? Upon checking on it, it is getting the URL. Here:
  6. You could try to check the Conditional Forms to disable the field: https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps!
  7. You could deploy the two DataPages in one web page and check this article for your desired workflow: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ I hope it helps!
  8. You can refer to Caspio's link menus and pop-up window generator here: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/ I hope it helps!
  9. Just an update, if you wanted to show a certain image on the associated record. For display purposes, you could now use Virtual Field and Calculated Value. Or you may check this post: I hope this helps!
  10. Can you try this formula: CONVERT(DATETIME, CAST(LEFT([@field:Time],2) +':'+ RIGHT([@field:Time],2) AS VARCHAR(10)), 114)
  11. Hi @mdupras, Just an update. You may also use the new feature TASK on this certain scenario. This allows you to send emails based on a predefined time schedule which you can use to your workflow. To know more about Tasks, check it here: https://howto.caspio.com/tasks/ Check this video for more information I hope it helps!
  12. You may check this site to check: https://www.trustradius.com/compare-products/caspio-vs-firebase or see what customer says about Caspio here: https://www.capterra.com/p/137206/Caspio/reviews/ I hope it helps!
  13. You could also check this Forum post: For Rules, see this article for Action Limitations to see the fields that cannot be used. https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps
  14. Do you have your formula? You could try to check these links for Round function: https://stackoverflow.com/questions/9873990/round-to-5-or-1-0-in-sql https://www.sqlservercentral.com/forums/topic/rounding-to-the-nearest-50 I hope this helps.
  15. You may try IFNULL() or COALESCE() Function. Check this site for more information: https://www.w3schools.com/sql/sql_isnull.asp https://stackoverflow.com/questions/16840522/replacing-null-with-0-in-a-sql-server-query
  16. Hi @jleslie, You could add a Rule to your web form that will disable your Autocomplete. You may check this article for more information: https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps!
  17. Hi @nhunsaker, Just an update. You may also use the new feature TASK on this certain scenario. This allows you to send emails based on a predefined time schedule which you can use to your workflow. To know more about Tasks, check it here: https://howto.caspio.com/tasks/ Check this video for more information I hope it helps!
  18. As for the link you have provided, it will require custom code. However, based on your workflow, there might be another solution that can be suited to it but it will depend on your table design.
  19. Hi @Elderberg, For Header and Footer, you could only use HTML or JavaScript code. Reference: https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/ SQL Select Stataments are functions that you could only use Calculated Field and Value. Reference: https://howto.caspio.com/function-reference/ I hope it helps!
  20. Hi @Sherif, You could check this site for getting difference between hours: https://www.w3schools.com/sql/func_sqlserver_datediff.asp
  21. Hi @davidhshugar, You may check this related forum post: I hope it helps!
  22. Hi @Mikey, I think what you can do is have a lookup table for your default image and get the FileStor link to your Submission Form as Calculated Value for the image link to be saved in your table. You might refer to this post and article about FileStor CDN: https://howto.caspio.com/files-and-images/filestor-cdn/ By means of Calculated Value, you can get the value in your field by using SQL: https://howto.caspio.com/function-reference/ Calculated Value: https://howto.caspio.com/datapages/datapage-components/calculated-values/ I hope it helps!
  23. Have you tried to check this article for previewing images: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-a-lightbox-view-for-images/
  24. Hi @GWBjr, You could check these articles about Grid Edit and Report DataPages: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ https://howto.caspio.com/datapages/reports/ https://howto.caspio.com/datapages/reports/creating-a-report-datapage/ I hope it helps!
  25. Just an update: Caspio released a new awesome video about Progress Bar. You might check this one out!
×
×
  • Create New...