# Does change in constraint on variable mean new table? **URL:** \ **Category:** Support\ **Created:** [February 14, 2017, 1:29pm UTC](https://forum.getodk.org/t/does-change-in-constraint-on-variable-mean-new-table/6284 "2017-02-14T13:29:15Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Ayoub\_Kakande](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ayoub_kakande/32/27358_2.png) [@Ayoub\_Kakande](https://forum.getodk.org/u/Ayoub_Kakande)\ **Post date:** [February 14, 2017, 1:29pm UTC](https://forum.getodk.org/t/does-change-in-constraint-on-variable-mean-new-table/6284/1 "2017-02-14T13:29:15Z")
Hello, Thanks for the good work all. I have an uploaded form and data capture has been ongoing, However I want to edit some constraints, e.g a particular variable has been allowing only .=60 or .=65 or .= 80, now I want to add .=100 or .=200. my question is how do I do this onto the existing form without creating a new table since new forms automatically create new tables in MYSQL. All help will be much appreciated. > **···** > > -- \*\*In sun set years education is not associated with standard of living and medical care access; it is the the financial myosin and actin!!! > > \*\*\*\* Don't give me fish, teach me how to fish > > Kayoub K > 0772656158 / 0703516660 > Data Manager > Mujhu Research Collaboration > Mulago Hosp > Msc Enterprise Architecture ---
**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\ **Post date:** [February 14, 2017, 6:31pm UTC](https://forum.getodk.org/t/does-change-in-constraint-on-variable-mean-new-table/6284/2 "2017-02-14T18:31:22Z")
To update an existing form definition (which is possible as long as you do not add or remove fields or change a field data type or change a field from a data-entry field to a calculated field), you need to define a version string. See [https://opendatakit.org/help/form-design/guidelines/](https://opendatakit.org/help/form-design/guidelines/) This documentation has unfortunately not made it onto [xlsform.org](http://xlsform.org) > **···** > > On Tue, Feb 14, 2017 at 5:29 AM, Ayoub Kakande wrote: > > > Hello, > > Thanks for the good work all. > > I have an uploaded form and data capture has been ongoing, However I want > > to edit some constraints, e.g a particular variable has been allowing only > > .=60 or .=65 or .= 80, now I want to add .=100 or .=200. > > my question is how do I do this onto the existing form without creating a > > new table since new forms automatically create new tables in MYSQL. > > > > All help will be much appreciated. > > > > -- > > \*\*In sun set years education is not associated with standard of living and > > medical care access; it is the the financial myosin and actin!!! > > > > \*\*\*\* Don't give me fish, teach me how to fish > > > > Kayoub K > > 0772656158 / 0703516660 > > Data Manager > > Mujhu Research Collaboration > > Mulago Hosp > > Msc Enterprise Architecture > > > > ## -- > > > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > > > * * * > > > > You received this message because you are subscribed to the Google Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > Mitch Sundt > Software Engineer > University of Washington > [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com) ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [February 15, 2017, 9:08am UTC](https://forum.getodk.org/t/does-change-in-constraint-on-variable-mean-new-table/6284/3 "2017-02-15T09:08:26Z")
Hélène has filed a documentation fix at [https://github.com/XLSForm/xlsform.github.io/pull/82](https://github.com/XLSForm/xlsform.github.io/pull/82). It'll be in the docs after the pyxform team reviews it. Yaw > **···** > > On Wed, Feb 15, 2017 at 2:31 AM, Mitch Sundt wrote: \> To update an existing form definition (which is possible as long as you do \> not add or remove fields or change a field data type or change a field from \> a data-entry field to a calculated field), you need to define a version \> string. See https://opendatakit.org/help/form-design/guidelines/ \> \> This documentation has unfortunately not made it onto xlsform.org \> \> \> On Tue, Feb 14, 2017 at 5:29 AM, Ayoub Kakande wrote: \>\> \>\> Hello, \>\> Thanks for the good work all. \>\> I have an uploaded form and data capture has been ongoing, However I want \>\> to edit some constraints, e.g a particular variable has been allowing only \>\> .=60 or .=65 or .= 80, now I want to add .=100 or .=200. \>\> my question is how do I do this onto the existing form without creating a \>\> new table since new forms automatically create new tables in MYSQL. \>\> \>\> All help will be much appreciated. \>\> \>\> -- \>\> \*\*In sun set years education is not associated with standard of living and \>\> medical care access; it is the the financial myosin and actin!!! \>\> \>\> \*\*\*\* Don't give me fish, teach me how to fish \>\> \>\> Kayoub K \>\> 0772656158 / 0703516660 \>\> Data Manager \>\> Mujhu Research Collaboration \>\> Mulago Hosp \>\> Msc Enterprise Architecture \>\> \>\> -- \>\> -- \>\> Post: opendatakit@googlegroups.com \>\> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \>\> Options: http://groups.google.com/group/opendatakit?hl=en \>\> \>\> --- \>\> You received this message because you are subscribed to the Google Groups \>\> "ODK Community" group. \>\> To unsubscribe from this group and stop receiving emails from it, send an \>\> email to opendatakit+unsubscribe@googlegroups.com. \>\> For more options, visit https://groups.google.com/d/optout. \> \> \> \> \> -- \> Mitch Sundt \> Software Engineer \> University of Washington \> mitchellsundt@gmail.com \> \> -- \> -- \> Post: opendatakit@googlegroups.com \> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> --- \> You received this message because you are subscribed to the Google Groups \> "ODK Community" group. \> To unsubscribe from this group and stop receiving emails from it, send an \> email to opendatakit+unsubscribe@googlegroups.com. \> For more options, visit https://groups.google.com/d/optout.