InfoPath Dev

I want to concat a few fields together to maintain a unique Title for sharepoint list items. However due to URL length restrictions I need to cut down the size of the title. In order to do that I want to identify two fields (FieldA and FieldB) to use. FIELDA will never not be empty. It is a required field. If FIELDA is not empty and ...

I have a field named NTAG It is a lookup field from a list Called NTAG Lookup. This list has 3 columns: NTAG | TAOC | REGION Now I already have a data connection set up for that list as there is a dropdown for NTAG and a cascading dropdown for TAOC. I also have another lookup list called Region Lookup. It has 2 columns: NTAG | ...

Everything works thank you very much!

I think so but only after I played around for a bit. What ended up working was I removed the formula in default value of ACOST / #QI from the field. Then set #QI to do the math based on its own value. =0 then make NCPQI blank, if #QI is blank then make NCPQI blank. But it works on the preview I'll see if it works on the SharePoint.

I see what you are saying. That worked perfectly! I just had to modify the rules a bit too. Also, when a field (NRD CPQI) is for currency only how do I bypass the error when the field returns "Infinity" and has a red dashed border? I tried rules to replace it but that isn't working. That is happening when ACTUAL COST is being divided ...

Attached. Be aware it does have a connection to my sharepoint and it may ask for credentials. You should be able to cancel on that. The GOOD, BAD, and OK fields are hidden but lay at the bottom of the form.

I had everything typed up. But not everything appears when I post it here. I continued my question over at msdn. https://social.msdn.microsoft.com/Forums/office/en-US/d6c608f4-a88d-495c-b095-b8e6c0e5ae3e/display-text-based-on-field-value?forum=sharepointcustomizationlegacy#d6c608f4-a88d-495c-b095-b8e6c0e5ae3e

Really new to Infopath. I did do some searching and I found rules as there is no IF statement for xpath. What I am trying to do is move a spreadsheet to SharePoint. One of my cells for calculation has this formula: =IF(C26>=H26,"BAD",IF(C26>=G26,"OK",IF(C26= BAD (Set a fields Value: BAD) NCPQI >= OK (Set a fields ...