Search - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Search

Page 1 of 1 (8 items)
  • Set a field value IF/OR Based on two fields

    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 ...
    Posted to Newbie Questions (Forum) by DarthBrute on 08-31-2021
  • Autopopulate text field based on sharepoint list lookup

    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 | ...
    Posted to SharePoint Integration (Forum) by DarthBrute on 03-29-2021
  • Re: Display text based on Value

    Everything works thank you very much!
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
  • Re: Display text based on Value

    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.
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
  • Re: Display text based on Value

    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 ...
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
  • Re: Display text based on Value

    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.
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
  • Re: Display text based on Value

    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
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
  • Display text based on Value

    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 ...
    Posted to Newbie Questions (Forum) by DarthBrute on 05-15-2018
Page 1 of 1 (8 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.