DeepaPrashant1
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Getting stuck on this form rule...
I have AND statements nested in an OR statement and it is not working. I initially simply tried to say: If "Asset Sub number" is anything other than 0 and "Should this asset share a tag with Master" = "Yes" then make "Send Tag to FA team" editable. OR if "Contact (First Last Name)" is not blank AND "Tag will be mailed to this address" is not blank then make "Send Tag to FA team" editable. This did not work and so I elaborated on the above as shown in the screenshot. That too does not work. As soon I type in a Contact (First Last) name, the "Send Tag to FA team" becomes editable. You can see from the OTHERWISE statement that it did not read my logic correctly at all. How do I fix this? Thanks!Re: Table relationship with a formula field in child table
Hi Mark, What you suggested is working beautifully but now I need a creative solution for confirming if each line in this embedded report that you helped me design above has a checkmark against a column called "Ready for processing." This checkbox field triggers a set of rules in the table and ensures that required fields are filled in etc. So I need each line in this embedded report to have a checkbox before they can continue to process the report and send it for approvals. Any ideas of how I may achieve that? So in the record above - Asset Capitalization request #27 has a number of assets that need to be capitalized - shown in the report to the right. You can see that I was playing with Line # and counting the number of checkboxes with "True" for "Ready for processing." "Ready for approvals" in the 2nd section in the form should be editable only if each line in the report has "Ready for processing" checked. how do i confirm that? Thanks!! deepa ------------------------------ Deepa Prashant ------------------------------
