Using "hidden" fields in dynamic form rules
I have a Request form that I need to validate the date and time for the date the service is requested. I created formula fields to use in the dynamic form rules, but I do not want these fields to be displayed on the form. If I don't include them on the form, the dynamic forms rules don't work. I tried including them, but for edit only and that did not work either. I tried putting the formula fields in a separate section and used a dynamic form rule to hide the section and that also caused the date test dynamic rules to fail. I have a test form with the fields displayed and the rules work perfectly. How can you configure the form so that the fields are not displayed, but they are available to the dynamic form rules? (without using javascript because that is above my skill set.) Thanks in advance for any help! ------------------------------ Julie Meeker ------------------------------
Subtract business hours from timestamp
I have a time stamp field called "Deadline" and I want to subtract business hours from it (weekday hours.) How? ToWeekdayP([Deadline]-Hours(#)) This doesn't work, it just knocks the result to a Friday if it falls on Sat/Sun. Subtracting 36 business hours from an 8am Monday deadline should return Thursday at 8pm, not Friday at 8pm. ------------------------------ Thanks, Jen Hamilton ------------------------------
URL Field Validation
Newbie here. Apologies in advance. I have set up a URL field. I had assumed that the field would automatically validate the entered value to ensure that it was a valid URL. But that is not the case. The only thing a URL field seems to do is turn the value into a link when viewed? How can I validate the value when the data is entered, either after the field loses focus or on submission, to ensure it is a valid URL? Submission could be entering the data in a grid or using a form. I am OK limiting the validation to when entering the data into a form. Thanks! ------------------------------ Tom Reynolds ------------------------------