Set Field Value Not Working - InfoPath Dev
in

InfoPath Dev

Set Field Value Not Working

Last post 11-20-2017 08:52 AM by kmgosselin. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-16-2017 11:02 AM

    Set Field Value Not Working

     Hi all! I have a simple InfoPath Form that I publish to SharePoint Online. One field (Cost1) has a formula (Constant1 * Volume + Constant2 + Constant3 * Height). However the value of Constant2 always shows in the field when the form is opened. The field then updates as the user enters data into the other fields (Volume and Height). I want Cost1 to show blank when the user opens the form. I even tried creating a new field (Cost1A) where I have a rule to set the value of Cost1A to equal Cost 1 and not show the Cost1 field. However nothing appears in the field Cost1A. Any ideas?

  • 11-20-2017 07:33 AM In reply to

    Re: Set Field Value Not Working

     If you want the field blank on open, don't use a default, use rules. You need to set the same rules on EVERY field involved - Constant1, Volume, Constant2, Constant3 and Height - because any time any one of these changes, you want to reset Cost1 accordingly.

    I'm guessing Constant2 always has a value - is that why Cost1 always shows that value? 

    Hilary Stoupa

  • 11-20-2017 08:52 AM In reply to

    Re: Set Field Value Not Working

     Thanks for the tips. I'll rework it using rules instead.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.