With all my formula questions it was advised to me to try to break them down and test each part and as they are successful put them together. However, I can't get each part of this formula to work. I have a hidden field - Existing Material Job Number - that appears when the question update to existing job is answered as yes. I want that field to also be required if it is answered as yes. However, I can't find a formula that works appropriately. I've tried all the below and then some. Please help. I started with the Update to Existing Job being a check box and didn't get anywhere so I changed it a radio button and still haven't had any luck.
UpdatetoExistingMaterial=='Yes' doesn’t recognize that it is required
UpdatetoExistingMaterial!='Yes' recognizes that it is required but doesn’t recognize that it is completed
UpdatetoExistingMaterial!='No' recognizes that it is required when yes is chosen but doesn’t recognize that it is completed
UpdatetoExistingMaterial=='No' doesn’t recognize that it is required
ExistingMaterialJobNumber=='' recognizes that is required and releases when completed but it isn’t required all of the time so it needs another condition.
ExistingMaterialJobNumber!='' doesn’t recognize it as required.
UpdatetoExistingMaterial!='Yes'&&ExistingMaterialJobNumber==’’ recognizes that it is required and releases when it is completed but holds up other submissions where this field is hidden or no
UpdatetoExistingMaterial=='Yes'&&ExistingMaterialJobNumber==’’ doesn’t recognize that is required
UpdatetoExistingMaterial!='No'&&ExistingMaterialJobNumber=='' recognizes that it is required when yes is chosen and recognizes that it is completed but holds up other question when the field is hidden/answer is to update is no
UpdatetoExistingMaterial!='No'&&ExistingMaterialJobNumber!='' doesn’t recognize that is required
Hey Jennifer, this should work for you.
Are you putting Existing Material Job Number inside a panel?
Marian Hatala I started with the UpdateToExistingMaterial being a checkbox where checked = Yes. When I continued to have trouble with it I changed it to a yes/no radio button. It can be whatever works best.
if you use Yes/No checkbox it evaluates directly to true/false (boolean) value, so you shouldn't compare it with strings "Yes" or "No"
formula to hide material job number (panel) should then simply look like this
if you use choice radio buttons they evaluate to values to options you defined for choice control. so in that case you correctly compared them against strings "Yes" or "No"
for this case to hide material job number (panel) until "Yes" option is chosen, the formula should look like
to make material job number mandatory if update required, you have to combine check for an update option chosen with a check for job number control emptyness.
so, eg. for radio buttons it would look like