Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Problems with changing column width in browse tab
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am
Problems with changing column width in browse tab
Hi,
Recently I have had some problems with changing the column width in the browse tab with new forms. I created a new form using the forms wizard. The table only has 2 columns with a primary key and one additional field called cat_category. The form wizard created the table without a problem. I can do all of the normal things with the form including adding data.
But, when I try to change the width variable for the field in the browse tab, the width turns to 'undefined'. When I save it, the width variable turn to zero and the column does not display a heading or any data. Here are the screen shots:
Here is the browse tab for the form before attempting to change the width: When I tried to change the width to 200, the width said 'undefined': When I click on 'save', the width changes to '0': The column heading and data then disappear from the browse form but the column heading and data are still displayed in the edit form.
This happens with multiple new forms. I did not have problems with this in the past.
Do you have any suggestions on what is causing this problem?
Thanks,
John Klassen
Recently I have had some problems with changing the column width in the browse tab with new forms. I created a new form using the forms wizard. The table only has 2 columns with a primary key and one additional field called cat_category. The form wizard created the table without a problem. I can do all of the normal things with the form including adding data.
But, when I try to change the width variable for the field in the browse tab, the width turns to 'undefined'. When I save it, the width variable turn to zero and the column does not display a heading or any data. Here are the screen shots:
Here is the browse tab for the form before attempting to change the width: When I tried to change the width to 200, the width said 'undefined': When I click on 'save', the width changes to '0': The column heading and data then disappear from the browse form but the column heading and data are still displayed in the edit form.
This happens with multiple new forms. I did not have problems with this in the past.
Do you have any suggestions on what is causing this problem?
Thanks,
John Klassen
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: Problems with changing column width in browse tab
John, can you edit the width value directly from Setup > Objects?
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am
Re: Problems with changing column width in browse tab
Max,
I went into Setup --> Objects, searched on cat_category. and went to the 'text' tab. Although the browse tab showed the width as 100, the text tab for the object was set to 10.00. I changed the width to 300.00. When I went back to the browse tab for the form, the width is still set to 100.
Am I changing it in the wrong place?
John
I went into Setup --> Objects, searched on cat_category. and went to the 'text' tab. Although the browse tab showed the width as 100, the text tab for the object was set to 10.00. I changed the width to 300.00. When I went back to the browse tab for the form, the width is still set to 100.
Am I changing it in the wrong place?
John
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: Problems with changing column width in browse tab
John, sorry I messed up: the right place where to set column width is the Browse tab on the form.
What happens to you it's strange: I suspect that some records are missing in system tables.
Try this temporary solution:
EDIT:
John,
in Setup > Objects search for "browseColumns": you should get this objects: Also, try to reload browse.php from a previous backup (or extract from a fresh download).
Max
What happens to you it's strange: I suspect that some records are missing in system tables.
Try this temporary solution:
- in phpmyadmin select the zzsys_form table and search your form;
- copy the zzsys_form_id value;
- in SQL tab, copy and execute this code:The return is the list of all "columns" shown in the Browse tab of your form;
Code: Select all
SELECT * FROM `zzsys_browse` WHERE `sbr_zzsys_form_id` = 'your-zzsys_form_id'
- select your field and change the value in sbr_width column
- reopen/refresh application page and try to see if it's working
EDIT:
John,
in Setup > Objects search for "browseColumns": you should get this objects: Also, try to reload browse.php from a previous backup (or extract from a fresh download).
Max
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am
Re: Problems with changing column width in browse tab
Max,
I tried replacing browse.php but it didn't make a difference. On the other hand, your temporary solution does work.
I also tried searching for "browseColumns" in Objects but was not sure what to do with it.
For now I will use the temporary solution.
Thanks,
John
I tried replacing browse.php but it didn't make a difference. On the other hand, your temporary solution does work.
I also tried searching for "browseColumns" in Objects but was not sure what to do with it.
For now I will use the temporary solution.
Thanks,
John
-
- Posts: 14
- Joined: Thu Oct 24, 2013 6:32 am
Re: Problems with changing column width in browse tab
I believe there is some problem with the formatting of some fields in some browsers/browser configurations.
I get the same 'undefinedundefinedundefined' value into some fields for some users in Internet Explorer (but not for other), and then a 0 is saved to the database when pressing Save. In Chrome or Firefox it never happens. I have had to tell everyone to only use Chrome or Firefox.
Anyone else who have seen this problem or solved it?
John
I get the same 'undefinedundefinedundefined' value into some fields for some users in Internet Explorer (but not for other), and then a 0 is saved to the database when pressing Save. In Chrome or Firefox it never happens. I have had to tell everyone to only use Chrome or Firefox.
Anyone else who have seen this problem or solved it?
John
-
- Posts: 84
- Joined: Mon Jul 04, 2011 12:52 am
Re: Problems with changing column width in browse tab
There are some other problems with various IE versions.Internet Explorer
It's banal, but my solution was to set a restriction that users can't log in with IE. (every other browser, but not IE).
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am
Re: Problems with changing column width in browse tab
Do you think that upgrading to nuBuilder 3.0 will fix the problem or do I need to give up IE?
John
John
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: Problems with changing column width in browse tab
John, nuBuilder-2 projects are not compatible with nuBuilderPro: there could be some work to do to upgrade your project to nuBuilderPro.JohnKlassen wrote:Do you think that upgrading to nuBuilder 3.0 will fix the problem or do I need to give up IE?
What version of IE are you running? Maybe upgrading IE?
Max
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am