AnsweredAssumed Answered

When hiding a field, I'd like to clear the field...

Question asked by billr@stcu.org on Jun 9, 2017
Latest reply on Jun 12, 2017 by emha

Like • Show 0 Likes0
Comment • 7

... w/o having to write a chunk of JS code each time. Is there something built into the Rules Engine to clear a field when it is hidden by a rule? I've searched the Nintex Connect Community for hours

Why would I want to do this you ask?

If a form user fills in a field that becomes irrelevant and is hidden, why would I want to store the irrelevant data?

Don't you just hate people who answer a question with a question?

I've written Custom JS to take care of it, but am hoping there is something built in. A function/method, etc.

Thanks mis amigos!

billr@stcu.org Jun 12, 2017 7:36 AM

Correct Answer

Just tested and the outcome is what I expected.

I selected the choice in the dropdown that shows the field

I filled in the field

Change my choice in the dropdown (thus hiding the field)

Submitted the form

Filed value was submitted

Maybe I'm out on a limb here, but that is not desirable behavior.

If there is nothing built in, I will stick with my custom JavaScript solution.

See the reply in context

1 person had this question

Outcomes

pwarrak@iss-mea.com

Jun 10, 2017 3:10 AM

Hi,

If you aim to save empty value once field is hidden, add a calculated value connected to the same SP list column as per the fiel and set its visibility rule to the opposite of the field. Keep the calculated value empty so that once field is hidden, calculated value is shown and save empty value to SP list connected column.

*- Make sure to work on visibility from control settings (Expression) so HTML of the field/calculated value is totally removed from the page and thus no save conflict will happen.

Regards,

1 person found this helpful

Actions

praios81

@ pwarrak@iss-mea.com on Jun 11, 2017 11:21 PM

Really like this tip but the visibility expression doesn't allow to reference named controls. If I'd use a checkbox to hide the first control I can't check the same checkbox in the visibility expression, right? Or do I miss something?

Actions

billr@stcu.org @ pwarrak@iss-mea.com on Jun 12, 2017 7:21 AM

No intention on saving an empty value one the field is hidden. Why would I do that? I find this answer somewhat strange in that my question had nothing about saving. I asked if there was something built in to clear the field upon being hidden.

Perhaps a little more detail will help. :)

I have a drop down.

In the drop down there is one item that triggers a field to be unhidden.

If for some reason a form user should fill this field in with data and then decide to change their drop down choice, hidding the field they just filled in, I want it to be cleared. The data has become irrelivent as the drop down choice has changed.

I clear the field using javascript now. Works fine. Just wondered why there wouldn't be an option to clear the filed once it is hidden. Thus preventing the capture of irrelivent data.

As I read my response, I wonder if hidden values are even saved, hmmmmm. I'm gonna do some testing...

Actions

emha

@ billr@stcu.org on Jun 12, 2017 7:34 AM

unfortunatelly, there is not anything OOTB that would clear hidden controls.

only available option is javascript.

and yes, once hidden controls are connected to list fields they will be saved (sometimes that's very useful ...)

Actions

billr@stcu.org @ emha on Jun 12, 2017 7:40 AM

Ya, I see where it could be useful (Tabs, Wizards, etc.), however, an option in the field settings would allow either behavior or a method in the Rules Builder.

Oh, well, worth the ask.

Thanks all!

Actions

emha

@ billr@stcu.org on Jun 12, 2017 1:12 PM

I understand you haven't got an answer you expected, but just to close the topic could you mark one of the posts as correct answer?

Actions

billr@stcu.org @ pwarrak@iss-mea.com on Jun 12, 2017 7:36 AM

Just tested and the outcome is what I expected.

I selected the choice in the dropdown that shows the field

I filled in the field

Change my choice in the dropdown (thus hiding the field)

Submitted the form

Filed value was submitted

Maybe I'm out on a limb here, but that is not desirable behavior.

If there is nothing built in, I will stick with my custom JavaScript solution.

Actions

7 Replies

pwarrak@iss-mea.com Jun 10, 2017 3:10 AM
Mark Correct
Correct Answer
Hi,

If you aim to save empty value once field is hidden, add a calculated value connected to the same SP list column as per the fiel and set its visibility rule to the opposite of the field. Keep the calculated value empty so that once field is hidden, calculated value is shown and save empty value to SP list connected column.

*- Make sure to work on visibility from control settings (Expression) so HTML of the field/calculated value is totally removed from the page and thus no save conflict will happen.

Regards,
1 person found this helpful
Like • Show 2 Likes2
Actions
- praios81 @ pwarrak@iss-mea.com on Jun 11, 2017 11:21 PM
  Mark Correct
  Correct Answer
  Really like this tip but the visibility expression doesn't allow to reference named controls. If I'd use a checkbox to hide the first control I can't check the same checkbox in the visibility expression, right? Or do I miss something?
  Like • Show 0 Likes0
  Actions
- billr@stcu.org @ pwarrak@iss-mea.com on Jun 12, 2017 7:21 AM
  Mark Correct
  Correct Answer
  No intention on saving an empty value one the field is hidden. Why would I do that? I find this answer somewhat strange in that my question had nothing about saving. I asked if there was something built in to clear the field upon being hidden.
  Perhaps a little more detail will help. :)
  
  I have a drop down.
  In the drop down there is one item that triggers a field to be unhidden.
  If for some reason a form user should fill this field in with data and then decide to change their drop down choice, hidding the field they just filled in, I want it to be cleared. The data has become irrelivent as the drop down choice has changed.
  I clear the field using javascript now. Works fine. Just wondered why there wouldn't be an option to clear the filed once it is hidden. Thus preventing the capture of irrelivent data.
  
  As I read my response, I wonder if hidden values are even saved, hmmmmm. I'm gonna do some testing...
  Like • Show 1 Like1
  Actions
  - emha @ billr@stcu.org on Jun 12, 2017 7:34 AM
    Mark Correct
    Correct Answer
    unfortunatelly, there is not anything OOTB that would clear hidden controls.
    only available option is javascript.
    
    and yes, once hidden controls are connected to list fields they will be saved (sometimes that's very useful ...)
    Like • Show 1 Like1
    Actions
    - billr@stcu.org @ emha on Jun 12, 2017 7:40 AM
      Mark Correct
      Correct Answer
      Ya, I see where it could be useful (Tabs, Wizards, etc.), however, an option in the field settings would allow either behavior or a method in the Rules Builder.
      
      Oh, well, worth the ask.
      
      Thanks all!
      Like • Show 2 Likes2
      Actions
      - emha @ billr@stcu.org on Jun 12, 2017 1:12 PM
        Mark Correct
        Correct Answer
        I understand you haven't got an answer you expected, but just to close the topic could you mark one of the posts as correct answer?
        Like • Show 1 Like1
        Actions
- billr@stcu.org @ pwarrak@iss-mea.com on Jun 12, 2017 7:36 AM
  Unmark Correct
  Correct Answer
  Just tested and the outcome is what I expected.
  I selected the choice in the dropdown that shows the field
  I filled in the field
  Change my choice in the dropdown (thus hiding the field)
  Submitted the form
  Filed value was submitted
  
  Maybe I'm out on a limb here, but that is not desirable behavior.
  If there is nothing built in, I will stick with my custom JavaScript solution.
  Like • Show 2 Likes2
  Actions

When hiding a field, I'd like to clear the field...

Outcomes

Related Content

Recommended Content