Time and Date for If a Field was Changed?
Hi Folks, I'm not sure this is the best way to put this together, but here is my scenario. I have 1 table (Intersections) that includes fields for "Name" (Text), 5 different "Route" Checkboxes, 5 different "Route Sequence" (Numbered 1 - 50ish), "Status" (Dropdown choice). Caveats: Each Intersection "Name" can have multiple "Route" Checkboxes checked. My Questions are: I would like to capture a Date Time, if the "Status" Dropdown was changed. AND Create a report based on the last Status time. (If Row Item status was changed within the last Day, add to report). Is there any way to do that? Thank you for any assistance. Will ------------------------------ William Wallace ------------------------------How to get values from a fields on the form and display them?
I'll have a form with Main Contact(text), Invoicing Contact(text), Second Contact (text) and etc. Need to find a way to store all this information in one field and display it on a form. ------------------------------ Olena Bilinska ------------------------------
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 ------------------------------
