Validation Logic in custom forms

Use case: I wanted to develop a way to enter a time separately from a date. This is for a team who is planning on using workfront objects to store a delivery time (e.g. emails sent at XX time) but often had changes involving time (e.g. for this week, let's send all emails at 2AM instead of midnight).

My first try with the help of copilot, was just to develop a field for HH:MM. I'm still trying to figure out whether I should add AM/PM or make that a separate field.

IF(

  LEN({DE:Time Field})!="5" ||

  LEFT({DE:Time Field},2)<"01" ||

  LEFT({DE:Time Field},2)>"12" ||

  RIGHT({DE:Time Field},2)<"00" ||

  RIGHT({DE:Time Field},2)>"59" ||

  !CONTAINS(":",{DE:Time Field}),

  "Please enter a valid time in HH:MM format (01-12 for hours, 00-59 for minutes)"

)

 

 

Adding link to existing post:

https://experienceleaguecommunities.adobe.com/t5/workfront-blogs/sneaky-sys-admin-shenanigans-tricking-project-templates-to-only/ba-p/776614

Use Case: forbidding the ability to create a project from a template that should only be attached after a project is created.

See link for code/screenshots

Thanks @katherinela !