GitLab

Summary

Values edited in FormHandler table aren't updated in database.

Steps to Reproduce

• Edit a value in FormHandler Table
• Save the updated values, it works fine
• Reload the page, old values are displayed

gramex.yaml end point:

   pmrssm-form-available-state-info:
      pattern: /$YAMLURL/table_available_states_info                                         
      handler: FormHandler
      kwargs:
        url: 'mysql://$MYSQL_USER:$MYSQL_PASSWORD@$MYSQL_HOST/pmrssm_forms_db'           
        query: select * from available_states_info;# DB Query
        table: available_states_info
        id: [state_code, district_code, mobile_number]

javascript

<script>
		$(window).on('load', function () {
	
			$('.formhandler').formhandler({
					columns:[{name: '*'},{editable: true}],
				edit: true,
					table: true
			})
		});
	</script>