Help! How can I reset a Vizlib Input Form with the click of a button? (Using variable as the Destination)
Hello all,
Could desperately use some advice!!
I am working with a Vizlib Input Form and have set the writeback settings to writeback the inputs as a variable as a destination instead of a qvd or server. Each of my input fields in the form have a variable and also a field name(but i dont think the field name matters in this case). I have created the variables in the lower left hand corner of the qlik sheet and left all of their expressions as blank(ex: vSales = nothing in expression field) and there is a different variable bound to every single input field(some are text input, numeric input, dropdown, radio button, checkbox etc).
So upon clicking 'Submit', the form saves all the inputs as variables. I have a button that navigates me to another sheet with a separate writeback table that populates with the inputs from the form via partial load and then I make some edits in THAT writeback table and click submit and the table is written into a qvd.
THE PROBLEM: When I navigate BACK to the original Input Form, the inputs are still the same as the last entry. I have tried setting the variables as blank, '', null() upon clicking any button that navigates away from the input form so that it clears out the form but even when I check by viewing the variable value in a text/image box and can SEE the variable has been cleared, the form remains filled out with the original inputs.
Can anyone help me with this? I must find a way to reset the form without having to click 'Reset Form' button every time. Very much need to find a solution to this soon and any help is greatly appreciated!!
