Edit "num" field
2 posts by 2 authors in: Forums > CMS Builder
Last Post: April 29, 2011 (RSS)
By Toledoh - April 29, 2011
Hi all.
I've got a table of "categories" and I use the num field to sort them.
The client has now asked that I add a new category, and insert it in the middle of the of others.
As the fields nums currently are 11, 12, 13, 14 etc I need to create another record, then edit the record nums.
I have changed the num field so that "System field editing is currently enabled" bnut I still cant edit the num field...
any suggestions?
I've got a table of "categories" and I use the num field to sort them.
The client has now asked that I add a new category, and insert it in the middle of the of others.
As the fields nums currently are 11, 12, 13, 14 etc I need to create another record, then edit the record nums.
I have changed the num field so that "System field editing is currently enabled" bnut I still cant edit the num field...
any suggestions?
Cheers,
Tim (toledoh.com.au)
Tim (toledoh.com.au)
Re: [Toledoh] Edit "num" field
By Jason - April 29, 2011
Hi Tim,
"num" is the most important field in any CMS Builder section, as it's the way we uniquely identify a record. Changing the "num" field can cause all sorts of problems. For example, if you were to change the num field, you'd lose all of your uploads for that record. So we don't provide any way of changing the num field. The only way you could do it would be directly through MySQL. However, we DON'T recommend ever doing this.
The best solution would be to sort on a different field. In this case, I would suggest using dragSortOrder to manually sort your fields. Then, if you ever needed to insert a record directly into your list using the free Create Record Here plugin:
http://www.interactivetools.com/add-ons/detail.php?Create-Record-Here-1015
Hope this helps
"num" is the most important field in any CMS Builder section, as it's the way we uniquely identify a record. Changing the "num" field can cause all sorts of problems. For example, if you were to change the num field, you'd lose all of your uploads for that record. So we don't provide any way of changing the num field. The only way you could do it would be directly through MySQL. However, we DON'T recommend ever doing this.
The best solution would be to sort on a different field. In this case, I would suggest using dragSortOrder to manually sort your fields. Then, if you ever needed to insert a record directly into your list using the free Create Record Here plugin:
http://www.interactivetools.com/add-ons/detail.php?Create-Record-Here-1015
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/