Community > Answers

How can we help you today?

Ask Question
Manage notifications
Subscribe to this question
83 views

Update a field by executing a SQL Query - Not Working

Hi,

I have added an action to update a field (Checkbox) by executing a SQL Query and while viewing the form it properly updates the values of the Checkbox options. However, when the form is submitted the values are not actually saved. When viewing submissions that field is always blank and when the email notification comes it is also blank. Has anyone else experienced this and if so is there a fix?

Thanks!

Josiah Olhava Josiah Olhava
asked 09/11/2019 04:07
Add Comment
Last Activity 09/13/2019 17:11

1 Answer(s)

  • answered 09/11/2019 19:37
    Mandeep Singh

    That's not possible due to security reasons. A checkbox list has pre-defined options; user cannot modify them. Therefore, you cannot use a Client Side action to change the values. 

    Let's say you were selling something for $200; any clever user would be able to change the value to $2 using JavaScript. Hence, the values are not saved. 

    You can only change the values on client side for fields that allow user input such as a textbox. 

    You must bind the Checkbox at server side. Try the "Update multiple form fields by executing a SQL Query". That is executed server side. 

    Add Comment
    Josiah Olhava
    replied 09/13/2019 05:51

    Hello, 

    Yes, that is exactly the action I am using please see my first sentence (it is also the title of my post):

    "I have added an action to update a field (Checkbox) by executing a SQL Query..."

    Please let me know a fix for this.

    Anthony Lightbourne
    replied 09/13/2019 13:44

    I assume when you are talking about the value of a checkbox you are talking about whether it is checked or not. Not the actual definition of the check box. Using a stored procedure to check a check box on form view?

    Mandeep Singh
    replied 09/13/2019 17:11

    As indicated, "Bind or update a single form field via SQL Query" will not work in your scenario due to security reasons. 

    You may try and use "Bind multiple form fields via SQL Query" which works differently. 

    Reply
Add an Answer