-
I think I would go with your general idea. I'd have the workflow set up to run if an item is created or modified - first step would be to check if the field is "yes" and then if it is, send the email. It shouldn't just wait. However, you may want to handle for not sending the email multiple times - like, if the form is re-opened ...
-
Action rules do not fire unless a field changes. Formatting rules always apply. So if you have a formatting rule that is supposed to show something a certain color if a field is a specific value - then, as long as the field is that value, the formatting will apply. In other words, if you have a formatting rule to set the background green when ...
-
Since this is a list form, they are probably all bound to the same repeating group - in which case, inserting an instance will show for all. Can you explain why you need the sections to be independent?
-
How are the users changing the status in the display form so that the rule is firing? If the rule is on the status field it should only fire if the status changes....
-
SharePoint designer 2013 is the latest (last) version. And to the best of my knowledge still compatible with SharePoint Online.
-
I don't remember what version of SharePoint you are using - but is it on-prem? Do you have access to SharePoint designer? Perhaps an approach like this one will work for you: https://www.c5insight.com/Resources/Blog/tabid/148/entryid/193/how-to-make-sharepoint-list-form-fields-read-only-without-infopath.aspx
-
Thanks for posting your solution!
-
Oh, I've done this too.... basically, InfoPath is going to assume that the "\" in that case is part of an XPath (like my:group1\my:fieldwhatever) and not "div" which is what is used for division. if you click "edit XPath" in the formula editor on your fixed math, you'll see that "div" is what is ...
-
Give this copy a try. Save the file locally, right click and select design, then you can preview and try it.
-
There isn't anything built in. You can find a number of rather complex formulas on the internet for this - here is one example: https://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/