ContributionsMost RecentMost LikesSolutionsRe: Testing for a file attachmentI have a similar request, but I'm not following the above steps to get my use case to work and was wondering if you could help me. I want a form rule to show (and require) a checkbox field if a file has been attached. I created a formula checkbox field called Photo Attest with the following formula If(ToText([FileUpload]) <>"", True, False) How do I create the dynamic form rule? I've tried but it won't let me pick the File Upload field if I chose the Photo Attest field as the "when" condition. I'm just not getting the logic and the syntax of how this all comes together in dynamic form rules...I so wish they'd add if/then statements and multiple conditions in Dynamic Forms. Thanks!Re: Hiding and Showing Multiple Sections with Dynamic Form RulesIndeed!You are like the QB Jedi Master.I should've slowed down and re-read your post like you said.The answer was in there all the time!I was adding unnecessary info to it, causing my problems.Many thanks.Re: Hiding and Showing Multiple Sections with Dynamic Form RulesOK, that worked! I feel like an idiot.So basically I was making it more complicated with the hide actions and that was breaking things. You are a rockstar!Seriously, I've read so many of your posts and your help is tremendous.Re: Hiding and Showing Multiple Sections with Dynamic Form RulesSo I can't have it work in an accordion style?What I am trying to do is only show the section pertaining to the choice selected in the Milestone Type field.So if someone selects Budget, that's all they see on the form and if they select Charter, that's all they see.Re: Hiding and Showing Multiple Sections with Dynamic Form RulesLet me reiterate I greatly appreciate your help.I'm just not understanding what I am doing that is different from what you are suggesting.The dynamic rules won't allow me to have multiple rules.Re: Hiding and Showing Multiple Sections with Dynamic Form RulesAgain, thank you for the quick reply.I believe I did and that's what I posted above.Rule 1 is When [Milestone Type] = "Charter" ShowSection "Charter information" Hide Sections for "Budget" and "Inventory" Rule 2 is When [Milestone Type] = "Budget" Show Section "Budget" and Hide sections for Charter and Inventory.I get an error message.Re: Hiding and Showing Multiple Sections with Dynamic Form RulesI appreciate your suggestion and I have done that and still no bueno. I have tried to set up a multiple choice field [Milestone Type] with set of values ("Charter", "Budget", "Inventory") then in the dynamic form I created 3 rules.The first is When [Milestone Type] = "Charter" ShowSection "Charter information" Hide Sections for "Budget" and "Inventory"This rule works great.But when I add Rule 2, which is When [Milestone Type] = "Budget" Show Section "Budget" and Hide sections for Charter and Inventory, I get the form rule error message because QB only looks at the last rule and sees duplicate rules on the same field.Alternatively I set it up so that my Milestone Types were individual checkboxes and then created a rule on each individual checkbox, but that doesn't work either because QB looks at the show/hides in each rule and sees duplication.This is utterly frustrating as the logic is simple and this should not be that difficult.I appreciate anyone's insight...feeling thwarted by something so basic.Thanks, MarkRe: Hiding and Showing Multiple Sections with Dynamic Form RulesI am not following where I would implement this in dynamic form rules.I have the same issue.I have a multiple choice field that i want to trigger show/hide specific sections based on the value in the multiple choice field.The dynamic form rules doesn't seem to allow this.For example, I have a field called Milestone type.It has 3 values (A, B, C).If value A, show section 1, hide section 2 and 3.If value B, show section 2 hide section 1 & 3.If Value C, show section 3, hide section 1 & 2.This would seem to be simple logic in an if/then logic test, but dynamic forms only has a when statement.Please help...how do I achieve this desired functionality?Thanks, Mark