I have the following issue:
I'm doing a multipage form. When the user clicks Next on the first page, a Save to dB action is triggered with Insert as the action and then Display Section two in the Success action. This works perfect.
However, after completing page 2, I have a 2nd Save to dB action with UPDATE as the action. The issue is, that the update then updates ALL records in the table with the values of the form fields.
I've tried setting the the Update Conditions to:
phone:{data:phone} where 'phone' is the name of a text field on page 2 and also the name of a field in the dB table.
This is not working and only updates records where phone is empty. It appears {data:phone} is not capturing the value typed in the 'phone' field on the form.
If I set the Update Conditions to:
phone:1112223333 and then enter 1112223333 in the 'phone' field on the form it works as expected. So again I think its that {data:phone} is not capturing the form data.
Now the funny thing is, if I use {data:phone} in the body of an Email function, it gets captured properly. What am I doing wrong?? I hope someone can help. I've read through the forums and have tried using this php custom code before the Save action:
$this->data['phone'] = $this->data['phone']; and then putting phone:{data:phone} in the Update Conditions but then it again updates ALL records where 'phone' is empty.
I'm doing a multipage form. When the user clicks Next on the first page, a Save to dB action is triggered with Insert as the action and then Display Section two in the Success action. This works perfect.
However, after completing page 2, I have a 2nd Save to dB action with UPDATE as the action. The issue is, that the update then updates ALL records in the table with the values of the form fields.
I've tried setting the the Update Conditions to:
phone:{data:phone} where 'phone' is the name of a text field on page 2 and also the name of a field in the dB table.
This is not working and only updates records where phone is empty. It appears {data:phone} is not capturing the value typed in the 'phone' field on the form.
If I set the Update Conditions to:
phone:1112223333 and then enter 1112223333 in the 'phone' field on the form it works as expected. So again I think its that {data:phone} is not capturing the form data.
Now the funny thing is, if I use {data:phone} in the body of an Email function, it gets captured properly. What am I doing wrong?? I hope someone can help. I've read through the forums and have tried using this php custom code before the Save action:
$this->data['phone'] = $this->data['phone']; and then putting phone:{data:phone} in the Update Conditions but then it again updates ALL records where 'phone' is empty.
