Meekeee

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!

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!

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!

Can you try this formula: CONVERT(DATETIME, CAST(LEFT([@field:Time],2) +':'+ RIGHT([@field:Time],2) AS VARCHAR(10)), 114)

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!

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!

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

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.

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

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!

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!

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.

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!

Hi @Sherif, You could check this site for getting difference between hours: https://www.w3schools.com/sql/func_sqlserver_datediff.asp

Hi @davidhshugar, You may check this related forum post: I hope it helps!