Jump to content

Meekeee

Caspio Guru
  • Content Count

    222
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Meekeee

  1. Hello @DDNex, Are you referring to conditional show of link based on the a certain value? If yes, you can create a Calculated Field to get this value then use the Calculated field in the HTML Block. Calculated Field Formula: CASE WHEN [@field:Requested_Action]='Update Sales' THEN 'https:<yourlink>?Request_ID=[@field:Request_ID]' ELSE 'https:<yourlink>?Request_ID=[@field:Request_ID]' END Then add this in HTML Block: <a href="[@calcfield:1]">View Request</a> In the Report, you will see the Calculated field, if you would like to hide
  2. Just an update, for new version of Styles and when your DataPage's configuration is set to "enable responsive". Here's the new code: Header: <style> #target table:nth-of-type(1) td:nth-of-type(5) {display: none;} #target table:nth-of-type(1) th:nth-of-type(5) {display: none;} </style> </header> <div id="target"> <header> Footer: </footer> </div> <footer> Thank you @Vitalikssssss for this solution. For reference of new responsive feature, you could check it here: https://howto.caspio.com/datapages/responsive-da
  3. 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!
  4. Just an update: You could use Virtual Field instead and have it as Calculated Value. You can insert the email address in the Virtual Field and set it to the "To" Address. For more information about Virtual Field and Calculated Value, check it here: https://howto.caspio.com/datapages/datapage-components/virtual-fields/ https://howto.caspio.com/datapages/datapage-components/calculated-values/ I hope it helps!
  5. 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!
  6. 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!
  7. Just an update: You could now insert it in the emails, check it here: https://howto.caspio.com/automatic-emails/ I hope this helps!
  8. 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!
  9. 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:
  10. You could try to check the Conditional Forms to disable the field: https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps!
  11. 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!
  12. 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!
  13. 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!
  14. Can you try this formula: CONVERT(DATETIME, CAST(LEFT([@field:Time],2) +':'+ RIGHT([@field:Time],2) AS VARCHAR(10)), 114)
  15. 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!
  16. 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!
  17. 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
  18. 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.
  19. 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
  20. 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!
  21. 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!
  22. 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.
  23. 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!
  24. Hi @Sherif, You could check this site for getting difference between hours: https://www.w3schools.com/sql/func_sqlserver_datediff.asp
  25. Hi @davidhshugar, You may check this related forum post: I hope it helps!
×
×
  • Create New...