ContributionsMost RecentMost LikesSolutionsRe: Dynamic Form Rule Thanks as always Mark! Yep, the discussion was indeed tongue in cheek but this was exactly what was needed in this case! I mumbled a bit, went back the basics with pencil and paper, and just finished putting the Dynamic Form Rules into their place! ------------------------------ Eric Rovner ------------------------------ Dynamic Form Rule Hello, I'm hoping someone smarter than me can help! I am using Dynamic Form Rules to adjust the fields that show on a form. Here's a simplified example of what I am trying to do but can't figure out how to set up without triggering the Form Rules warning about 'show/hide rules' on the same field; If the fieldPart is set as "Tire", hide the field Interior If the fieldPart is set as "Wheel", hide the fields InteriorandConsumable If the fieldPart is set as "Reflector", hide the fieldsInterior, Consumable, and Replaceable If the field Part is set as "Paint", hidethe fieldsInterior, Consumable, Replaceable, and Size Thanks in advance for your counsel! ------------------------------ Eric Rovner ------------------------------ Editing a "New Form" I attended the 2023 Empower yesterday, took the session on the "New Forms", and created a new form as was demonstrated. Unfortunately, when I later went back to edit that new form I could only do so with the legacy form editor. What am I missing here??? TIA for your hive wisdom. ------------------------------ Eric Rovner ------------------------------ Re: Date Formula AssistanceBrilliant! I just added this date-formula field and it works like a charm. Thanks so much for your helpful explanation and assistance Ahuva, I truly appreciate it! -Eric ------------------------------ Eric Rovner ------------------------------ Re: Date Formula AssistanceThanks so much for the note Ahuva - seems like a terrific solution! I'm unfortunately unfamiliar with the AdjustMonth() formula. Would you be able/willing to share a sample formula for my situation just as you described? "...if the last inspection date is between August 1 and September 30, add 7 months to the date to get your next inspection date (using the AdjustMonth() formula), and if the last inspection date is between March 1 and April 30, add 5 months." Many thanks! ------------------------------ Eric Rovner ------------------------------ Date Formula AssistanceHello, I'm once again reaching out to the amazing community of folks way smarter than me for some assistance creating a formula that is absolutely stumping me but probably child's play for the community wizards! I've built an App for managing our fleet of vehicles - inclusive of Inspection Date tracking. For the inspection date tracking, our trailers must be inspected twice each year and said inspections must be performed within specific date "windows". One inspection must occur each year between March 1 and April 30 and then performed again between August 1 and September 30. I need to create a formula that projects the next inspection date for a trailer by referencing the last inspection date. Let's call the two fields "Last Inspection" and "Next Inspection". Given that an inspection can occur on any date within the allowed "window" (March 1 and April 30 and then again between August 1 and September 30), I cannot simply add a fixed addition of days to the "Last Inspection" to populate the "Next Inspection" because it could fall outside of the next "window". In other words, if a trailer's "Last Inspection" field is populated with a date between March 1 and April 30, the "Next Inspection" field must populate with a date between August 1 and September 30. For ease, it would be acceptable for the "Next Inspection" field to simply populate as August 1 in this case. Same scenario if a trailer's "Last Inspection" field is populated with a date between August 1 and September 30, the "Next Inspection" field must populate with a date between March 1 and April 30. For ease, it would be acceptable for the "Next Inspection" field to simply populate as March 1 in this case. Thanks in advance for any wisdom and assistance! ------------------------------ Eric Rovner ------------------------------ Re: Toggle Desktop View to Mobile ViewThank you Mike. Yes, I'm on my desktop trying to see how the QB form will appear in mobile view. So, I can certainly use the 'View as user" methodology - thanks. I assumed there would be a way to see the mobile view while working under my own role as admin. Much appreciated! ------------------------------ Eric Rovner ------------------------------ Re: Toggle Desktop View to Mobile ViewThanks for your reply Mark. Always appreciated! So, challenge is that I do not have such a smart phone icon as you referenced. Is there a setting somewhere to turn this on? Here's a screenshot of what I have. ------------------------------ Eric Rovner ------------------------------ Toggle Desktop View to Mobile ViewI can't seem to figure out how to toggle between desktop view and mobile view in my App. I realize I can set the default view for the App as mobile or desktop for non-admins but as an admin, how do I view (and edit) my App form in mobile view? Thanks in advance! -Eric ------------------------------ Eric Rovner ------------------------------ Re: Using Rich Text Formula Field to Display IconWorked like a charm - Thank You Mark! So appreciative of the timely and helpful answers. ------------------------------ Eric Rovner ------------------------------