ContributionsMost RecentMost LikesSolutionsRe: Abort Form Save if Date Field outside of range? Hi Mark, question on my form rule. For some reason that is confusing me, users have been able to submit the form even when the rule should block them. Here is what I have: I have a "Start Date" field: regular Date field. This is the field I am checking to see if it is more than 14 days from today. I have a "StartDateRule" formula checkbox field that contains the following formula: If([FRF_StartDate] <= Today() + Days(14), true). So if the StartDate field is within 14 days of current date check this field. My rule is the following: My issue is I have had a couple of forms submitted with dates that fall within the 14 days and the formula checkbox is checked. Here is a screenshot of the sent out form submission notification: This form, by rule, should not have been able to be saved. Any idea why this may be happening? Thanks, Brian ------------------------------ Brian Dunk ------------------------------ Re: Abort Form Save if Date Field outside of range? That did it! Thanks so much for everyones help! ------------------------------ Brian Dunk ------------------------------ Re: Abort Form Save if Date Field outside of range? Looks like I am on a legacy form. Is there an option to do this there? ------------------------------ Brian Dunk ------------------------------ Re: Abort Form Save if Date Field outside of range? Thanks Chayce, one question. I don't recall seeing the option to popup a message and abort the save. Is that something that shows on Checkbox fields? Brian ------------------------------ Brian Dunk ------------------------------ Abort Form Save if Date Field outside of range? I was wondering if its possible to create a rule that will not allow the user to save a form if a date field value is less than +14 days from the current date? Also, could a message popup explaining the issue? Thanks, Brian ------------------------------ Brian Dunk ------------------------------ Re: Populating a Date field from another Record There is a relationship setup where an employee has many Incidents (records) that have the warnings on them. ------------------------------ Brian Dunk ------------------------------ Re: Populating a Date field from another Record Hi Mark, sure. Answers to your question on Older Record. I am just referring to a previously submitted record prior to the new one being submitted. What I am trying to do is show the date if this employee has had a previous verbal warning on this new record for a written warning. I have a date field that is being automatically filled when an Exact Forms Plus document is generated. That is the one being filled when the button is clicked. What I am hoping to try to do is fill in a field "Verbal Warning Date" on the new record with the date of that field. The rule is both records must be from the same name on the both records. So essentially what this would be doing is going back through all records in the table looking for the same employee name and checking to see if the "Verbal Warning Document Creatio Date" field is filled in. If it is, fill in the "Verbal Warning Date" field with that date. Thanks ------------------------------ Brian Dunk ------------------------------ Re: Populating a Date field from another Record Bumping to the top. Hoping someone has some insight into this. Thanks, Brian ------------------------------ Brian Dunk ------------------------------ Populating a Date field from another Record I have a table with a Date field called "Verbal Creation Date". This field is auto populated when a button is pressed. What would be the best way to auto populate a field called "Previous Verbal Dates" if the Name on the record matches on a new record. So in other words, if the name on the older record matches the one on the newly created record and the old record "Verbal Creation Date" field is populated, populate the new records field "Previous Verbal Dates" with the date in the old records "Verbal Creation Date" field. Thanks, Brian ------------------------------ Brian Dunk ------------------------------ Horizontal Rules Between Sections Is there a way to display horizontal rules on specific sections and not on others on the same form? Thanks, Brian ------------------------------ Brian Dunk ------------------------------